You use DataAdapter to load a DataTable. Your code makes several changes to the DataTable, sets ContinueUpdateOnError to True, and then calls Update to update the database.

You must identify all rows that failed to update.

What should you do?

You can identify all rows that failed to update by calling the DataTable.GetErrors method.

After calling Update, all rows remain in the DataTable. This includes rows that did update and rows that failed to update.

When a row is successfully updated, the update process calls AcceptChanges. This sets the Original value to the Current value. Examining all rows with the same Original and Current column values gives you all the rows that updated successfully, not the rows that did not.