3 different sqldatasource insert queries in 1 transaction...?

[Guest]

Hi ,

In the asp.net application I am working on we use 3 different sqldatasource
objects with each a insert command in it.

I call:
sqldatasource1.Insert();
sqldatasource2.Insert();
sqldatasource3.Insert();

what i want is wrap these three inserts in 1 transaction.
I ve found solutions where only one insert is in the transaction
(http://windowssdk.msdn.microsoft.co...ebcontrols.sqldatasourcecommandeventargs.aspx).

How can this be solved..?

 

[Miha Markic [MVP C#]]

Use brand new System.Transactions.Transaction class.