c# - c# odbcCommand 参数化错误

Question

执行下面的代码给我错误。 “用户名”列不能为空
值在变量中传递。但是我认为 OdbcCommand 语句没有准备好。

    OdbcCommand cmd = new OdbcCommand 
    { 
    CommandText = 
    "INSERT INTO orders(username,name,email,address,contact_number,html_email)
    VALUES(@username,@name,@email,@address,@contact_number,@html_email)",

    Connection = Con 
    };

    cmd.Parameters.AddWithValue("@username", username);
    cmd.Parameters.AddWithValue("@name", name);
    cmd.Parameters.AddWithValue("@email", email);
    cmd.Parameters.AddWithValue("@address", add);
    cmd.Parameters.AddWithValue("@contact_number", contact);
    cmd.Parameters.AddWithValue("@html_email", table);

    billid = cmd.ExecuteScalar().ToString();

Answer 1

OdbcCommand 不支持命名参数语法，您应该使用问号占位符:

OdbcCommand cmd = new OdbcCommand 
{ 
CommandText = 
"INSERT INTO orders(username,name,email,address,contact_number,html_email)
VALUES(?, ?, ?, ?, ?, ?)",

Connection = Con 
};

cmd.Parameters.AddWithValue("@p1", username);
cmd.Parameters.AddWithValue("@p2", name);
cmd.Parameters.AddWithValue("@p3", email);
cmd.Parameters.AddWithValue("@p4", add);
cmd.Parameters.AddWithValue("@p5", contact);
cmd.Parameters.AddWithValue("@p6", table);

int affectedRecords = cmd.ExecuteNonQuery();