Populating a Listbox

[cmcrae]

I am trying to populate a listbox with the information from a column that is inside a table in my microsoft Access 2000 database. Also I was wondering how to delete a record from that same database..

 

[turrican]

If you are new to this like me, you may find it easier to populate the listbox at design time. I find it easier to bind the listbox to a dataset. I used the datasource property of the listbox. Im pretty sure that there are better ways, but this works for me.

 

[a_jam_sandwich]

This is an example of a dataset binding to a listbox

            Dim MyConn As New New OleDbConnection(<<CONNECTION STRING>>)
            MyConn.Open
            Dim MyAdapter As New OleDb.OleDbDataAdapter("SELECT * FROM TABLE", MyConn)
            Dim MyDataset As New DataSet()  Create dataset
            MyAdapter.Fill(MyDataset, "TABLE")  Fill dataset from adapter
            Listbox1.DataSource = MyDataset.Tables("TABLE")  Set the datasource of listbox
            Listbox1.DisplayMember = "FIELDNAME"  Set the field of the display column
            Listbox1.ValueMember = "ID"  Set the field of the ID field (Optional)
             Cleanup code
            MyDataset.Dispose
            LendersAD.Dispose

Thats for databinding Make sure you substitue your own connection string SQL and Fieldnames

Andy