How to update gridview, after selecting an option from drop-box and clicking search

Question

0.00/5 (No votes)

See more:

, +

Hi,

I need help to update my grid-view after selecting a filter from a drop-down list and clicking the search button.

I have a drop-down list which contains distinct person_types and when I select a person_type from the list I want to click search and for it to automatically update the grid-view.

This is the code for my gridview:

ASP.NET

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
                                BackColor="White" BorderColor="#CC9966" BorderStyle="None" BorderWidth="1px" 
                                CellPadding="4" DataSourceID="SqlDataSource2" 
                                Width="2092px" AllowSorting="True" 
                                onselectedindexchanged="GridView1_SelectedIndexChanged">
                                <Columns>
                                    <asp:BoundField DataField="Employee_ID" HeaderText="EmployeeID" 
                                        SortExpression="Employee_ID" />
                                    <asp:BoundField DataField="Student_ID" HeaderText="StudentID" 
                                        SortExpression="Student_ID" />
                                    <asp:BoundField DataField="Title" HeaderText="Title" 
                                        SortExpression="Title" />
                                    <asp:BoundField DataField="Legal_FName" HeaderText="First Name" 
                                        SortExpression="Legal_FName" />
                                    <asp:BoundField DataField="Preffered_FName" HeaderText="Preffered Name" 
                                        SortExpression="Preffered_FName" />
                                    <asp:BoundField DataField="LName" HeaderText="Last Name" 
                                        SortExpression="LName" />
                                    <asp:BoundField DataField="Person_Type" HeaderText="Type of person" 
                                        SortExpression="Person_Type" />
                                    <asp:BoundField DataField="Phone_Number" HeaderText="Phone_Number" 
                                        SortExpression="Phone_Number" />
                                    <asp:BoundField DataField="Mobile_Number" HeaderText="Mobile_Number" 
                                        SortExpression="Mobile_Number" />
                                    <asp:BoundField DataField="Street" HeaderText="Street" 
                                        SortExpression="Street" />
                                    <asp:BoundField DataField="Suburb" HeaderText="Suburb" 
                                        SortExpression="Suburb" />
                                    <asp:BoundField DataField="City" HeaderText="City" SortExpression="City" />
                                </Columns>
                                <FooterStyle BackColor="#FFFFCC" ForeColor="#330099" />
                                <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="#FFFFCC" />
                                <PagerStyle BackColor="#FFFFCC" ForeColor="#330099" HorizontalAlign="Center" />
                                <RowStyle BackColor="White" ForeColor="#330099" />
                                <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="#663399" />
                                <SortedAscendingCellStyle BackColor="#FEFCEB" />
                                <SortedAscendingHeaderStyle BackColor="#AF0101" />
                                <SortedDescendingCellStyle BackColor="#F6F0C0" />
                                <SortedDescendingHeaderStyle BackColor="#7E0000" />
 </asp:GridView>

This is the code for my dropdown list:

ASP.NET

<asp:DropDownList ID="DropDownList1" runat="server" 
                        DataSourceID="SqlDataSource1" DataTextField="Person_Type" 
                        DataValueField="Person_Type">
                    </asp:DropDownList>
                    <asp:Button ID="Button1" runat="server" Text="Search" onclick="Button1_Click" />
                    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                        ConnectionString="<%$ ConnectionStrings:Award_Management2ConnectionString %>" 
                        SelectCommand="SELECT Distinct [Person_Type] FROM [People]">
                    </asp:SqlDataSource>

Currently the code for my search button is:
aspx:

ASP.NET

<asp:Button ID="Button1" runat="server" Text="Search" onclick="Button1_Click" />

aspx.cs:

C#

protected void Button1_Click(object sender, EventArgs e)
 {
     GridView1.DataBind();
 }

Can someone please help me get the search button to update the grid-view please ?

Posted 14-Aug-13 21:13pm

Aamir Mitha

Add a Solution

Comments

idenizeni 15-Aug-13 12:46pm

Where is the code where you populate the sqlDatasource2 object?

venkateshCST 16-Aug-13 1:21am

Hey Aamir,Do you want data to displayed on grid based on item selected in drop down?

Aamir Mitha 18-Aug-13 6:30am

yup that's what I am trying to do

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)

idenizeni · Answer 1 · 2013-08-15T06:57:00

Just use a SelectParameter in your sqlDatasource1's SelectCommand so it references the selected value of your dropdown list, like so...

ASP.NET

<asp:sqldatasource id="sqlDataSource1" runat="server">
 ConnectionString="<%$ ConnectionStrings:Award_Management2ConnectionString %>"  SelectCommand="Select * From sometable Where SomeID=@SelectedId">
    <SelectParameters>
        <asp:controlparameter controlid="DropDownList1" defaultvalue="0" name="SelectedId" propertyname="SelectedValue" />
    </SelectParameters>
 </asp:sqldatasource>

Silvabolt · Answer 2 · 2013-08-15T04:17:00

Since GridView1 uses SqlDataSource2, what you want to do is update and rebind SqlDataSource2 everytime you search. My code isn't exact as I didn't test it, so make sure you go through it yourself.

In your Search button click event, update the datasource, and then rebind.

C#

protected void Button1_Click(object sender, EventArgs e)
{
   //Change your SelectCommand on SqlDataSource2 (make sure the query is right)
   SqlDataSource2.SelectCommand = "SELECT * FROM People WHERE Person_Type=" + DropDownList1.SelectedItem.Text;
   //Execute select statement
   SqlDataSource2.Select(DataSourceSelectArguments.Empty);

   //Refresh DataSource
   GridView1.DataSource = SqlDataSource2; //You may have to convert data here
   GridView1.DataBind();
}

How to update gridview, after selecting an option from drop-box and clicking search

2 solutions

Solution 3

Solution 1

Add your solution here

Preview 0