Hi, i have 2 dropdownlist and i want when i select country from first drop down second drop down should show the states of that country.
i had made 2 tables - one is country and other is states.
country has 2 column - country_id and country_name
state has 3 column - state_id, country_id and state_name.

country id in state table is as fk .

and i am trying this ,, plz help me---

string id = ddlcountry.SelectedValue;
           string qry = "select State_Name from State where Country_ID=(Select Country_ID from Country where Country_Name='" + id +"')";
            SqlDataAdapter adp = new SqlDataAdapter(qry,con);
            DataSet ds = new DataSet();
            adp.Fill(ds);

            ddlstate.DataValueField = "State_Name";
            ddlstate.DataSource = ds;
            ddlstate.DataBind();

Hi try this




string id = ddlcountry.Selecteditem.value; //Gets the selected countrie's id
 string qry = "select State_Name from State where Country_ID=" + id ;
            SqlDataAdapter adp = new SqlDataAdapter(qry,con);
            DataSet ds = new DataSet();
            adp.Fill(ds);

            ddlstate.DataValueField = "State_ID";
            ddlstate.DataTextField = "State_Name";
            ddlstate.DataSource = ds;
            ddlstate.DataBind();


gudluck


Archu

Hi guys,

I'm working on a similar thing, but I have 4 Dropdown menus, with the contents of a dropdown being populated from the previous.

Am I right in assuming I can use a similar process with more Dropdowns?

I just want to get the idea right and give it a go at coding it myself first (No doubt there will eb a reply when i get stuck :D)

Cheers

You surely can. And with AJAX you can make it very clean and fast.

-Peter

To add to Peter's point, you can check some wonderful controls of AJAX live at:

http://www.asp.net/ajax/control-toolkit/live/

Regards
Mike