How to get the index of the rows that has been modified(insert,Update,delete) in the Dataset datatable, rather then Using the
dataset1.AcceptChanges and save the whole table which is not at all efficient way.
If you use the DataForm Wizard to create a DataForm, it will show you the correct way to do this.
It's a combination of using parameters with the SQL statement, then using the DataSet.GetChanges method to return a dataSet with only the changes. You then update the dataBase with only that subset of the dataSet.