没有给出一个或多个必需参数的值。

本文介绍了没有给出一个或多个必需参数的值。的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

大家好， 我遇到日期过滤问题... 我收到错误消息： OleDbException未处理 没有给出一个或多个必需参数的值。 以下是我的代码：

Hi Guys, I'm having problems with date filtering... I got an error Message: OleDbException was unhandled No value given for one or more required parameters. Below are my codes:

'declare the needed variables Dim idCon As New OleDbConnection Dim idSQL As String Dim idSet As New DataSet 'start the connection idCon.ConnectionString = "PROVIDER = Microsoft.Jet.OleDb.4.0; data source = Library2.mdb; Jet OLEDB:Database Password = 3Musketeers" idSQL = "SELECT * FROM Newtransaction" 'declare and assign a value to a dataadapter Dim idAdapt As New OleDbDataAdapter(idSQL, idCon) 'open the connection Dim mytable As DataTable = New DataTable() idCon.Open() 'fill data to datable idAdapt.Fill(idSet, "suckz") dGrid.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing 'setting columnheadername idSet.Tables("suckz").Columns(0).ColumnName = "T CODE" idSet.Tables("suckz").Columns(1).ColumnName = "BOOK CODE" idSet.Tables("suckz").Columns(2).ColumnName = "MEMBER CODE" idSet.Tables("suckz").Columns(3).ColumnName = "ISSUED_DATE" idSet.Tables("suckz").Columns(4).ColumnName = "RETURNED DATE" idSet.Tables("suckz").Columns(5).ColumnName = "COMMENTS" idSet.Tables("suckz").Columns(6).ColumnName = "PENALTY" BindingSource1.DataSource = idSet.Tables("suckz") BindingSource1.Filter = String.Format("ISSUED_DATE LIKE '{0}%'", txtSearch.Text) dGrid.DataSource = BindingSource1 dGrid.Update() dGrid.Refresh() idCon.Close()

希望有人可以提供帮助我在这里 提前感谢 嗨大家好， 感谢您的回复。但是，这不是问题。在上面的代码中，我忘记删除我在SQL中尝试样本时使用的where isDate。这是原始的SQL idSQL = SELECT * FROM Newtransaction顺便说一下，这些代码插入到txtSearch文本框的TextChange中。这是因为，我想按发布日期过滤掉记录。希望有人能给我一个答案。谢谢！

hope someone could help me here thanks in advance Hi Guys, Thank you for your response guys. However, it's not really the problem here. In the above codes, I forgot to delete "where isDate" in my SQL which I used when I tried a sample one. Here is the original SQL idSQL = "SELECT * FROM Newtransaction" By the way, those codes are inserted in TextChange of txtSearch textbox. This is because, I want to filter out records by issued date. Hope someone could give me an answer. thanks!

推荐答案

要从MS Access数据库中获取数据，请使用以下命令：/ b $ b To fetch data from MS Access database, use sql command like this: SELECT * FROM Newtransaction WHERE [DateField] = #2012/06/01#

SELECT * FROM Newtransaction WHERE [DateField] BETWEEN #2012/05/01# AND #2012/05/31#

记住！日期格式取决于您的系统区域（日期）设置！ 更多信息： www.techrepublic/article/10-tips-for-working-with-dates-in-microsoft-access/6135056 [ ^ ] http ：//stackoverflow/questions/10232187/query-to-retrieve-data-of-specific-date-in-msaccess [ ^ ]

Remember! Date format depends of your system regional (date) settings! More at: www.techrepublic/article/10-tips-for-working-with-dates-in-microsoft-access/6135056[^] stackoverflow/questions/10232187/query-to-retrieve-data-of-specific-date-in-msaccess[^]

Hello， 请更正行 - Hello, please correct the line- idSQL = "SELECT * FROM Newtransaction where isDate "

to

idSQL = "SELECT * FROM Newtransaction where isDate ='DATE'"

或者使用以下内容 -

Or use the following-

idSQL = "SELECT * FROM Newtransaction"