sqlhelper中事务的简单用法

最新推荐文章于 2021-09-14 08:56:16 发布

weixin_30686845

最新推荐文章于 2021-09-14 08:56:16 发布

阅读量157

点赞数

原文链接：http://www.cnblogs.com/hgmyz/p/6490288.html

版权

   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中

  public  static SqlTransaction BeginTransaction(string con)
  {
   SqlConnection connection = new SqlConnection(con);
   connection.Open();
   SqlTransaction tran = connection.BeginTransaction();
   return tran;
  }

转载于:https://www.cnblogs.com/hgmyz/p/6490288.html