数据库事务处理的另外一种方法

添加引用System.EnterpriseServices.dll

using System.EnterpriseServices;

随便建立一个按钮，在按钮中进行如下操作：

try

{

work1();

work2();

ContextUtil.SetComplete();

}

catch(System.Exception except)

{

ContextUtil.SetAbort();

Response.Write(except.Message);

}

然后在页面中添加2个操作，模拟一下在逻辑层调用不同类中的操作的情况

private void work1()

{

SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings['conn']);

SqlCommand cmd1=new SqlCommand('Insert Into trantest (id,test)values(1,'test')',conn);

conn.Open();

cmd1.ExecuteNonQuery();

conn.Close();

}

private void work2()

{

SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings['conn']);

SqlCommand cmd2=new SqlCommand('Insert Into trantest (id,test)values(2,'test')',conn);

conn.Open();

cmd2.ExecuteNonQuery();

conn.Close();

}