类型化 DataSet 如何支持事务？

[xiaozhimin1978]

			Test.DataSet1 ds = new DataSet1();
			
			Test.DataSet1TableAdapters.StudentTableAdapter stuAdapter =
				new Test.DataSet1TableAdapters.StudentTableAdapter();
			Test.DataSet1TableAdapters.TeamTableAdapter teamAdapter =
				new Test.DataSet1TableAdapters.TeamTableAdapter();

			stuAdapter.Fill(ds.Student);
			teamAdapter.Fill(ds.Team);

			ds.Student[0].Name = "他妈的";
			stuAdapter.Update(ds.Student);

			Console.WriteLine("已更新学生记录");
			Console.ReadLine();
			
			ds.Team[0].CreateDate = DateTime.Now.AddDays(-1);
			teamAdapter.Update(ds.Team);

			Console.WriteLine("更新完成");

在“已更新学生记录”输出之后，数据库中的记录就已经更新了

我希望这两次操作放在一个事务中一次提交完成，该怎么做？

[qap22]

不懂，帮顶

[usb80]

不懂，帮顶

[Fibona]

try
{
Using(System.Transactions.TransactionScop ts=new System.Transactions.TransactionScop())
{

Test.DataSet1 ds = new DataSet1();

Test.DataSet1TableAdapters.StudentTableAdapter stuAdapter =
new Test.DataSet1TableAdapters.StudentTableAdapter();
Test.DataSet1TableAdapters.TeamTableAdapter teamAdapter =
new Test.DataSet1TableAdapters.TeamTableAdapter();

stuAdapter.Fill(ds.Student);
teamAdapter.Fill(ds.Team);

ds.Student[0].Name = "他妈的";
stuAdapter.Update(ds.Student);

Console.WriteLine("已更新学生记录");
Console.ReadLine();

ds.Team[0].CreateDate = DateTime.Now.AddDays(-1);
teamAdapter.Update(ds.Team);

Console.WriteLine("更新完成");

ts.Compelte();
}
}
catch(Exception e)
{
throw(e);
}

TransactionScrop 只要没有Compelte();就会自动回滚;

[changjiangzhibin]

1 TransactionScop
2 不要用强类型的，自己实现，控制事务处理