|
|
数据库事务处理的另外一种方法 |
|
|
作者:未知 来源:月光软件站 加入时间:2005-5-13 月光软件站 |
添加引用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(); }

|
|
相关文章:相关软件: |
|