从Excel读取更正我的查询 [英] Correct My Query fror reading from 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屋！