DropDownList Problem Need Help!!

Question

1.00/5 (1 vote)

See more:

I am having an error come up in my code that says: Error Ambiguity between 'SchoolReports.DropDownListCFY1' and 'SchoolReports.DropDownListCFY1()'. What I am trying to do is that I have two dropdownlists that are databound to a sqldatasource. When I select a name of a school in the first ddl I would like the second to show only years that matches that school. So far this is not working. Can someone help me because I think I am stuck.

C#

protected void DropDownListSchools_SelectedIndexChanged(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["PasswordConnectionString"].ConnectionString);
        con.Open();

        lblINST_ID.Text = DropDownListSchools.SelectedValue;




    }
    protected void DropDownListCFY1_SelectedIndexChanged(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["PasswordConnectionString"].ConnectionString);
        con.Open();
        SqlCommand scmd = new SqlCommand("Select TOTASSETS, TOTLIABILITY from TableFIN where INST_ID = " + DropDownListCFY1.SelectedValue.ToString(), con);

        SqlDataReader dr = scmd.ExecuteReader();
        if (dr.Read())
        {
            TextBoxTA1.Text = dr["TOTASSETS"].ToString();

            TextBoxTL1.Text = dr["TOTLIABILITY"].ToString();

            int a = Convert.ToInt32(TextBoxTA1.Text);
            int b = Convert.ToInt32(TextBoxTL1.Text);
            TextBoxTNA1.Text = Convert.ToString(a - b);



        }
        dr.Close();
        con.Close();

Posted 6-Sep-13 3:49am

Computer Wiz99

Updated 6-Sep-13 5:12am

v2

Add a Solution

Comments

ZurdoDev 6-Sep-13 9:55am

Name your control something else. It is a conflict.

Computer Wiz99 6-Sep-13 10:00am

Ok. In my code I have a blue line under the DropDownListCFY1() that is part of protected void. And I have a red line under DropDownListCFY1 that is part of the .SelectedValue.ToString(). Which one should be changed?

ZurdoDev 6-Sep-13 10:05am

Doesn't matter.

Computer Wiz99 6-Sep-13 10:10am

If I change the name of the control then my code will not work. So how am I going to change the name of the control that I want to control?

ZurdoDev 6-Sep-13 10:20am

Of course you would also have to change the name of it anywhere referenced.

Computer Wiz99 6-Sep-13 10:32am

Ok. Show me which one would you change. I called DropDownListCFY1 in ddlSchools SelectIndexChange. Before I did it I changed the protected void DropDownListCFY1 SelectedIndexChanged event. That made the DropDownListCFY1.SelectedValue.ToString() to have the red line under it. Should I just call all of the ddl in the DropDownListSchools_SelectedIndexChanged event?

Computer Wiz99 6-Sep-13 10:52am

Ok. I deleted all that was under the protected void DropDownListCY1() and saved it. When I open the form in the web browser i get this error: Compilation Error. What did I do wrong again/

ZurdoDev 6-Sep-13 10:56am

You have 2 things named the same. You need to rename 1 of them in every location it is used.

Computer Wiz99 6-Sep-13 11:02am

Ok. I went back to original code. Everything is back to normal as far as the naming goes. Is there a better way for a user to login and select a school from the DropDownListSchools and have the DropDownListCFY1 for the years to only show the years that match that school. The value of the schools is INST_ID. So If I select a school then there show be five years populated into the ddlCFY1 for that school. When I say years I mean 2009, 2010, 2011, 2012 and 2013. Here is my original code is posted.

ZurdoDev 6-Sep-13 11:17am

A better way? I don't understand what you are asking. If it works, it works.

Computer Wiz99 6-Sep-13 11:20am

It works but not the way I want it to.What is happening it that a user can select a school then can select a different year from another dropdownlist. Every time the user tries to select a different year it resets back to that first year. Why is it doing that?

ZurdoDev 6-Sep-13 11:22am

I don't know. You should create a new question and address that issue. Post the code for your Page_Load event. What you are describing likely means you are databinding your dropdown in PageLoad without checking for IsPostBack.

Computer Wiz99 6-Sep-13 11:24am

This is what is in my PageLoad:

protected void Page_Load(object sender, EventArgs e)
{
ButtonPrint.Attributes.Add("onclick", "window.print(); return false");

}

All of my ddl has the PostBack checked.

Computer Wiz99 6-Sep-13 11:33am

I can select the same year that does not match the school and it shows the data in the textboxes. The DropDownListCFY1 is populated by the SqlDataSource.

ZurdoDev 6-Sep-13 11:42am

Yes, please open a new question so we can focus on that.

Computer Wiz99 6-Sep-13 12:02pm

The new question has been posted.

1 solution

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)

OriginalGriff · Accepted Answer · 2013-09-06T04:07:00

Either
1) You have created a method with the same name as a control "DropDownListCFY1" and the compiler is confused, which would make a lot of sense.
Or
2) You have tried to use a void method to return a value without referencing it as a method by adding the brackets when you call it.

I suspect it is the first one: so change the name of your method to something more sensible and don't forget to change the references where you actually want to call it as well. Change the name manually - do not rely on VS to do it. As you have a control of the same name, it will probably change at least some of the wrong names!