SELECT query based on results of CheckedListBox.

Question

Dear Members,

 

In my C# WinApp, I am creating a CrystalReport of employees name and address as label print.

 

1. A DropDown List that has name of cities...

 

2. I select a city (e.g. Vadodara) and the list of names of employees from Vadodara                displayes in a CheckedListBox.

 

3. Now I want to write a code (in a button's click event) that fetches all the employee names and address from the database (displayed in the CheckedListBox) and make a CrystalReport.

 

I am confused with the SELECT query that what I should write after WHERE EmpName=(CheckedListBox Item)?

 

Thanks

 

Mayank Jani