DbHelperSQL.ExecuteSqlTran 的使用

  public static void ExecuteSqlTran(Hashtable SQLStringList)
{
            using (SqlConnection conn = new SqlConnection(connectionString))
            {
                conn.Open();
                using (SqlTransaction trans = conn.BeginTransaction())
                {
                    SqlCommand cmd = new SqlCommand();
                    try
                    {
                        //循环
                        foreach (DictionaryEntry myDE in SQLStringList)
                        {
                            string cmdText = myDE.Key.ToString();
                            SqlParameter[] cmdParms = (SqlParameter[])myDE.Value;
                            PrepareCommand(cmd, conn, trans, cmdText, cmdParms);
                            int val = cmd.ExecuteNonQuery();
                            cmd.Parameters.Clear();
                        }
                        trans.Commit();
                    }
                    catch
                    {
                        trans.Rollback();
                        throw;
                    }
                }
            }
        }


例子
      protected void btnOne_Click(object sender, EventArgs e)
        {
            Hashtable SQLStringList = new Hashtable();
            string cmdText = "update Article set  title=@title where id=@id;update Ad set title=@title2 where id=@id2";
            SqlParameter[] cmdParms = new SqlParameter[4];
            cmdParms[0] = new SqlParameter("@title ", "文章标题");
            cmdParms[1] = new SqlParameter("@title2 ", "广告标题1");
            cmdParms[2] = new SqlParameter("@id ",37);
            cmdParms[3] = new SqlParameter("@id2 ",57);  
            SQLStringList.Add(cmdText, cmdParms);
            DbHelperSQL.ExecuteSqlTran(SQLStringList);
        }