Can anyone help with this i am trying to populate a combobox with the returned values of an SQL statement from an access database the statement returns the values that i want but don't know how to pass the values into the combobox.

SQL statement
FROM Stock
WHERE (Supplier_ID = ?)

i am using the return a datatable option on the vb sql statement builder not sure if this is the right way to return the data but thats why i am asking for help with this.

any help greatly appreciated

This is for a list box but is much the same

Dim connectionString As String = DBConnectionString
        Dim sqlConn As New SQLiteConnection(connectionString)
        Dim SQLComm As New SQLiteCommand("SELECT * FROM Collections", sqlConn)


        Dim r As SQLiteDataReader = SQLComm.ExecuteReader()

        While r.Read()
            lbProjectType.Items.Add(New MyListboxItem(r("CollName"), r("CollGuid")))
        End While


thanks for your response pointed me in the right direction

This question has already been answered. Start a new discussion instead.