Interesting… that is a nice debugging tip…
Anyway… I placed statements before and after each adapter update. Both have the “dataAdapter.AcceptChangesDuringUpdate= False” statement.
Results:Code:If dt.GetChanges() Is Nothing Then MessageBox.Show("Before Red UPdate-There are no changes to save.") Else MessageBox.Show("Before Red UPdate The are changes to be saved.") End If
Before and after both adapter updates, the message indicated that there are changes to be saved, however, the second adapter did not update the database table. I reversed the order of the adapter updates with the same result. The first adapter updated the database and the second did not.




Reply With Quote