使用SQL参数对UPDATE语句的问题在C＃ [英] Problems with SQL Parameters in C# on UPDATE statement

问题描述

我想更新数据。每当我使用参数化查询，它给了我命令执行过程中致命错误遇到错误。

I'm trying to update data. Whenever I use a parameterized query it gives me the error Fatal Error Encountered during command execution.

下面是我的code：

public void updateAccount(Int32 cashierid, string cashieruser, string isadmin, string cashierfname, string cashiermname, string cashierlname, string cashierpass)
{
    con.ConnectionString = conString;     
    String sql = "UPDATE cashieraccount SET cashieruser = ?cashieruser, cashierpass = ?cashierpass, isadmin = ?isadmin, cashierfname = ?cashierfname, cashiermname = ?cashiermname, cashierlname = ?cashierlname";
    sql += "WHERE cashierid = ?cashierid";
    try
    {
        con.Open();
        MySqlCommand cmd = new MySqlCommand(sql, con);
        cmd.Parameters.AddWithValue("?cashieruser", cashieruser);
        cmd.Parameters.AddWithValue("?cashierpass", cashierpass);
        cmd.Parameters.AddWithValue("?isadmin", isadmin);
        cmd.Parameters.AddWithValue("?cashierfname", cashierfname);
        cmd.Parameters.AddWithValue("?cashiermname", cashiermname);
        cmd.Parameters.AddWithValue("?cashierlname", cashierlname);
        cmd.Parameters.AddWithValue("?cashierid", cashierid);
        cmd.ExecuteNonQuery(); **//Fatar Error Encountered during command execution**
    }
    finally
    {
        con.Close();
    }
}

有没有人有什么建议？

Does anyone have any suggestions?

推荐答案

我失去了你后面参数的空白，在其中，子句之前：

I'm missing a white-space behind your parameters, before the where clause:

String sql = "UPDATE cashieraccount SET cashieruser = ?cashieruser, cashierpass = ?cashierpass, isadmin = ?isadmin, cashierfname = ?cashierfname, cashiermname = ?cashiermname, cashierlname = ?cashierlname";
sql += " WHERE cashierid = ?cashierid";
// here ^ 

这篇关于使用SQL参数对UPDATE语句的问题在C＃的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！