Gridview Data Show Manually From .cs Page

Question

0.00/5 (No votes)

See more:

I have a Gridview and a Dropdown list in my aspx page. I want to set/fill the Gridview data When i select something from the dropdown list(dropdownlist1.SelectIndexChanged event), how to do it?
i want to do it in code behind file(cs file).
Thank you in advance

Posted 15-Dec-13 23:12pm

SumitChandra

Add a Solution

Comments

member 8888995 16-Dec-13 7:04am

Hi,
Do Something like this
1.Read dropdownlist1's selected item in a variable.
2.Then use this value in your query in where clause.
3.Execute this query and get data in a dataset.
4.Set this dataset as datasource to grid.

--
Thanks

SumitChandra 19-Dec-13 0:04am

Thanks for your suggesion.... It works fine

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)

ErBhati · Accepted Answer · 2013-12-17T19:24:00

C#

inside the dropdownlist.selectedchange event
{
       string str="select * from table name where Id="+dropdownlist.seletedvalue+";
       SqlCommand cmd = new SqlCommand(str, con);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds);
        
       gridview.datasource=ds.tables[0];
       gridview.databind();
}

**Dnyaneshwar**@Pune · Accepted Answer · 2013-12-17T19:05:00

Solution 1

Pass the Dropdownlist selected value or text to your sql query. Then the bind the resulted dataset to your gridview. and then bind the gridview.

Posted 17-Dec-13 19:05pm

Dnyaneshwar@Pune

Comments

SumitChandra 19-Dec-13 0:06am

Thanks for your comment... i found it..how to do it via dataset...Thanks a lot

[no name] 19-Dec-13 0:20am

As mentioned below by.. ErBhati

inside the dropdownlist.selectedchange event
{
string str="select * from table name where Id="+dropdownlist.seletedvalue+";
SqlCommand cmd = new SqlCommand(str, con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);

gridview.datasource=ds.tables[0];
gridview.databind();
}