Update data row of dataset /datatable

If you want to update the row based on column value of dataset / datatable , you will do as:

Suppose you have a dataset named dataset1 having table with name TableName". Table have 2 column named ColumnName1, ColumnName2, ColumnName3.

You want to update Row having ColumnName1='Value1'

DataRow[] Row = dataSet1.Tables["TableName"].Select("ColumnName1= 'Value1'");

Row [0]["ColumnName2"] = "Value2";
Row [0]["ColumnName3"] = "Value3";