remove chars from field in dataset

[arkadia93]

How do you remove all chars such as carriage return and new line from a particular field for all records in a dataset?

 

[arkadia93]

Found the answer :

foreach(DataRow dr in ds.Tables["LeadDetails"].Rows)
{
dr["Activity"] = dr["Activity"].ToString().Replace("\r", "");
dr["Activity"] = dr["Activity"].ToString().Replace("\n", "");
dr["Activity"] = dr["Activity"].ToString().Replace("\t", "");
}

 

[Nemhain]

If you're going to be looping through a lot of records, I'd use constants for those string literals, use String.Empty for the zero-length strings, and use the StringBuilder class to do the replaces.

It could get you a noticeable performance increase.