drop down list problems

Question

0.00/5 (No votes)

See more:

I am new to programming and am trying to fill the 2nd drop down using selected value of the first. But I cant seem to the second drop down to fill with data
Can someone show me where I am going wrong?

C#

protected void Page_Load(object sender, EventArgs e)
        {
            {
                DataTable dt = new DataTable();
                OleDbConnection readData =
                    new OleDbConnection( System.Configuration.ConfigurationManager.ConnectionStrings["ExceptionReportConnection"].ConnectionString);

                readData.Open();
                var objcomand = new OleDbCommand(
                    "SELECT DISTINCT COMPANY FROM GENLIBLE.MANAGERS ORDER BY COMPANY", readData);
                objcomand.CommandType = CommandType.Text;
                OleDbDataAdapter adp = new OleDbDataAdapter(objcomand);
                adp.Fill(dt);
                readData.Close();
                ddCompany.DataSource = dt;

                ddCompany.DataValueField = "COMPANY";

                ddCompany.DataTextField = "COMPANY";

                ddCompany.DataBind();

                ddCompany.Items.Insert(0, new ListItem("--Select--", "0"));
                ddOffice.Items.Insert(0, new ListItem("--Select--", "0"));
                ddDepartment.Items.Insert(0, new ListItem("--Select--", "0"));
                ddType.Items.Insert(0, new ListItem("--Select--", "0"));

                if (ddCompany.SelectedValue == "0")
                {
                    ddOffice.Items.Clear();
                    ddOffice.Items.Insert(0, new ListItem("--Select--", "0"));
                }
            }
        }

        protected void ddCompany_OnSelectedIndexChanged(object sender, EventArgs e)
        {
                DataTable dt = new DataTable();
                var readData1 =
                    new OleDbConnection(
                        System.Configuration.ConfigurationManager.ConnectionStrings["ExceptionReportConnection"]
                            .ConnectionString);
                readData1.Open();
                ddCompany.Items.Clear();

                string s = ddOffice.SelectedValue;
                var objCommand = new OleDbCommand(
                    "SELECT DISTINCT OFFICE FROM GENLIBLE.MANAGERS " +
                    "WHERE COMPANY = '" + ddCompany.SelectedItem.Value + "'");
                
                objCommand.CommandType = CommandType.Text;
                OleDbDataAdapter adp = new OleDbDataAdapter(objCommand);
                adp.Fill(dt);
                readData1.Close();
            
                ddOffice.DataSource = dt;

                ddOffice.DataValueField = "OFFICE";

                ddOffice.DataTextField = "OFFICE";

                ddOffice.DataBind();
                ddOffice.Items.Insert(0, new ListItem("Please Select", ""));
                if (ddOffice.SelectedValue == "0")
                {
                    ddDepartment.Items.Clear();
                    ddDepartment.Items.Insert(0, new ListItem("--Select--", "0"));
                }
            }
        }

Posted 15-Oct-13 1:55am

Neily1982

Updated 15-Oct-13 2:07am

v3

Add a Solution

Comments

Ankur^\m/ 15-Oct-13 8:02am

It would be helpful if you tell us what exactly is not working. Do you get any error or what is it?

[no name] 15-Oct-13 8:04am

ddCompany is filled with the data, but when i click on the next drop down there is nothing in there

Ankur^\m/ 15-Oct-13 8:10am

You mean first time when the page loads or when you change the value in 1st drop down?

[no name] 15-Oct-13 8:13am

when the Page loads the first drop down is populated but when i select a value in the dropdown nothing happens in the second

Ankur^\m/ 15-Oct-13 8:15am

Does the page posts back? If no, you have not set AutoPostBack property to true for the 1st dropdownlist. Set it to true and it should work.
Let me know.

[no name] 15-Oct-13 8:17am

this is my .aspx page

<body>
<form id="form1" runat="server">
<div>
<asp:Label ID="Label1" runat="server" AutoPostBack="true" Text="company">
<asp:DropDownList ID="ddCompany" runat="server" OnSelectedIndexChanged="ddCompany_OnSelectedIndexChanged">
<br/>
<asp:Label ID="Label2" runat="server" AutoPostBack="true" Text="office">
<asp:DropDownList ID="ddOffice" runat="server">
<br/>
<asp:Label ID="Label3" runat="server" AutoPostBack="true" Text="department">
<asp:DropDownList ID="ddDepartment" runat="server">
<br/>
<asp:Label ID="Label4" runat="server" Text="type">
<asp:DropDownList ID="ddType" runat="server">
<br/>

</div>
</form>
</body>

Ankur^\m/ 15-Oct-13 8:21am

As I said, you are missing AutoPostBack property.
Change your 1st dropdownlist code to :
<asp:DropDownList ID="ddCompany" runat="server" AutoPostBack="true" OnSelectedIndexChanged="ddCompany_OnSelectedIndexChanged">
and it should work.

Ankur^\m/ 15-Oct-13 8:24am

Updated the comment with solution. Please check and let me know if it works after that.

[no name] 15-Oct-13 8:48am

THANK YOU IM UP AND RUNNING NOW

Ankur^\m/ 15-Oct-13 8:50am

Delete the comment you posted as answer. And based on our discussion, I am posting the answer. Please accept (and optionally up-vote) it as the question will then be marked as closed.

Siva Hyderabad 15-Oct-13 8:18am

I think ,u modified this line...try this
ddOffice.DataValueField = "COMPANY";

Siva Hyderabad 15-Oct-13 8:19am

just check autoPostback property of ddCompany
if you have not set then set it as AutoPostback="true" in aspx page

[no name] 15-Oct-13 8:47am

THANK YOU IM UP AND RUNNING NOW

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)

Ankur^\m/ · Accepted Answer · 2013-10-15T02:52:00

Solution 3

Based on the discussion with the OP,
1st DropDownList's AutoPostBack[^] property was not set to true. That is why nothing was happening on changing it. Setting it to true solved the issue.

Posted 15-Oct-13 2:52am

Ankur^\m/

Salman622 · Accepted Answer · 2013-10-15T02:16:00

Solution 1

just check autoPostback property of ddCompany
if you have not set then set it as AutoPostback="true" in aspx page

and in your page load event
write all your bussiness logic as below

C#

protected void Page_Load(object sender, EventArgs e)
        {
if(!Ispostback)
{
//your code;
}
}

Posted 15-Oct-13 2:16am

Salman622