Cascading Drop Down Error selects 1st item instead of selected item

Question

1.00/5 (3 votes)

See more:

I Am Using Cascading Drop down In Asp.Net Website But As I Select Third Or Forth Item From Drop down And Save It, It Stores First Value Only. I filled my form and select Country from country drop down it works smoothly but as i select select country accordingly state drop down is populated and as i select state and click on submit button. Country selected item is stored as per selection but state drop down always selects first item in the list.

protected void Page_Load(object sender, EventArgs e)
{
FirstName.Focus();
if (!IsPostBack)
{
FillCountry();

}
public void FillStates()
{
cn.Open();
cmd.Connection = cn;
cmd.CommandText = "Select CountryID, States from States where CountryId = '" + Country.SelectedValue + "'";
SqlDataReader dr = cmd.ExecuteReader();
State.Items.Clear();
State.DataSource = dr;
State.DataTextField = "States";
State.DataValueField = "CountryID";
State.DataBind();
State.Items.Insert(0, "--Select--");
cn.Close();
cmd.Dispose();
}
protected void Country_SelectedIndexChanged(object sender, EventArgs e)
{
FillStates();

Posted 24-Mar-15 19:18pm

Member 11478531

Updated 24-Mar-15 20:33pm

v3

Add a Solution

Comments

Thanks7872 25-Mar-15 1:24am

Use google. I suggest you to learn some basic ASP.NET first.

Member 11478531 25-Mar-15 2:23am

i am building a web application of data insert into database using asp.net C# so there i have two dropdown list and when i select item from first dropdown proper selection and insertion happens but as i select from second drop down which is populated according to first drop down ( Cascading DropDown ) on postback second dropdown selects first item instead of selected this is my actual problem.

Thanks7872 25-Mar-15 2:26am

Then use 'improve question' link at bottom of your question to edit it. Post this explanation there. Show smallest part of problematic code you have implemented to achieve the same.

Member 11478531 25-Mar-15 2:34am

can you please now check and let me know

Member 11478531 25-Mar-15 7:09am

????

Suvendu Shekhar Giri 25-Mar-15 2:23am

As @Rohan Leuva said, first you should learn basics of ASP.NET and ADO.NET and I am sure you'll get the answer :)

Member 11478531 25-Mar-15 2:25am

@Rohan Leuva , @Suvendu Shekhar Giri please once go through my comment and let me know what mistake i am doing

Member 11478531 25-Mar-15 8:05am

THANK YOU FOR YOUR PRECIOUS TIME ERROR SOLVED.

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)

Abhinav S · Answer 1 · 2015-03-24T20:29:00

Solution 1

This is to be done just like you would save a standard textbox value into the database.
For standard tutorials on saving to database, go through -
Save data from textboxes to database in asp.net [^]
How to Insert data into database in asp net [^]

For specific example on dropdowns -
Save multiple selected list items in database from dropdown list when selected[^]

Posted 24-Mar-15 20:29pm

Abhinav S

v3

Comments

Member 11478531 25-Mar-15 2:32am

Thanks for the reply but i have improved my Question

Member 11478531 · Answer 2 · 2015-03-25T02:04:00

protected void Page_Init(object sender, EventArgs e)
    {
       
        if (!IsPostBack)
        {
            FillCountry();
           
        }
    }
 public void FillCountry()
    {
        cn.Open();
        cmd.Connection = cn;
        cmd.CommandText = "Select ID, Countries from Countries";
        SqlDataReader dr = cmd.ExecuteReader();
        Country.Items.Clear();
        Country.DataSource = dr;
        Country.DataTextField = "Countries";
        Country.DataValueField = "ID";
        Country.DataBind();
        Country.Items.Insert(0, "--Select--");
        cn.Close();
        cmd.Dispose();
    }

    public void FillStates()
    {

        if (Page.IsPostBack)
        {
            cn.Open();
            cmd.Connection = cn;
            cmd.CommandText = "Select StateID, States from States where CountryId = '" + Country.SelectedValue + "'";
            SqlDataReader dr = cmd.ExecuteReader();
            State.Items.Clear();
            State.DataSource = dr;
            State.DataTextField = "States";
            State.DataValueField = "StateID";
            State.DataBind();
            State.Items.Insert(0, "--Select--");
            cn.Close();
            cmd.Dispose();

        }
    }



    protected void Country_SelectedIndexChanged(object sender, EventArgs e)
    {
        FillStates();
    }
}