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

Answer 1

If the database column is type of string then it recommend you to change the datatype to decimal, it will help you in future and many more queries.

 

However, if currency contains ,(comma) and you need to validate that by using the replace method

 

String cur ="12,000";

var value = Convert.ToDecimal (curr.Replace (",", "");

 

// now value contains only numbers without and seperator