Click here to Skip to main content
12,888,493 members (51,462 online)
Rate this:
Please Sign up or sign in to vote.
See more: C#
Database in design a s follows;

Sch_Date datetime
Session number
Course text
Faculty_Code text

select * from Tb_SCh_TIme_Table;

from the database results are retrieved it is working fine.

Sch_Date Session Course Faculty_Code

23/1/2013 1 REO GS
23/1/2013 2 PH2 Vb
23/1/2013 3 TASCO CK
24/1/2013 1 CTF SJ

select Sch_Date,Session,Course,Faculty_Code,from Tb_SCh_TIme_Table where Session='1';

when i execute the below query error shows Data Type mismatch in criteria expression.

the below results is not coming.

23/1/2013 1 REO GS
24/1/2013 1 CTF SJ
Posted 23-Jan-13 23:37pm
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

select Sch_Date,Session,Course,Faculty_Code from Tb_SCh_TIme_Table where Session='1';

try this
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

you have write wrong query. try this

select Sch_Date, Session, Course, Faculty_Code from Tb_SCh_TIme_Table where Session=1

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170424.1 | Last Updated 24 Jan 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100