How to remove white spaces in asp.net?

asp.net sql removing-whitespace
user1225988 picture user1225988 · Feb 24, 2012 · Viewed 8.3k times · Source

I am retrieving data from a DB table using SqlDataReader in ASP.net. I append the retrieved data in a string builder and after that, dump the contents of the string builder into a text file. My problem is that in that text file white spaces are showing up between one column and another ... How can I remove the excess white spaces from my text file?

Thanks in advance.

Answer

thevan picture thevan · Feb 24, 2012 
1. Text.Trim();
2. Text.Replace(" ", string.empty);

Related questions

Read SQL Table into C# DataTable

I've read a lot of posts about inserting a DataTable into a SQL table, but is there an easy way to pull a SQL table into a .NET DataTable?

Read More
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints

I make an outer join and executed successfully in the informix database but I get the following exception in my code: DataTable dt = TeachingLoadDAL.GetCoursesWithEvalState(i, bat); Failed to enable constraints. One or more rows contain values violating non-null, unique, …

Read More
Index (zero based) must be greater than or equal to zero

Hey I keep getting an error: Index (zero based) must be greater than or equal to zero and less than the size of the argument list. My code: OdbcCommand cmd = new OdbcCommand("SELECT FirstName, SecondName, Aboutme FROM User WHERE UserID=1", …

Read More