,----- [ Shawn Wildermuth wrote: ]
| My use-case is a multi-table DataSet where I am updating
| the database from the DataSet. Since the tables are related, I want a
| single transaction to filter through all the updates, though different
| DataAdapters (using one DataAdapter per table).
`-----
I'm doing exactly this using the CommandBuilder and transactions.
When I'm ready to perform my commit, I open a connection, create a
transaction, and do the following for each adapter:
adapter.SelectCommand.Transaction = transaction;
The CommandBuilder takes care of propagating the transaction to the
rest of the commands.
--
Best regards,
N. Sean Timm mailto:[EMAIL PROTECTED]
You can read messages from the DOTNET archive, unsubscribe from DOTNET, or
subscribe to other DevelopMentor lists at http://discuss.develop.com.
