MS 访问数据库未更新

本文关键字：更新 数据库 访问 MS | 更新日期: 2023-09-27 17:57:03

谁能告诉我为什么我的数据库没有更新？这是我的代码：

protected void editSection_selected(object sender, EventArgs e) {
    int index = grdPhone.SelectedIndex;
    GridViewRow row = grdPhone.Rows[index+1];
    string values = ((DropDownList)sender).SelectedValue;
    int tempVal = Convert.ToInt32(values);
    int caseage = Convert.ToInt32(keyId);
    int value = tempVal;
    /*OleDbConnection con = new OleDbConnection(strConnstring);
    //string query = "Update Categories set HRS_LEVEL_AMOUNT=" + tempVal + " where parent_id=65 and ID=" + caseage;
    string query = "Delete HRS_LEVEL_AMOUNT from Categories where parent_id=65 and id=" + caseage;
    OleDbCommand cmd = new OleDbCommand(query, con);
    con.Open();
    cmd.ExecuteNonQuery();
    con.Dispose();
    cmd.Dispose();
    con.Close();
    accPhoneNumbers.UpdateCommand = "Update Categories set HRS_LEVEL_AMOUNT=" + tempVal + " where parent_id=65 and ID=" + caseage;
    */
    string str = "UPDATE Categories SET HRS_LEVEL_AMOUNT = ? WHERE ID=?";
    using (OleDbConnection con = new OleDbConnection(strConnstring))
    {
        using (OleDbCommand cmd = new OleDbCommand(str, con))
        {
            cmd.CommandType = CommandType.Text;
            cmd.Parameters.AddWithValue("HRS_LEVEL_AMOUNT", tempVal);
            cmd.Parameters.AddWithValue("ID", caseage);
            con.Open();
            cmd.ExecuteNonQuery();
        }
    }
    Label1.Text += " editSection Success! (B) " + tempVal;
}

注释部分是我的第一个解决方案（包括accPhoneNumbers.UpdateCommand）。我真的需要你们的帮助。

MS 访问数据库未更新

我希望这可以帮助您：

string str = "UPDATE Categories SET HRS_LEVEL_AMOUNT = @value1 WHERE ID=@value2";
using (OleDbConnection con = new OleDbConnection(strConnstring))
{
    using (OleDbCommand cmd = new OleDbCommand(str, con))
    {
        cmd.CommandType = CommandType.Text;
        cmd.Parameters.AddWithValue("@value1", tempVal);
        cmd.Parameters.AddWithValue("@value2", caseage);
        con.Open();
        cmd.ExecuteNonQuery();
        con.close();
    }
}

有关更多信息，您可以访问此视频

相关文章：