Here is a neat way to have .net build your commands for you:
da is the SQLDataAdapter
Dim cb As New SqlCommandBuilder(da)
'da.UpdateCommand = cb.GetUpdateCommand
'da.InsertCommand = cb.GetInsertCommand
'da.DeleteCommand = cb.GetDeleteCommand
‘’'ds.Tables(0).Rows(0)(“value”) = DataGrid1
'da.Update(ds, “tablename”)
'ds.AcceptChanges()
.Net will know if it needs to create the proper command you need.
Hope this is usful to you…