I have a CheckedListBox on my Windows Form (built in VB) that gets populated with data from from a table. What I want to be able to do is create a SQL query based on what is checked in the CheckedListBox. For example, If I select Item1 and Item4 from the CheckedList box, I need to create my SQL to look like "SELECT columns from Item1, Item4..."
However, if I only select 1 item then I want this reflected in the SQL statement as well.
Id there a way of cycling through/adding to a colelction list the items in the CheckedListBox? Or is there another method I'm not grasping?