Dropdownlist

Question

Hi There are three dropdownlist 1.dropdown_city 2.dropdown_state 3.dropdown_country when i choose a city from the dropdown_cityits corresponding state and country will be shown in the respective two dropdownlist. Thanks

Satyapriya Nayak · Answer

Thanks sir but iam using code like this below is it correct.... Imports System.Data Imports System.Data.SqlClient Partial Class _Default Inherits System.Web.UI.Page Dim strConnString As String = System.Configuration.ConfigurationManager.ConnectionStrings.Item( ConnectionString ).ToString() Dim con As New SqlConnection(strConnString) Dim str As String Dim com As SqlCommand Protected Sub Page_Load( ByVal sender As Object  ByVal e As System.EventArgs) Handles Me .Load If Not IsPostBack Then con.Open() str = select * from area com = New SqlCommand(str con) Dim reader As SqlDataReader = com.ExecuteReader While reader.Read DropDownList1.Items.Add(reader( city )) End While reader.Close() con.Close() End If DropDownList2.Items.Clear() DropDownList3.Items.Clear() End Sub Protected Sub DropDownList1_SelectedIndexChanged( ByVal sender As Object  ByVal e As System.EventArgs) Handles DropDownList1.SelectedIndexChanged con.Open() str = select * from area where city=' & DropDownList1.SelectedValue & ' com = New SqlCommand(str con) Dim reader As SqlDataReader = com.ExecuteReader Do While reader.Read DropDownList2.Items.Add(reader( state )) DropDownList3.Items.Add(reader( country )) Loop reader.Close() con.Close() End Sub End Class

Jaish Mathews · Answer

I hope you are using Database to store details. Store CityState and Country in DB tables OnChange of city dropdown fetch the corresponding State and Country from DB. You need to pass the SelectedValue of city dropdown to DB