Error: OleDb Exception Was Unhandled Data type mismatch in criteria expression for Access Database in ASP.Net

paulrajm...

SOLVED CLOSED ACTIVE ANSWERED
User: paulrajmca
Posted: on May 03, 2017 02:40 AM
Forum: Microsoft Access
Answer: 1
Views: 6868

hi Developers , when i retrive datas from database i got the following error. OleDb Exception Was Unhandled Data type mismatch in criteria expression. (Using Ms Access db) i don't know what is wrong with my code.below am adding my using code

string str = "select AttendanceLogs.*,Shifts.EndTime,Shifts.BeginTime,Shifts.Break1,Shifts.Break1BeginTime,Break1EndTime from AttendanceLogs inner join Shifts on Shifts.ShiftId = AttendanceLogs.ShiftId where AttendanceDate between '" + sDate + "' AND '" +tDate + "' and EmployeeId ='" + edr.GetValue(0) + "'";
OleDbCommand getLogs = new OleDbCommand(str, Conn);
OleDbDataReader dr = getLogs.ExecuteReader();

so please suggest me if i done any wron in my code.

thanks with Paul.S

Download FREE API for Word, Excel and PDF in ASP.Net

Andrea

0 1

Reply
User: Andrea
Replied: on May 03, 2017 02:40 AM
Report

Hi @paulrajmca, Please try the following C# Error: Arithmetic overflow error converting expression to data type datetime It might help you. Cheers Andrea.

dharmend...

0 2

Reply
ANSWER
User: dharmendr
Replied: on May 03, 2017 03:13 AM
Modified: on May 03, 2017 03:14 AM
Report

paulrajmca says:

string str = "select AttendanceLogs.*,Shifts.EndTime,Shifts.BeginTime,Shifts.Break1,Shifts.Break1BeginTime,Break1EndTime from AttendanceLogs inner join Shifts on Shifts.ShiftId = AttendanceLogs.ShiftId where AttendanceDate between '" + sDate + "' AND '" +tDate + "' and EmployeeId ='" + edr.GetValue(0) + "'";

Change the above line with the below.

string str = "select AttendanceLogs.*,Shifts.EndTime,Shifts.BeginTime,Shifts.Break1,Shifts.Break1BeginTime,Break1EndTime from AttendanceLogs inner join Shifts on Shifts.ShiftId = AttendanceLogs.ShiftId where AttendanceDate between ('" + sDate + "' AND '" + tDate + "') and EmployeeId = " + edr.GetValue(0);

Guessing your employeeId is integer. That might be the cause.

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Error: OleDb Exception Was Unhandled Data type mismatch in criteria expression for Access Database in ASP.Net

Company

Explore

Follow us

Contact Us