Best way to modify rows in a DataTable

[obsessedandre]

I have a DataTable, and I need to edit the contents of rows inside the
DataTable, while still maintaing the row's index. What is the best way
for me to do this?

[obsessedandre]

I have a DataTable, and I need to edit the contents of rows inside the
DataTable, while still maintaing the row's index. What is the best way
for me to do this?

[Joe Keller]

USE SQL UDPATE/SET command through ADO

Connection.Execute("UPDATE [Table] SET [Field] = 'Value' WHERE [Field] = 'Key'")

[karthick_t]

Just Loop through the rows inside the datatable and find the exact row and start updating the datarow values.


for each( DataRow myRow in dtTable.Rows)
{
for each(DataColumn myCol in dtTable.Columns)
{
if (myRow [myCol ].ToString() == "KeyValue")
{

myRow [myCol ] = diffValue;
}
}
}

dt.AcceptChanges();