Making ComboBox to display the List from DB table

Bjay · July 29th, 2007, 03:03 PM

Hi Guys,

Please, please can anyone help. I seem to be stuck with a problem, I have created tables in SQL Server 2005 Express with the following definitions:

Customer
    [Customer ID]
    [NAME] nvarchar(100),
    [CONTACT_NAME] nvarchar(60),
    [CONTACT_1] nvarchar(100),
    [CONTACT_2] nvarchar(50),
    [CITY_TOWN] nvarchar(70),
    [PROVINCE] varchar(50),
    [COUNTRY] varchar(100)

Country
  [COUNTRY NAME]
  [City]

I have created a user-interface with Visual Basic Express 2005. So what steps do I use to link a CountryComboBox on the user-interface form to the table - Country [COUNTRY NAME]? So that the CountryComboBox can display the list of countries from the - database table - Country for the user. Thanks a lot.

Probie · August 1st, 2007, 05:55 PM

I do not know if this will work for what you want, but this is what I use with vb6 to open a database and load a listbox.

Code:

Private Sub Command1_Click()
Dim cn As New ADODB.Connection


    List1.Clear


    With cn 'database
   
        cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " & App.Path & "\DataBase Name.mdb;"

    End With

 
Set rs = New ADODB.Recordset 'as we did with the connection
rs.Open "databaseName", cn, adOpenKeyset, adCmdTable 'opening the recordset 
      
      
      With List1 'this will add to a list bpx called List1

      Do While Not rs.EOF       
      .AddItem rs.Fields("database record")'Change the name of the field here to the one you want to show
      .Refresh
      rs.MoveNext
      Loop

    End With

  rs.close  ' tidy up things
  set rs = nothing 
 
end sub