I'm wondering if it's possible to add values to specific DataTable cells? Suppose I have an existing dataTable and I add a new column, how would I go about adding to the new column's rows without overwriting the existing columns' rows? As far as I'm aware, there isn't a method for adding to specific cells (unless I'm wrong).
dt.Rows.Add(a, b, c, d)
where a, b, c and d are string values. So what if I just want to add to the d column? Any help would be appreciated.
17.5k 11 11 gold badges 66 66 silver badges 68 68 bronze badges asked Sep 6, 2012 at 2:44 449 2 2 gold badges 6 6 silver badges 18 18 bronze badgesIf it were a completely new row that you wanted to only set one value, you would need to add the whole row and then set the individual value:
DataRow dr = dt.NewRow(); dr[3].Value = "Some Value"; dt.Rows.Add(dr); Otherwise, you can find the existing row and set the cell value
DataRow dr = dt.Rows[theRowNumber]; dr[3] = "New Value";