i have 2 dropdownlist pcode(project code) and fyyear(financial year) which i am populating using database coding and then on submit button i have a gridview which will show me values related to...

Question

0.00/5 (No votes)

See more:

The problem is my 'pcode' dropdownlist just works fine but in my 'fyyear' dropdownlist its just showing me values for the first entry only in the gridview like if a project is of two years then its showing me value for first date range lets say for ex 2010-2011 and when i am selecting 2011-2012 nothing is happening and it is automatically showing me the values for first entry only that is 2010-2011??

this is the query i am using on my submit button :

C#

protected void Button2_Click(object sender, EventArgs e)
    {
        try
        {

       
        SqlDataAdapter da = new SqlDataAdapter("select pcode,fyyear,date,salary,ta,contigency,nrc,institcharges,others from monthly where pcode=('" + DropDownList1.SelectedItem.Text + "' ) AND fyyear=('" + DropDownList2.SelectedItem.Text + "')",con);
            DataTable dt = new DataTable();
            da.Fill(dt);
            GridView1.DataSource = dt;
            GridView1.DataBind();
        }

        catch (Exception ex)
        {
            ex.Message.ToString();
        }
    }

both fyyear and pcode are varchar

example pcode ICAR/40/34,Dst-23/101
fyyear 2010-2011, 2011-2012 and so on

Posted 9-Nov-12 16:46pm

a2ulthakur

Updated 9-Nov-12 21:37pm

André Kraak

v2

Add a Solution

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)

Divya RS · Answer 1 · 2012-11-09T17:15:00

Solution 1

Try setting autopostback to true in your dropdownlist

Posted 9-Nov-12 17:15pm

Divya RS

Updated 9-Nov-12 19:51pm

v2

Comments

a2ulthakur 9-Nov-12 23:49pm

sorry did u mean autopostback true for 2nd dropdown is it

a2ulthakur 10-Nov-12 0:07am

and i did that but its of no use..its like it when i select 2nd or 3rd value from dropdownlist 2 it automatically changes my selection to 1st.. one

SoumenBanerjee 10-Nov-12 0:40am

did you populate dropdownlists on page_load from code behined?
If so this can be happen if these code are out side Ispostback checking
if(!Ispostback)
{
......
populate dropdownlist
......
}

Divya RS 10-Nov-12 1:52am

Do check ur project with a breakpoint, u may findout where the value of dropdown changes

a2ulthakur · Answer 2 · 2013-02-12T15:23:00

public void Button2_Click(object sender, EventArgs e)
   {
       try
       {


           SqlDataAdapter da = new SqlDataAdapter("select pcode,fyyear,date,salary,ta,contigency,nrc,institcharges,others from monthly where pcode=('" + DropDownList1.SelectedItem.ToString() + "' ) AND fyyear=('" + DropDownList2.SelectedItem.ToString() + "')", con);
           DataTable dt = new DataTable();
           da.Fill(dt);
           GridView1.DataSource = dt;
           GridView1.DataBind();

           DropDownList1.SelectedIndex = 0;
           DropDownList2.SelectedIndex = 0;
       }

       catch (Exception ex)
       {
           ex.Message.ToString();
       }


   }