Cascading (Country,City)drop down list in asp.net

Question

4.00/5 (1 vote)

See more:

Hi I'm developing a registration form with Country and city name .I need the city to be loaded in the dropdown list based on the selection in country dropdownlist.pls help me with this about what are all the code i should write in c# and help me with the SQL statements also for the records.I need to implement this using Store_procedures..help me with the code friends....

Posted 1-Aug-12 19:23pm

ajithk444

Add a Solution

5 solutions

Solution 5

Implementation of MVC3 Cascading Dropdown using jQuery[^]

Posted 27-May-13 19:25pm

Naufel Basheer

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)

virang_21 · Accepted Answer · 2012-08-01T19:35:00

Solution 1

Try something on your own first ...

To start with check AJAX Control toolkit cascadingDropDown example

http://www.asp.net/ajaxLibrary/AjaxControlToolkitSampleSite/CascadingDropDown/CascadingDropDown.aspx[^]

Posted 1-Aug-12 19:35pm

virang_21

Prasad_Kulkarni · Accepted Answer · 2012-08-01T19:43:00

Solution 3

ASP.NET cascading drop-down-list (CSASPNETCascadingDropDownList)[^]
CascadingDropDown Demonstration[^]
Cascading DropDownList in ASP.NET MVC[^]
Creating Cascading DropDownLists in ASP.Net[^]
Using CascadingDropDown with a Database[^]

Get more on CP Search[^]

Posted 1-Aug-12 19:43pm

Prasad_Kulkarni

Vani Kulkarni · Accepted Answer · 2012-08-01T19:42:00

Did you try searching Google[^] before posting your question here? It returned About 133,000 results (0.40 seconds) for your query. Try using google first.

Top results for your query, Web form scenario:
Using CascadingDropDown with a Database[^]
populate-dropdown-based-selection-other[^]
introduction-here-i-will-explain-how-to[^]

Windows Form scenario:
http://csharpdotnetfreak.blogspot.com/2012/07/cascading-combobox-in-winforms-windows-forms.html[^]

ajithk444 · Accepted Answer · 2012-08-01T21:23:00

hi, i solved it. this was the code.thanks for all the help...

C#

   public void Bind_ddlCountry()
   {
       SqlConObject.Open();
       SqlCommand cmd = new SqlCommand("sp_Country", SqlConObject);
       cmd.CommandType = CommandType.StoredProcedure;

       SqlDataReader dr = cmd.ExecuteReader();
       ddlCountry.DataSource = dr;
       ddlCountry.Items.Clear();
       ddlCountry.Items.Add("Select");
       ddlCountry.DataTextField = "Country_Name";
       ddlCountry.DataValueField = "Country_ID";
       ddlCountry.DataBind();
       SqlConObject.Close();
   }


   public void Bind_ddlCity(int countryid)
   {
       SqlConObject.Open();
       SqlCommand cmd = new SqlCommand("sp_City", SqlConObject);
       cmd.CommandType = CommandType.StoredProcedure;
       cmd.Parameters.Add("@Countryid", SqlDbType.Int).Value = countryid;
       SqlDataReader dr = cmd.ExecuteReader();
       ddlCity.DataSource = dr;
       ddlCity.Items.Clear();
       ddlCity.Items.Add("Select");
       ddlCity.DataTextField = "City_Name";
       ddlCity.DataValueField = "Country_ID";
       ddlCity.DataBind();
       SqlConObject.Close();
       
   }
}
  protected void ddlCountry_SelectedIndexChanged(object sender, EventArgs e)
    {
        Bind_ddlCity(int.Parse(ddlCountry.SelectedValue));
    }