To check the results of your test runs, you'll need to add a connection in Server Explorer to the version of the database in your bin/Debug folder.
You can install SQL Server Express or SQL Server Compact Edition for free if you don't have SQL Server installed.
Here's what happens: You add a database to some non-ASP. You run some code that makes some updates and everything seems to work with all of your updates accepted.
You then do a second run…and it's like your previous run never happened!
Write Line("Pass#1 after update : row.id=" ", Row State=" row. Write Line("Pass#2 after update : row2.id=" row2", Row State=" row2. You can use My SQLCommand Builder, but the first autoincrement id rows is unchanged, and not updated by the autoincrement value of server. So, if the first returned row is the result of a 'SELECT last_insert_id()', then the generated key will be returned and merged back in. The whole point of using My Sql Command Builder is to not mess with command objects.
What this does is tell the data adapter update engine to take the first returned row and merge it's values back into the changed row. The Updated Row Source property exists on the command object.