Comparing two dates in .Net using Access mdb strange error..
Posted
by
Markive
on Stack Overflow
See other posts from Stack Overflow
or by Markive
Published on 2011-01-01T16:06:30Z
Indexed on
2011/01/01
16:54 UTC
Read the original article
Hit count: 133
SELECT * FROM Orders WHERE [DateSync] > #2010-11-10 03:11:00#
this works if you run the query from in MS Access but if you get .net to submit it like this...
Dim adapter1 As New OleDbDataAdapter
adapter1.SelectCommand = New OleDbCommand(sSQL, conn)
Dim table1 As New DataTable
connection1.Open()
Try
adapter1.Fill(table1)
Catch ex As Exception
'will error here
Finally
'conn.Close()
End Try
it throws an error....
"No value given for one or more required parameters."
Source="Microsoft JET Database Engine"
Any help much appreciated.
© Stack Overflow or respective owner