SqlTransaction

事物的简单应该

转自：https://www.cnblogs.com/hgmyz/p/6490288.html

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
sql1="INSERT INTO tablename(Id,col1,col2) VALUES(@Id,@col1,@col2)   update tablename2 set col=@col";
sql2="INSERT INTO tablename3(Id,col1,col2) VALUES(@Id,@col1,@col2)";
 
//参数设置（略）
 
using(SqlTransaction tran = SqlHelper.BeginTransaction(SqlHelper.DBConnectionString))
{
 try
 {   
 
  SqlHelper.ExecuteNonQuery(tran,CommandType.Text,sql1,parms);
  SqlHelper.ExecuteNonQuery(tran,CommandType.Text,sql2,parms);
  tran.Commit();
   
  return true;
 }
 catch
 {
  tran.Rollback();
  return false;
 }

　　放在sqlhelper.cs中

1
2
3
4
5
6
7
public  static SqlTransaction BeginTransaction(string con)
{
 SqlConnection connection = new SqlConnection(con);
 connection.Open();
 SqlTransaction tran = connection.BeginTransaction();
 return tran;
}

 

posted @ 2018-12-06 11:19  敌八哥  阅读(670)  评论(0)    收藏  举报