2010.5.20 执行SQL语句事务

   /// <summary>
        /// 执行多条SQL语句，实现数据库事务
        /// </summary>
        public static void ExecuteSqlTran(ArrayList SqlString)
        {
            using(OleDbConnection conn=new OleDbConnection(connectionString))
            {
                OleDbCommand cmd = new OleDbCommand();
                cmd.Connection = conn;
                //指定并启动SQL数据库事务：第一步
                OleDbTransaction tx = conn.BeginTransaction;
                //开始执行数据库事务：第二步
                cmd.Transaction = tx;
                try
                {
                    for (int i = 0; i < SqlString.Count; i++)
                    {
                        string sql = SqlString[i].ToString();
                        if (sql.Trim().Length > 1)
                        {
                            cmd.CommandText = sql;
                            cmd.ExecuteNonQuery();
                        }
                    }
                    //提交数据库事务：第三步
                    tx.Commit;
                }
                catch (System.Data.OleDb.OleDbException e)
                {
                    //挂起状态回滚事务：第四步
                    tx.Rollback();
                    throw new Exception(e.Message);
                }       

            } 
        }
        /// <summary>
        /// 执行SQL语句的存储过程
        /// </summary>
        /// <param name="sqLString">SQL语句</param>
        /// <param name="content"></param>
        /// <returns></returns>
        public static int ExecuteSql(string sqLString, string content)
        {
            using(OleDbConnection conn=new OleDbConnection(connectionString))
            {
                OleDbCommand cmd = new OleDbCommand(sqLString,content);
                OleDbParameter myParm = new OleDbParameter("@content",OleDbType.VarChar);
                myParm.Value = content;
                cmd.Parameters.Add(myParm);
                try
                {
                    conn.Open();
                    int rows = cmd.ExecuteNonQuery();
                    return rows;
                }
                catch (System.Data.OleDb.OleDbException E)
                {

                    throw new Exception(E.Message);
                }
                finally
                {
                    cmd.Dispose();
                    conn.Close();
                }

            }
        }
        /// <summary>
        /// 像数据库中插入图片
        /// </summary>
        /// <returns></returns>
        public static int ExecuteSqlInsertImg(string strSql,byte[] bf)
        {
            using(OleDbConnection conn=new OleDbConnection(connectionString))
            {
                OleDbCommand cmd = new OleDbCommand(strSql,conn);
                OleDbParameter myParam = new OleDbParameter("@bf",OleDbType.Binary);
                myParam.Value = bf;
                cmd.Parameters.Add(myParam);
                try
                {
                    conn.Open();
                    int rows = cmd.ExecuteNonQuery();
                    return rows;
                }
                catch (System.Data.OleDb.OleDbException E)
                {

                    throw new Exception(E.Message);
                }
                finally
                {
                    cmd.Dispose();
                    conn.Close();
                }

            }

时间较紧