Hi friends,
After tried a lot, finally i came here to find a solution.
I am getting "Data type mismatch in criteria expression" in the following line.
OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM ple_rfid_swipelog WHERE RFID_ID=12345 AND ENTRY_DATE=#2010-09-19#", conn);
Please help!
Thanks in advance.
Loading
Posted Sep 20, 2010, 2:08 AM
Just check the sql query alone and check whether u get the output.i feel RFID_ID='12345' and date format is wrong...just check..
With Regards
P.Krishna Prasad
kannanPosted Sep 20, 2010, 2:18 AM
I agree, its my careless mistake... I concentrate completely on date field.
RFID_ID is varchar.
Thanks a lot again.....
Pompana GoudPosted Sep 20, 2010, 2:11 AM
You Didnot Specifed the Datatypes you Used... It will help to Right Qry, Incase RFID_ID as varchar then shouldbe in single quotes '12345'
OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM ple_rfid_swipelog WHERE RFID_ID=12345 AND ENTRY_DATE='09/19/2010'", conn);