从Excel读取更正我的查询 [英] Correct My Query fror reading from Excel
本文介绍了从Excel读取更正我的查询的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
OleDbCommand objCmdSelect = new OleDbCommand(SELECT * FROM [库存样本和价格$ O4:O656],其中Category = WIRED,objConn); ...............
显示异常没有给出一个或多个参数的值........
OleDbCommand objCmdSelect = new OleDbCommand("SELECT * FROM [SAMPLE OF INVENTORY AND PRICE$O4:O656] where Category=WIRED ", objConn);...............
It shows Exception No Value given for one or more perameters........
推荐答案
O4:O656]其中Category = WIRED,objConn); ...............
显示异常没有给定的值对于一个或多个参数........
O4:O656] where Category=WIRED ", objConn);...............
It shows Exception No Value given for one or more perameters........
这是您第三次发布此问题;请停止。
如果您有额外的信息需要添加,请回复其中一位回复您之前参赛作品的人。
This is the third time you have posted this question; please stop.
If you have extra information to add then reply to one of the people who responded to your previous entry.
这篇关于从Excel读取更正我的查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文