ComboBox to display to list from DB table

[PaulNeil]

Hello 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.

[Hack]

Dim sSQL As String
        sSQL = "SELECT [country name] FROM yourtable "
        sSQL = sSQL & "ORDER BY [country name] "
        Dim command As New SqlCommand(sSQL, myConnection)
        Dim reader As SqlDataReader = command.ExecuteReader()
        While reader.Read()
            cboCountry.Items.Add(reader.GetString(0) 
        End While
        reader.Close()

myConnection is used to connect to my database. Replace that with your connection object. Also replace yourtable with the name of your database table that holds the countries.