The design specified in the question looks like as follows:
1. One table each for each
2. One Column each of each
in each country table.
3. One Field (Row) for each
in each state.
This design is very difficult to implement as any change in No. of Countries requires a change in the No. of
. Similarly any change in the No. of States requires change in the No. of
of the corresponding
A better option is to create three
Country, State, City
which will store one data item per row for Country, State and City respectively.
Then for the functionality stated in the question, the procedure as detailed in the following answer may be used for
Windows Forms Application
stated in the question.
3 combobox for country,state and cities.when i select one country that coressponing states will display in 2nd combobox,and when i select one state that coressponing cities will display in...