asp.net指更新所有。。

来源：互联网发布：网站数据迁移什么意思编辑：程序博客网时间：2024/04/30 23:10

SqlDataAdapter EmpAdapter = new SqlDataAdapter();
        DataTable EmpDT = new DataTable();
        SqlConnection DBConSelect = checkConnection.getConnection();
        SqlConnection DBConUpdate = checkConnection.getConnection();
        SqlCommand SelectCommand = new SqlCommand("getUnCheckdQuestion_Proc", DBConSelect);
        SelectCommand.CommandType = CommandType.StoredProcedure;
        DBConSelect.Open();
        SelectCommand.ExecuteNonQuery();

        SqlCommand UpdateCommand = new SqlCommand("CheckAllTrue_proc", DBConUpdate);
        UpdateCommand.CommandType = CommandType.StoredProcedure;

        UpdateCommand.Parameters.Add("@checked", SqlDbType.Bit, 1);
        UpdateCommand.Parameters["@checked"].Value = 1;

        EmpAdapter.SelectCommand = SelectCommand;
        EmpAdapter.UpdateCommand = UpdateCommand;
        EmpAdapter.Fill(EmpDT);
        DBConSelect.Close();

        foreach (DataRow DR in EmpDT.Rows)
        {
            P_int_queCode = Convert.ToInt32(DR["questionCode"]);
            int QueAnsNum1 = QueAnsNum();
            int AnsNum1 = AnsNum();
            int rightNum1 = rightNum();
            bool returnAnsNull = returnNullAns();
            if ((QueAnsNum1 == AnsNum1) && (AnsNum1 != 0) && (rightNum1 == 1) && (returnAnsNull == true))
            {
                DR["checked"] = 1;
            }
        }
        EmpAdapter.RowUpdated += new SqlRowUpdatedEventHandler(OnRowUpdated);
        EmpAdapter.UpdateBatchSize = 100;
        UpdateCommand.UpdatedRowSource = UpdateRowSource.None;
        DBConUpdate.Open();
        EmpAdapter.Update(EmpDT);

        try
        {

            Response.Write("<script language='javascript' defer>alert('审核完毕！');</script>");
        }
        catch (Exception ex)
        {

        }
        finally
        {
            if (DBConUpdate.State == ConnectionState.Open)
            {
                DBConUpdate.Close();
            }
        }        SqlDataAdapter EmpAdapter = new SqlDataAdapter();
        DataTable EmpDT = new DataTable();
        SqlConnection DBConSelect = checkConnection.getConnection();
        SqlConnection DBConUpdate = checkConnection.getConnection();
        SqlCommand SelectCommand = new SqlCommand("getUnCheckdQuestion_Proc", DBConSelect);
        SelectCommand.CommandType = CommandType.StoredProcedure;
        DBConSelect.Open();
        SelectCommand.ExecuteNonQuery();

        SqlCommand UpdateCommand = new SqlCommand("CheckAllTrue_proc", DBConUpdate);
        UpdateCommand.CommandType = CommandType.StoredProcedure;

        UpdateCommand.Parameters.Add("@checked", SqlDbType.Bit, 1);
        UpdateCommand.Parameters["@checked"].Value = 1;

        EmpAdapter.SelectCommand = SelectCommand;
        EmpAdapter.UpdateCommand = UpdateCommand;
        EmpAdapter.Fill(EmpDT);
        DBConSelect.Close();

        foreach (DataRow DR in EmpDT.Rows)
        {
            P_int_queCode = Convert.ToInt32(DR["questionCode"]);
            int QueAnsNum1 = QueAnsNum();
            int AnsNum1 = AnsNum();
            int rightNum1 = rightNum();
            bool returnAnsNull = returnNullAns();
            if ((QueAnsNum1 == AnsNum1) && (AnsNum1 != 0) && (rightNum1 == 1) && (returnAnsNull == true))
            {
                DR["checked"] = 1;
            }
        }
        EmpAdapter.RowUpdated += new SqlRowUpdatedEventHandler(OnRowUpdated);
        EmpAdapter.UpdateBatchSize = 100;
        UpdateCommand.UpdatedRowSource = UpdateRowSource.None;
        DBConUpdate.Open();
        EmpAdapter.Update(EmpDT);

        try
        {

            Response.Write("<script language='javascript' defer>alert('审核完毕！');</script>");
        }
        catch (Exception ex)
        {

        }
        finally
        {
            if (DBConUpdate.State == ConnectionState.Open)
            {
                DBConUpdate.Close();
            }
        }