Hi All,
In Admin, while modifying Countries, States, Cities & Locations using GridView in ASP.Net, how to modify Cities category??
DB Tables:-
==========
Countries:
ID: int, not null, Primary Key
Name: varchar(50), not null
IsActive: bit, not null
Priority: int, not null
States:
ID: int, not null, Primary Key
CountryID: int, not null, Foreign Key (Countries -> ID)
Name: varchar(50), not null
IsActive: bit, not null
Priority: int, not null
Cities:
ID: int, not null, Primary Key
StateID: int, not null, Foreign Key (States -> ID)
Name: varchar(50), not null
IsActive: bit, not null
Priority: int, not null
Now the problem is, while trying to modify Cities Category using GridView, Countries to be populated in dropdownlist with data from Countries table and States to be populated in dropdownlist with data from States table and CityName value in text box. so when trying to modify one city, in edit mode - country, state and city with appropriate db values and country & state in dropdownlist with appropriate and other db values but, when country value is changed, state dropdownlist must also changed with appropriate selected value in county dropdownlist.
please help me...
Regards,
Rajendra Prasad