Use OLEDB Objects to fill listbox from Data Source

[CraigBest]

Looking for code advice on how to load a listbox from an OLEDB data table (or similar object). I already have the connection object set up, I have a command object with the SQL select statement. After the data table is filled, I will assign it to a listbox to automatically fill it.

I need a little help in the midle here -- how do I structure the statements to get my data and fill the DataTable object with it?

Thanks in advance

Craig in NJ

 

[DotNetDoc]

This should do it for you

Dim conTestTable As New OleDbConnection(conString)
Dim da As OleDbDataAdapter = New OleDbDataAdapter("Select * from myTable", conTestTable)
Dim dt As New DataTable
da.Fill(dt)
ListBox1.Datasource = dt

DotNetDoc
M.C.S.D.

http://www.DotNetDoc.com

---------------------------------------

Tell me and I forget. Show me and I remember. Involve me and I understand.
- Anonymous Chinese Proverb

-----------------------------------

If you can't explain it simply, you don't understand it well enough.
- A. Einstein