SQL中的事务的写法代码

 using (SqlConnection conn = new SqlConnection(SQLHelper.constr))//SQLHelper.constr为数据库连接字符串
            {
                conn.Open();//连接数据库
                //使用事务处理多SQL语句
                using (SqlTransaction trans = conn.BeginTransaction())
                {
                    try
                    {
                   
                    }
                    catch (Exception)
                    {
                        trans.Rollback();
                    }
                    finally
                    {
                        conn.Close();
                    }
                }
            }
posted @ 2011-08-08 21:58  风一样的大叔  阅读(475)  评论(0编辑  收藏  举报