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

Admin | 2007-12-31 22:15:33 | 被阅次数 | 11718

温馨提示!

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

批处理事务不应该把transaction事务放在for循环里，造成多个事务，这将导致错误.
应该把for放在transaction里，当成一个事务来处理，进行批处理

示例代码：

protected void btnDelete_Click(object sender, EventArgs e) //删除
    {
        SqlServerDataBase del = new SqlServerDataBase();
        string str = "";
        SqlConnection conn = del.DBconn();
        conn.Open();
        SqlTransaction myTrans;
        myTrans = conn.BeginTransaction(IsolationLevel.ReadCommitted);

        ListBox1.Items.Clear();
        try
        {
            for (int i = 0; i < GridView1.Rows.Count; i++) //从GridView中选中checkbox
            {
                GridViewRow row = GridView1.Rows[i];
                bool isChecked = ((CheckBox)row.FindControl("chkSelect")).Checked;
                if (isChecked)
                {
                    ListBox1.Items.Add(GridView1.Rows[i].Cells[2].Text);
                    //Column 1 is the StuNumber column
                    str = GridView1.Rows[i].Cells[1].Text; //获取删除行的StuNumber的值
                    // Response.Write(str.ToString());
                    del.Delete("delete from StuInfo where StuNumber = '" + str + "'", null);
                    del.Delete("delete from StuSkill where StuNumber = '" + str + "'", null);//删除
                }
            }
            myTrans.Commit();
         }
        catch (Exception ex)
        {
            try
            {
                myTrans.Rollback();
            }
            catch (SqlException sqlEx)
            {
                if (del.DBconn() != null)
                {
                    Response.Write(sqlEx.GetType() + "数据库打开失败");
                    Response.Redirect("submit.htm");
                }
            }
        }
        finally
        {
            conn.Close();
        }
        BindData();
    }
}