Hi,
I have CheckedListbox and grid. Based on what are the items checked in listbox that much of items need to be shown in grid.
My SQL procedure like ;
select * from Emp where city in (@Names)
Evertthing is ok if i am checked any of the item and click OK. If i am nothing checked from the listbox i need to display all of the cities from DB. I need to do this work without modifying my procedure.So need to work out in front/end.
if i pass nothing from the code the query seemed as select * from Emp Go to the complete details ...