c# - MySQL .NET 保存/编辑按钮不执行任何操作

Question

我正在对表进行简单的编辑，而且我似乎一直坚持让它更新我在数据库中更改的值。它不会向我抛出任何错误。

这是我的按钮代码:

protected void saveButton_Click(object sender, EventArgs e)
{
 saveOperator2();
}
protected void Page_Load(object sender, EventArgs e)
{
 Single();
 if (Request.QueryString.HasKeys() && !IsPostBack)
  {
    operatorID = int.Parse(Request.QueryString["Oid"]);
  }
}
private void saveOperator2()
{
 connection = new MySqlConnection(connectionString);
 parser = new MySQLParser(connection);
 {
  connection.Open();
MySqlCommand cmd = new MySqlCommand("UPDATE operator SET DPFreservingrawmaterials = @DPFreservingrawmaterials WHERE idOperator = @idOperator", connection);
  cmd.Parameters.Add("@DPFreservingrawmaterials", DPFreservingrawmaterialsTextBox.Text);
  cmd.Parameters.Add("@idOperator", operatorID);
  cmd.ExecuteNonQuery();
  cmd.Dispose();
 }
 connection.Close();
}

编辑#32 -

您的 SQL 语法有错误；检查与您的 MySQL 服务器版本相对应的手册，了解在第 1 行 'SET operator DPFreservingrawmaterials = '1' WHERE idOperator = 10038' 附近使用的正确语法

在 cmd.ExecuteNonQuery() 处中断；

Answer 1

正确的字段 operatorID 或 idOperator 是什么？

UPDATE operator `SET operatorID` = @idOperator, DPFreservingrawmaterials = @DPFreservingrawmaterials WHERE `idOperator` = "+ operatorID, connection

“SET operatorID”然后在Where子句中WHERE idOperator