使用SqlTransaction創立資料庫連接

使用SqlTransaction創立資料庫連接

一、連接字串 

public static readonly string connString = System.Configuration.ConfigurationSettings.AppSettings["connString"];
 

二、一個封裝了ExecuteNonQuery()操作的方法,使用SqlTransaction建立資料庫連接.   
  public static int ExecuteNonQuery(SqlTransaction transaction, string cmdText, SqlParameter[] parms,CommandType cmdtype)
  {
   int result= 0;

   SqlCommand cmd = new SqlCommand(cmdText);
   cmd.Connection = tran.Connection;
   cmd.Transaction = transaction;
   cmd.CommandType = cmdtype;
   cmd.CommandTimeout = 100;

   if ( parms != null)
   {
    foreach (SqlParameter parm in parms)
    {
     cmd.Parameters.Add(parm);
    }
   }
   
   result = cmd.ExecuteNonQuery(); 
   cmd.Parameters .Clear ();

   return result;
  }

 

 

三、另外一個封裝了ExecuteNonQuery()操作的資料庫操作方法,使用SqlTransaction串連資料庫

public static int ExecuteNonQuery(SqlTransaction transaction, string cmdText)
  {
   int result = 0;

   SqlCommand cmd = new SqlCommand(cmdText);
   cmd.Connection = tran.Connection;
   cmd.Transaction = transaction;
   cmd.CommandTimeout = 100;
   
   result= cmd.ExecuteNonQuery(); 

   return result;
  }