DropDownList Binding and Bind value storing?

Dear Shiva,

 

Provided URL is for Single Level DropDown selection and not for multi level hierarchical DropDown selection. Although the provided URL single level DropDown list is dynamically loaded, the ony difference is that it is using text file instead of SQL server tables.

 

Here is a quick idea -> you need to create Country and State tables in your database and add countryId_foreignKey into State table structure. Then, using my previous provided URL code you can create now two level DropDown lists instead of single level by calling Ajax call on Country DropDown OnChange event. This Ajax call will bind & update your State DropDown list according to the target country selection ID and eventually populates target State DropDown. If in case you have updated the lists in the database they will automatically be reflected on you DropDown lists provided that the page is refresh or DropDown lists are refreshed via Ajax call.