why am I getting too many items in dataset
Posted on 2014-02-06
sqlstring2 = "Select * from EmployeeAccumInfo where (WORKDATE > '" & dateString & " ' and WORKDATE < '" & datestring2 & "') ORDER BY ID ASC "
Dim Dad As OleDbDataAdapter = New OleDbDataAdapter(sqlstring2, Con)
Dim Dst3 As DataSet = New DataSet
workdate is every date in the month of Feb.
dateString = 1/31/2014 and datestring2 = 2/7/2014 These are strings in table and code
when I run the query Dst3 has every date in the table.
How can I get a date > than 2/7/2014???????? it is totally illogical to return every date.