[2005] Database Data in a listbox

[jmcilhinney]

Obviously you did something wrong but, given that you haven't shown us what you actually did, we can't see what is wrong with it. All we can do is give you general tips on what you should be doing, which you may or may not already be doing. If you give a clear and full description in the first place then you can get a clear and full solution right away.

So, follow the Data Access link in my signature to see how to populate a DataTable with your data. Once you've got a DataTable you simply bind it to your ListBox:

myListBox.DisplayMember = "DisplayColumnName"
myListBox.ValueMember = "IDColumnName"
myListBox.DataSource = myDataTable

The DisplayMember is the name of the column containing the data you want displayed. The ValueMember is generally the name of the column containing the record IDs. When you select an item in the ListBox you can get the corresponding ID from the control's SelectedValue property.