Question

以下是我的SQL声明:

UPDATE InboxItem 
SET OrderId = @0, Item = @1, Quantity = @2, Price = @3, 
    Memo = "", InboxId = @4, VATId = @5 
WHERE Id = @6

这将抛出 Sql Explition , 上面写着

An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.

我想我知道问题在于什么。如果我给梅莫以价值,一切都会好起来。然而,我有时希望备忘录是空字符串。如何做到这一点?

Answer 1

使用而不是 " 。同时验证输入是否正确( 可能其中一条字符串中有一个逗号是不可避免的) 。

Answer 2

var sb = new StringBuilder();            
sb.Append("UPDATE InboxItem ");
sb.Append("SET OrderId = @0, Item = @1, Quantity = @2, Price = @3, ");
sb.Append("Memo = @7, InboxId = @4, VATId = @5 ");
sb.Append("WHERE Id = @6");
var cm = new SqlCommand(sb.ToString());
cm.CommandType = System.Data.CommandType.Text;
cm.Parameters.AddWithValue("@1", Convert.ToInt16("OrderValue"));
//and so on

友情链接