Loading

getting error when passing multiple argument

rajeev kumar

11y857

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);

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Nanhe Siddique11y ago
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 wifi,restaurant,Transport,Exercise,Business,FoodBar,Casino,Swimming,Shopping,Wheelchair 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 ','.
0