c# - datatable if one field is null set another value

Question

I have a Datatable.

using (DataSet ds = new DataSet())
{
    da.Fill(ds);
    dt = ds.Tables[0];
}

The dt, return list of data like this,

From this image, when UserId is DBnull then I want to set docCount equl to 0. How can I do that?

Christos · Accepted Answer · 2016-11-11 18:47:53Z

2

You could try something like this:

dt = ds.Tables[0];
foreach(DataRow row in dt.Rows)
{
   if(row["userId"] == DBNull.Value)
   {
       row["docCount"] = 0;
   }
}

answered Nov 11, 2016 at 18:41

Christos

54.1k9 gold badges82 silver badges114 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

You should DBNull.Value instead of null