c#执行事务

        /// <summary>
        /// 执行多条sql语句，实现事务
        /// </summary>
        /// <param name="arraySql">多条sql语句</param>
        public int ExecutrSqlTran(System.Collections.ArrayList arraySql)
        {
            int itemnum;
            DbOpen();
            SqlCommand cm = new SqlCommand();
            cm.Connection = scn;
            SqlTransaction tx = scn.BeginTransaction();
            cm.Transaction = tx;
            try
            {
                for (int i = 0; i < arraySql.Count; i++)
                {
                    string strSql = arraySql[i].ToString();
                    if (strSql.Trim().Length > 1)
                    {
                        cm.CommandText = strSql;
                        cm.ExecuteNonQuery();
                    }
                }
                tx.Commit();
                itemnum = 1;
            }
            catch (SqlException E)
            {
                tx.Rollback();
                itemnum = 0;
                throw new Exception(E.Message);
            }
            DbClose();
            return itemnum;
        }
    }