bind data in a dropdown list.

Question

0.00/5 (No votes)

See more:

Hi,

I have three dropdown list for Contry, state n city....
If i select Country then respective state should bind , same for city...
Please need some advice...

Thanks in advance...

Posted 21-Feb-13 1:39am

Rohit Kolekar11

Add a Solution

3 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)

Mittu Machhi · Answer 1 · 2013-02-21T01:52:00

Try THis :

make auto post back=true property for country and state drpdown.

first bind country data from table.

double click on country dropdown:

 DataSet ds = new DataSet();
SqlDataAdapter myda = new SqlDataAdapter("Select state  FROM tablename where country='"+drop_country.SelectedItem.Value+"'", conn object);
drop_state.Fill(ds);
drop_state.DataSource = ds;
drop_state.DataValueField ="state";
drop_state.DataBind();

now double click on state drop down

        DataSet ds = new DataSet();
        SqlDataAdapter myda = new SqlDataAdapter("Select city  FROM tablename where state='"+drop_state.selectedItem.value+"'", conn object);
        drop_city.Fill(ds);
        drop_city.DataSource = ds;
        drop_city.DataValueField = "city";
        drop_city.DataBind();
<pre>

if any problem please post it.

Mitesh

Surendra0x2 · Answer 2 · 2013-02-21T02:03:00

Solution 2

This is what You Looking For-

http://www.aspsnippets.com/Articles/Creating-Cascading-DropDownLists-in-ASP.Net.aspx[^]

:)

Posted 21-Feb-13 2:03am

Surendra0x2

Naveen.Sanagasetti · Answer 3 · 2013-02-21T02:15:00

I think you have a tables like country_table, state_Table & city_table right...?

In your table you have a PK col is country_id, and you have a relation with state_table also, similarlly in city table also...

in your STATE DropDownList selected index changed event you write this query

SQL

SELECT STATE_Id,STATE_name,CITY_Id FROM STATE_TABLE WHERE COUNTRY_ID=DDLCOUNTRY.SELECTEDVALUE

IN your city dropdownlist selected index changed event you write the query simillar to state...

in your state detail's you must pass the country id, and in your city details you must pass the state_id...

Then fetch the information and assigned into DDL

Note: I'm given some sample information only not exact information

bind data in a dropdown list.

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0