Click here to Skip to main content
15,882,794 members
Please Sign up or sign in to vote.
5.00/5 (1 vote)
See more:
Dear Expert,


Expecting the select statement to exclude
'DISBURSED','DENIED'


however the listing includes them






SqlDataAdapter da = new SqlDataAdapter("select * from Apprs_Mast WHERE Facility_Status NOT IN ('DISBURSED','DENIED') order by Appraisal_No", connect);



Is the select statement correct ?
Posted
Comments
vangapally Naveen Kumar 28-Aug-14 7:07am    
what error you are getting?
[no name] 29-Aug-14 1:02am    
every thing looking ok.....................

Just check the type of "Facility_Status" column is varchar or not ! if not please the 'DISBURSED','DENIED' according to the collumn.
 
Share this answer
 
Try to select the ones you want to exclude does that give you the answer you would expect?
select * from Apprs_Mast WHERE Facility_Status ='DISBURSED' OR Facility_Status ='DENIED' order by Appraisal_No

You would expect this query to show you some records - if it doesn't the values are not 'DISBURSED' and 'DENIED'
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900