How to change the item of a dropdownlist from another dreopdownlist change event

Question

0.00/5 (No votes)

See more:

Hi,

I have two dropdownlist one is for city (ddlcity) and another is for location (ddllocation). I want when I select a city from city dropdownlist then only that city location should show in location dropdownlist.
for example: lets select gurgaon city in ddlcity then only location in gurgaon should show in ddllocation.

Thank You.

Posted 12-Jul-11 1:27am

SURBHI TYAGI

Updated 12-Jul-11 2:24am

Pong D. Panda

v3

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ankur^\m/ · Answer 1 · 2011-07-12T01:34:00

If the number of cities and their locations are not very much, then you can use JavaScript (or better jQuery to do the same). Search Google for "cascading dropdownlist javascript" and you will get thousands of example.

The other way is to get the details from server. Check this out - CascadingDropDown[^]. The example tells how to use it as well.

Hope this helps!

Sachin__Sharma · Answer 2 · 2011-07-12T01:35:00

Protected Sub ddlcity_SelectedIndexChanged(sender As Object, e As System.EventArgs) Handles DropDownList1.SelectedIndexChanged
        Dim cmd As New SqlCommand("select location  from mstCities where  city = '" & ddlcity.SelectedItem.Text & "'", con)
        If con.State = ConnectionState.Closed Then
            con.Open()
        End If
        Dim dr As SqlDataReader
        dr = cmd.ExecuteReader
        While dr.Read
            ddllocation.DataSource = dr
            ddllocation.DataBind()
        End While
        con.Close()
    End Sub

<pre>

How to change the item of a dropdownlist from another dreopdownlist change event

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0