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 

 

 

 

Answer 1

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. 

Answer 2

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

Answer 3

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 

 

 

Answer 4

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