How to BeginTransmit with two TabeAdapter method

[ad]

I use two TableAdapter update method to udpate the Database after user press
OK button.
The two TableAdapter will update two different tables in a database.

How can I do BeginTransmit-roolback when user press OK.

 

[Miha Markic [MVP C#]]

Hi,

I think you should use System.Transactions.TransactionScope, like
using (TransactionScope scope = new TransactionScope())
{
// do updates
scope.Commit();
}

 

[ad]

I have tried TransactionScope.
But it fail when execute the second update method with message: Can't use
the MSDTC in the server.

Hi,

I think you should use System.Transactions.TransactionScope, like
using (TransactionScope scope = new TransactionScope())
{
// do updates
scope.Commit();
}

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

I use two TableAdapter update method to udpate the Database after user
press OK button.
The two TableAdapter will update two different tables in a database.

How can I do BeginTransmit-roolback when user press OK.