Populating ComboBox and CheckedListBox from Database, C#
<p>Ok, as the title says, I'm trying to populate a combobox from a database, then change the contents of the checkedlistbox based on the change in the combobox. The problem here is, I'm about as lost as I could be. I decided to go with an access database (db1.mdb, in the same dir as the exe). The primary data table Table1 has the names of the items that should go in the combobox (item1, item2, item3). Then, I have separate tables for each value(tableitem1, tableitem2, tableitem3), and the listbox will be using these one at a time, listing the "Item Name" fields, of which there are varying amounts in each table. After checking off the options in the checkedlistbox, I need to grab the values from the other columns in that table "value1 and value2" from the database table associated with the checked list box. I've been programming for about 5 years, but have never needed to manipulate a database before, so I'm totally lost.</p>
