执行多条SQL语句,事务处理

最新推荐文章于 2024-01-04 09:26:27 发布

bailao9336

最新推荐文章于 2024-01-04 09:26:27 发布

阅读量146

点赞数

原文链接：http://www.cnblogs.com/JimZhang/archive/2005/08/31/226603.html

版权

  /// <summary>
  /// 执行多条SQL语句,事务处理
  /// </summary>
  /// <param name="strSQL">以";"相隔的查询语句</param>
  public bool InsertMoreDB(string strSQL){
   char[] de={';'};
   string strChildSQL;
   int i;
   string[] strSQLArr=strSQL.Split(de);
   bool IsControll=true;

   SqlConnection conn=DBCreateCN();
   SqlCommand myCommand=new SqlCommand();
   SqlTransaction myTrans;
   myTrans=conn.BeginTransaction();

myCommand.Connection = conn;
myCommand.Transaction = myTrans;

   try
   {
    for(i=0;i<strSQLArr.Length;i++)
    {
     strChildSQL=strSQLArr[i];
     myCommand.CommandText =strChildSQL;
     myCommand.ExecuteNonQuery();
    }
    myTrans.Commit();
    IsControll=true;
   }
   catch(Exception)
   {
    try
    {
     IsControll=false;
     myTrans.Rollback();

    }
    catch (SqlException)
    {
     // Handle possible exception here
    }
   }
   finally
   {
    conn.Close();
   }
   return IsControll;
  }

转载于:https://www.cnblogs.com/JimZhang/archive/2005/08/31/226603.html