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

Raja

9y3.3k.NET

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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mangesh G9y ago
Accepted 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();
Raja9y ago
Mangesh Gaherwar
Thank YOu
Jasbeer Singh9y ago
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.
Raja9y ago
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" :(

Mangesh G9y ago

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

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

Mangesh Gaherwar

Mangesh Gaherwar