getting error when passing multiple argument

Question

sir i want to retrieve those values which is not null. i have written this query but getting error. please help.

my query is :-

SqlCommand sqlcmd = new SqlCommand("Select wifi,restaurant,Transport,Exercise,Business,FoodBar,Casino,Swimming,Shopping,Wheelchair from hotel_facilities where wifi,restaurant,Transport,Exercise,Business,FoodBar,Casino,Swimming,Shopping,Wheelchair is Not null in(Select hotel_name from hotel_Addrecord where hotel_id='" + getid + "' )", sqlcon);

Nanhe Siddique · Answer

hi rajeev you are using multiple column name in where clause to cheking it is not null. write syntax is SqlCommand sqlcmd = new SqlCommand(Select wifirestaurantTransportExerciseBusinessFoodBarCasinoSwimmingShoppingWheelchair from where hotel_name is in(Select hotel_name from hotel_Addrecord where hotel_id=' + getid + ' ) sqlcon); it may help you An expression of non-boolean type specified in a context where a condition is expected near ''.