How to Select data field to display in drop down list ?

Question

hi guys i have 2 tbls are below 1/(RegionTbl). Region id PK RegionName Nvarchar 2/ (CityTbl) CityID RegionID Fk CityName Nvarchar Pk and in application i have 2 dropdownlist  list1 is datasource from RegionTble To select RegionName and list 2 from CityName in order to seletc from list1 regionname to display cities in list2 as afilter data please give me solution step by step

Upendra Pratap Shahi · Answer

Hi Go through below link- http://www.c-sharpcorner.com/UploadFile/Dorababu742/cascading-dropdown-list-in-Asp-Net-using-entity-framework/ http://www.aspdotnet-suresh.com/2012/11/country-state-city-cascading.html http://www.aspsnippets.com/Articles/Creating-Cascading-DropDownLists-in-ASP.Net.aspx Kindly accept the answer.

Upendra Pratap Shahi · Answer

Use cascaded dropdown list for this call a method on dropdown change event and then bind that with first dropdown.

Abdalla Elawad · Answer

thanks Shahi believe me am not know use cascaded .. you can explain more or give me Example my way to call datasource from 2 tables

Munesh Sharma · Answer

http://www.aspdotnet-suresh.com/2012/11/country-state-city-cascading.html