Data type mismatch in criteria expression.

Question

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.

krishna prasad · Answer

Hai.. 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

Pompana Goud · Answer

Change This Qry like this It will work 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);

kannan · Answer

Thanks a lot.... I agree its my careless mistake... I concentrate completely on date field. RFID_ID is varchar. Thanks a lot again.....