troubleshooting Question populate combobox from access database

Avatar of designaire
designaireFlag for United States of America asked on
Visual Basic ClassicProgramming Languages-Other.NET Programming
1 Comment1 Solution1095 ViewsLast Modified:
I can't seem to populate this ComboBox from an access database. The Error is in the SQL statement. The table name is Lists and the column I want to use in the combobox is instructorList. It worked when I was using but now I have to convert it to a windows application and I can't make it work.
cnstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\data.mdb;"
        cn = New OleDbConnection(cnstring)
        SQLstring = "SELECT * FROM Lists"
        Dim cmd As New OleDbCommand(cnstring, cn)
        da = New OleDbDataAdapter(cnstring, cn)
        ds = New DataSet
        da.Fill(ds, "data")
        combox1.DataSource = ds.Tables(0)
        combox1.DisplayMember = "data"
        combox1.ValueMember = "instructorList"

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros