Dataadapter update not updating database friendship educational dating dates
As you can see from the code, I called the Find method to find the row and called the Delete method of the Data Row.
After that I called the Data Adapter's Update method to save the changes to the database table.
I also broke the code following the code where I set Data Row1 = Data Row2 and the changes propogated correctly to the Second Data Table.
But for some reason they were never written to the database.
To test this source code create a Windows application, drop a Data Grid, and three buttons- Insert Command, Update Command, and Delete Command – to the form.
Listing 5-48 show the code on the Insert Command button-click event.
Both servers contain the same databases but I need to write a utility that can transfer a row of data from the Production to the Development servers.
The way the architecture works with the Data Adapter is that you can make any changes you want to the filled Data Set, and it won't affect the database until you call the Update method.