Dropdownlist

Question

Hi,
There are three dropdownlist
1.dropdown_city
2.dropdown_state
3.dropdown_country
when i choose a city from the dropdown_city,its 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 City,State 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