Sql事务处理

   public static bool ExecTranSql(List<string> sqlList)
        {
            bool flag = true;

            SqlConnection conn = sqlconn;
            conn.Open();
            SqlTransaction tran = conn.BeginTransaction();

            SqlCommand cmd = new SqlCommand("", conn, tran);
            try
            {
                foreach (string sql in sqlList)
                {
                    cmd.CommandText = sql;
                    cmd.ExecuteNonQuery();
                }

                tran.Commit();
            }
            catch (Exception)
            {
                flag = false;
                tran.Rollback();
            }

            finally
            {
                cmd.Dispose();
                conn.Close();
            }

            return flag;

        }