服务器之家:专注于服务器技术及软件下载分享
分类导航

PHP教程|ASP.NET教程|JAVA教程|ASP教程|

asp.net 使用事务

2019-07-09 16:41ASP.NET之家 ASP.NET教程

假如我们要同时更新几张表就必定需要使用事务操作。

ASP.NET操作事务非常的简单,代码如下: 
代码 
复制代码代码如下:

using System; 
using System.Collections.Generic; 
using System.Linq; 
using System.Web; 
using System.Web.UI; 
using System.Web.UI.WebControls; 
using System.Data; 
using System.Data.SqlClient; 
using System.Transactions; 
public partial class swstudy : System.Web.UI.Page 

private SqlConnection conn; 
protected void Page_Load(object sender, EventArgs e) 


private SqlConnection GetConnection() 

if (conn!=null&&conn.State == ConnectionState.Open) 

return conn; 

else 

return conn= new SqlConnection("server=PC-200911131211;database=test;uid=sa;pwd=sa123456"); 


//提交 
protected void Button1_Click(object sender, EventArgs e) 

string str1 = this.TextBox1.Text; 
string str2 = this.TextBox2.Text; 
using (GetConnection()) 

conn.Open(); 
//事务 
SqlTransaction tran; 
tran = conn.BeginTransaction(); 
//提交一 
SqlCommand cmd1 = new SqlCommand("insert into m1(m1,m2)values('" + str1 + "','" + str2 + "')", conn); 
cmd1.Transaction = tran; 
//提交二 
SqlCommand cmd2 = new SqlCommand("insert into messages(msg)values('" + str1 + "')", conn); 
cmd2.Transaction = tran; 
try 

cmd1.ExecuteNonQuery(); 
cmd2.ExecuteNonQuery(); 
tran.Commit();//提交事物 
Response.Write("<script>alert('全部提交OK')</script>"); 

catch 

tran.Rollback();//回滚操作 
Response.Write("<script>alert('事务回滚')</script>"); 

finally 

conn.Close(); 



延伸 · 阅读

精彩推荐