ComboBox Programming

codingwiz · May 9th, 2011, 11:53 PM

Hi all,

I am currently working through the book beginning VB 2010 and need to implement a code for two combo boxes.
The first combo box (cboCountry) to display and load all the list of countries and the second combo box (cboState) to display and load all the states for each country in cboCountry.
In addition, I want the user to be able to select any country in cboCountry which will automatically load the states for that country in cboState. How do I do this without having to declare every elements in the two combo boxes manually, i.e. Is there a method to call in. NET Framework4 just like the get date method that display current date and time in. NET Framework4 that can do this?

GeneBuchite · May 16th, 2011, 08:46 AM

I would Load all the Countries And States into A Class Named CountryStates, THen Use LINQ to SQL to Fill ComboBox Items.

Code:

 Dim query = From ctry in countryStates

FOr Each cntry IN Query
   cboCountry.Items.Add(cntry.Country)
NExt

Then Fill State After Country Is Selected

Code:

 cboCountry.TExtChanged 

Dim query = From ctry in countryStates Where ctry.Country = cboCountry.Text
cboState.Items.Clear()
FOr Each cntry IN Query
   cboState.Items.Add(cntry.State)
NExt