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

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

Naveen.Sanagasetti · Answer 1 · 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

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

Mittu Machhi · Answer 3 · 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

bind data in a dropdown list.

3 solutions

Solution 3

Solution 2

Solution 1

Add your solution here

Preview 0

bind data in a dropdown list.

3 solutions

Solution 3

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us