ray is this for a web page or for a winform?
for Winforms, i usually create a binding source,
set the binding source.Datasource to your datatable, and finally set the the .Datasource property of the bindingsource to that.
form the, there grid auto-magically changes datarow values based on edits.
so if i change some data only in the third row of the grid , the DataRow.HasChanges() would be true, and when you call the Adapter.Update, it would build the commands behind the scenes to update only rows with changes.
is that the question?
Lowell