错误没有给出一个或多个必需参数的值。从excelsheet中选择 [英] Error no value given for one or more required parameters.' select from excelsheet

问题描述

When i try to get data from excel sheet i get error

no value given for one or more required parameters.'

why this happen .

i work in visual studio 2010 with excelsheet 2013 

my code in c# as following

	<pre lang="c#">public DataTable ShowWrongExcelData()

	       {

	           string connectionString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=\"Excel 12.0 Xml;HDR=YES;IMEX=1\";", txtPath.Text);

	 

	           OleDbConnection con = new OleDbConnection(connectionString);

	 

	 

	           con.Open();

	           string str = @"SELECT  [رقم الاستمارة] as [UnitCode],[قراءة العداد]as[CurrentMeterReading] FROM  [Sheet5$] where [CurrentMeterReading] <= 0 ";

	         

	           OleDbCommand com = new OleDbCommand();

	           com = new OleDbCommand(str, con);

	           OleDbDataAdapter oledbda = new OleDbDataAdapter();

	           oledbda = new OleDbDataAdapter(com);

	           DataSet ds = new DataSet();

	           ds = new DataSet();

	           oledbda.Fill(ds, "[Sheet5$]");

	           con.Close();

	           System.Data.DataTable dt = new System.Data.DataTable();

	           dt = ds.Tables["[Sheet5$]"];

	           return dt;

	 

	 

	       }

为什么给这个错误我不使用任何参数。



但是当我选择Excel表格中的所有数据时如下：



@SELECT [رقمالاستمارة] as [UnitCode]，[قراءةالعداد] as [CurrentMeterReading] FROM [Sheet5 $];



我得到的数据没有任何问题



这样如何解决这个错误？



Excel表格InvoiceData.xlsx样本



[ ^ ]



我尝试了什么：

why give this error i don't use any parameters .

but when i select all data from Excel sheet as following :

@"SELECT [رقم الاستمارة] as [UnitCode],[قراءة العداد]as[CurrentMeterReading] FROM [Sheet5$]";

I get data without any problem

so that How to solve this error please ?

Excel sheet InvoiceData.xlsx sample

[^]

What I have tried:

error no value given for one or more required parameters.' select from excelsheet 

推荐答案

其中[CurrentMeterReading]< = 0;



OleDbCommand com = new OleDbCommand（）;

com = new OleDbCommand（str，con）;

OleDbDataAdapter oledbda = new OleDbDataAdapter（）;

oledbda = new OleDbDataAdapter（com）;

DataSet ds = new DataSet（）;

ds = new DataSet（）;

oledbda.Fill（ds，[Sheet5

where [CurrentMeterReading] <= 0 "; OleDbCommand com = new OleDbCommand(); com = new OleDbCommand(str, con); OleDbDataAdapter oledbda = new OleDbDataAdapter(); oledbda = new OleDbDataAdapter(com); DataSet ds = new DataSet(); ds = new DataSet(); oledbda.Fill(ds, "[Sheet5

）;

con.Close（）;

System.Data.DataTable dt = new System.Data.DataTable（）;

dt = ds.Tables [[Sheet5

"); con.Close(); System.Data.DataTable dt = new System.Data.DataTable(); dt = ds.Tables["[Sheet5

];

返回dt;





}

"]; return dt; }

为什么给这个错误我不使用任何参数。



但是当我选择Excel表格中的所有数据时如下：



@SELECT [رقمالاستمارة] as [UnitCode]，[قراءةالعداد] as [CurrentMeterReading] FROM [Sheet5

why give this error i don't use any parameters .

but when i select all data from Excel sheet as following :

@"SELECT [رقم الاستمارة] as [UnitCode],[قراءة العداد]as[CurrentMeterReading] FROM [Sheet5

这篇关于错误没有给出一个或多个必需参数的值。从excelsheet中选择的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！