出现"SqlTransaction 已完成;它再也无法使用"的错误提示之解决方案上簈

Admin | 2007-12-31 22:15:11 | 被阅次数 | 9188

温馨提示!

如果未能解决您的问题，请点击搜索；登陆可复制文章，点击登陆

当只是使用一次事务时，只用简单的事务就可以了

示例代码：

       SqlServerDataBase obj = new SqlServerDataBase();
        SqlConnection conn = obj.DBconn();
        conn.Open();
        SqlTransaction myTrans;
        myTrans = conn.BeginTransaction(IsolationLevel.ReadCommitted);

        try
        {
            obj.Insert("insert into StuInfo (StuNumber,Name,Sex,Specialty) values('" + stuNumber + "','" + name + "','" + sex + "','" + specialty + "')", null);
            obj.Insert("insert into StuSkill(StuNumber,Skill) values('" + stuNumber + "','" + skill + "')", null);
            myTrans.Commit();
            Response.Write("两条数据均插入到数据库中！");
        }
        catch (Exception ex)
        {
            try
            {
                myTrans.Rollback();
            }
            catch (SqlException sqlEx)
            {
                if (obj.DBconn() != null)
                {
                    Response.Write(sqlEx.GetType()+"数据库打开失败");
                    Response.Redirect("submit.htm");
                }
            }
        }
        finally
        {
            obj.DBconn().Close();
        }