陈宝刚---享受生活,追逐梦想!
理想是心中的火焰,有追求的人才是幸福的人!
/// <summary>
        /// 多SQL语句操作--事务处理
        /// </summary>
        /// <param name="sqlComm">SQL语句数组</param>
        /// <returns>事务,返回String事务结果</returns>
        public string DoTran(string[] sqlComm)
        {
            if (connection.State.ToString() == "Closed")
                connection.Open();
            SqlTransaction myTran;
            myTran = connection.BeginTransaction();
            //string mess;
            
            SqlCommand command = new SqlCommand("",connection,myTran);
            //command.Connection = connection;
            try
            {
                foreach (string comm in sqlComm)
                {
                    command.CommandText = comm;
                    command.ExecuteNonQuery();
                }
                myTran.Commit();
            }
            catch (Exception e)
            {
                //throw new ApplicationException("系统信息:" + e.Message);
                return e.Message;
            }
            finally
            {
                connection.Close();
            }
            return "事务操作成功!";
        }
posted on 2010-03-03 16:56  追梦人RUBY  阅读(209)  评论(0)    收藏  举报