How to replace empty column as "ND" using ASP.NET C#?

Question

I want to set value for particular empty column in data set data table as "ND" in data set.

How to do it?

What I have tried:

if (ds.Tables[s].Rows[i][Columncountvalue + 19].ToString().Trim() == "")
 {  
ds.Tables[s].Rows[i][Columncountvalue + 19].ToString().Trim().Replace("", "ND");
 }

the above code is i tried to fill the empty column as "ND" in dataset data table but below error is occurs

string cannot be of zero length. parameter name oldvalue

Mangesh Gaherwar · Answer

Hey Raja Can u try this Please also U make sure u add acceptchanges after update foreach (DataRow dr in ds.Tables[0].Rows) { if (dr[UseColumnName]==) { dr[UseColumnName] = ND; } } ds.Tables[0].AcceptChanges();

Jasbeer Singh · Answer

you can do this in database as well DB : ISNULL(CAST(ColumnName as Varchar(100)) 'ND') or IN asp.NET C# code as: .Replace( ND); But you can try DB approach if data is coming from DB.

Mangesh Gaherwar · Answer

Hey Raja Try ds.Tables[s].Rows[i][Columncountvalue + 19].ToString().Trim().Replace(  ND); Seems it is giving u issue considering u r trying to update the old value which is of 0 Length Hope it Helps Mark as aporved if it does

Raja · Answer

Mangesh Gaherwar Thank YOu

Raja · Answer

hi Mangesh Gaherwar but this not replace empty ND .there are no values is added in the column still empty.bcoz of the cell is trim() so the cell value is () i have mention (  ND) so no value is added .i remove the trim() but not replace as ND :(