Mayank Jani

Mayank Jani

  • 1.4k
  • 477
  • 27.7k

SELECT query based on results of CheckedListBox.

May 1 2018 8:09 AM
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

Answers (2)