GridView中使用IN子句的自定义sql参数

GridView中使用IN子句的自定义sql参数 - C＃(custom sql parameter using IN clause in gridview - C#)

当我放置下面的SQL查询时，

SELECT [ItemID], [Name], [RelDate], [Price], [Status] FROM [item_k] WHERE [ItemID] IN (" + itemIDs + ")

在gridview自定义sql语句中，它被转换为，

SELECT ItemID, Name, RelDate, Price, Status FROM item_k WHERE (ItemID IN ([ + itemIDs + ]))

当我执行查询时会显示以下错误

SQL Execution Error Invalid column name '+ itemIDs+'

什么似乎是问题？

谢谢

When I placed the the following SQL query,

SELECT [ItemID], [Name], [RelDate], [Price], [Status] FROM [item_k] WHERE [ItemID] IN (" + itemIDs + ")

in gridview custom sql statements, it gets transformed to,

SELECT ItemID, Name, RelDate, Price, Status FROM item_k WHERE (ItemID IN ([ + itemIDs + ]))

and when I execute the query the following error is shown

SQL Execution Error Invalid column name '+ itemIDs+'

what seems to be the problem?

thanks

最满意答案

你有没有尝试把+ itemIDs +放在单引号中？

Have you tried putting + itemIDs+ in single quotes?