Transaction for TableAdapters

[DG]

I have two SqlTableAdapter s (for typed dataset, generated by VS) and want to
do update of tables.
In transaction of course.

How to do it?

i try:

SqlConnection conn = new SqlConnection(G lobal.Connectio nString);

DSTableAdapters .Table1Adapter ta1 = new DSTableAdapters .Table1Adapter ();
DSTableAdapters .Table2Adapter ta2 = new DSTableAdapters .Table2Adapter ();

conn.Open();
trans = conn.BeginTrans action();

ta1.Connection = conn;
ta1.Connection = conn;

ta1.Update(DS.T able1);

I get an exception:

ExecuteReader requires the command to have a transaction when the connection
assigned to the command is in a pending local transaction. The Transaction
property of the command has not been initialized.

Thank you!