Data type mismatch in criteria expression.

[veda55536]

Hi,

I've been trying to execute below query in C#.(DataBase :Access)

strTemp = "SELECT Students.Studentid, Persons.FirstName FROM (Persons INNER JOIN Students ON Persons.PersonId = Students.PersonId) " +
"WHERE Students.Studentid not in ( select UnableToEnterSchools.Studentid from UnableToEnterSchools where UnableToEnterSchools.SchoolId = " + SchoolId.ToString() + ")";

i.e...

SELECT Students.Studentid, Persons.FirstName FROM (Persons INNER JOIN Students ON Persons.PersonId = Students.PersonId) WHERE Students.Studentid not in ( select UnableToEnterSchools.Studentid from UnableToEnterSchools where UnableToEnterSchools.SchoolId = 1)

I'm getting below ERROR message,

Data type mismatch in criteria expression.

Please help me out in passing this obstacle.

Thanks in advance.

Regards,
Bob

[r035198x]

.. where UnableToEnterSchools.SchoolId = " + SchoolId.ToString() + ")";

..

Your problem is probably in the quote above.
If the datatype of UnableToEnterSchools.SchoolId is some numeric value then you shouldn't be calling ToString() on SchoolId.ToString(). That would mean you are comparing a numeric column with a character column.

[Curtis Rutland]

I don't think that's the problem, r0. Since that is just the string building part, that's ok.

I think that you should post the actual string. Like, do a MessageBox or Console.WriteLine of the string that you build and show exactly what you are passing on to the database.

[r035198x]

I don't think that's the problem, r0. Since that is just the string building part, that's ok.

I think that you should post the actual string. Like, do a MessageBox or Console.WriteLine of the string that you build and show exactly what you are passing on to the database.

I see what you mean now. Perhaps the column definitions for the OP's tables should also be posted to provide more information.