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?
更多推荐
itemIDs,ItemID,SQL,SELECT,IN,电脑培训,计算机培训,IT培训"/> <meta name="
发布评论