You are correct. Thanks a lot. (You've allowed me to cover this in my forthcoming book. I appreciate the help).
Thanks, Shawn Wildermuth [EMAIL PROTECTED] > -----Original Message----- > From: dotnet discussion [mailto:[EMAIL PROTECTED]] > On Behalf Of N. Sean Timm > Sent: Sunday, April 14, 2002 8:29 PM > To: [EMAIL PROTECTED] > Subject: Re: [DOTNET] Transactions and CommandBuilders > > > ,----- [ 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. > You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.
