Tuesday 30 September 2014

update colmn value in C# datatable

var rowsToUpdate = 
    dt1.AsEnumerable().Where(r => r.Field<decinmal?>("Series1") == -999);

foreach(var row in rowsToUpdate)
{
    row.SetField("Series1", DBNull.Value);    row.SetField("Series2", DBNull.Value);}

No comments:

Post a Comment