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'")