Here is the situation:
A DataTable has contains rows with all rowstates in it.
A Table Adaptor.Update is performed that is wrapped in a TransactionScope.
An error occurs and the complete is not called. All is well on the Server,
all rows are backed out.
My DataTable is not so well. Some look like they have been updated and have
a rowstate of unchanged. The rest of the rows starting with the first row
that had an error have the rowstate they had from before the update.
Does anyone have an idea of how to handle the data in the datatable after
the rollback of the transaction?