C#中使用DBHelper操作存储过程与事务

   public DataSet RunProcedure(string procedureName, SqlParameter[] parameters)
          {
             SqlConnection thisconnection = new SqlConnection(SqlHelper.ConnectionString);
             
              SqlCommand cmd = new SqlCommand();
              cmd.CommandText = procedureName;
             cmd.CommandType = CommandType.StoredProcedure;//存储过程
              cmd.Connection = thisconnection;//数据库连接
            if (parameters != null)
                 foreach (SqlParameter param in parameters)
                     cmd.Parameters.Add(param);
 
              SqlDataAdapter adapter = new SqlDataAdapter(cmd);
             DataSet ds = new DataSet();
              thisconnection.Open();
             //执行操作
              adapter.Fill(ds);
              thisconnection.Close();
             return ds;
          }



public DataTable GetDataTable(SqlConnection SqlConn, string proName, params SqlParameter[] param)
  {
  
          if(SqlConn.State==ConnectionState.Closed){
      
        SqlConn.Open();