how to filter the gridview using two dropdown button?

Question

0.00/5 (No votes)

See more:

hello guys.

i have a problem in filtering my dropdown.
i have two dropdown button.
the first dropdown is ok. it runs.
but in my other dropdown. nothing happens.

i use the database from my first dropdown.
but when i use it again to my another dropdown.

nothing happens.

i hope you could help me.

thank you.

OP's Code:

<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
        SelectCommand="SELECT [ID], [CourseTitle], [Discipline], [Status], [Date_Modified], [Date_Created], [Date_Approved], [Last_Modified_By] FROM [tblTrainingPlan]" DeleteCommand="DELETE FROM [tblTrainingPlan] WHERE [ID] = @ID" InsertCommand="INSERT INTO [tblTrainingPlan] ([CourseTitle], [Discipline], [Status], [Date_Modified], [Date_Created], [Date_Approved], [Last_Modified_By]) VALUES (@CourseTitle, @Discipline, @Status, @Date_Modified, @Date_Created, @Date_Approved, @Last_Modified_By)" UpdateCommand="UPDATE [tblTrainingPlan] SET [CourseTitle] = @CourseTitle, [Discipline] = @Discipline, [Status] = @Status, [Date_Modified] = @Date_Modified, [Date_Created] = @Date_Created, [Date_Approved] = @Date_Approved, [Last_Modified_By] = @Last_Modified_By WHERE [ID] = @ID">
        <selectparameters>
       <asp:controlparameter controlid="type" name="Discipline" propertyname="SelectedValue" Type="DBNull" />
       </selectparameters>
        <deleteparameters>
            <asp:Parameter Name="ID" Type="Int32" />
        </deleteparameters>
        <updateparameters>
            <asp:Parameter Name="CourseTitle" Type="String" />
            <asp:Parameter Name="Discipline" Type="String" />
            <asp:Parameter Name="Status" Type="String" />
            <asp:Parameter Name="Date_Modified" Type="String" />
            <asp:Parameter Name="Date_Created" Type="String" />
            <asp:Parameter Name="Last_Modified_By" Type="String" />
            <asp:Parameter Name="ID" Type="Int32" />
        </updateparameters>
        <insertparameters>
            <asp:Parameter Name="CourseTitle" Type="String" />
            <asp:Parameter Name="Discipline" Type="String" />
            <asp:Parameter Name="Status" Type="String" />
            <asp:Parameter Name="Date_Modified" Type="String" />
            <asp:Parameter Name="Date_Created" Type="String" />
            <asp:Parameter Name="Last_Modified_By" Type="String" />
        </insertparameters>

-chaosgray-

Posted 18-May-11 14:15pm

chaosgray

Updated 18-May-11 19:38pm

Nithin Sundar

v5

Add a Solution

Comments

saxenaabhi6 18-May-11 20:19pm

your heading is not matching your question where is the gridview in your question ?
do you want to populate the second dropdown based on the value of first dropdown ?
or you populating both dropdowns from database at the same time ?

chaosgray 18-May-11 20:32pm

im populating both dropdowns from database at the same time.

saxenaabhi6 18-May-11 21:45pm

show the code

chaosgray 18-May-11 22:13pm

im not coding. im just using the datasource.

Nithin Sundar 19-May-11 0:32am

I got a notification that you posted a comment. I think you deleted it. I hope you have found your solution. The Property is like for example "SelectedValue" property of the combo box. This will filter the GridView based on the selected value in the combo box.

chaosgray 19-May-11 1:06am

nothing happens in my program. i used dropdown button.

chaosgray 19-May-11 1:43am

i changed it to string. nothing happen

Nithin Sundar 19-May-11 1:48am

Try this one then:

http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.sqldatasource.filterparameters(v=VS.80).aspx

This is another way of doing it.

chaosgray 19-May-11 2:03am

thank you for that link.

my another problem is.
i have another dropdown box.

how i can filter another column?

chaosgray 19-May-11 2:07am

the filtering is ok.
but when i update it.
the entire row delete.

why?

3 solutions

Solution 2

Moved to question since it is not an answer.

Posted 18-May-11 19:15pm

chaosgray

Updated 18-May-11 19:28pm

v2

Comments

Nithin Sundar 19-May-11 1:27am

I can see one thing which is wrong. In type you have given "DBNull" for the control parameter. What is DBNull? You need to give a type which is like String or so depending on what type of data you are trying to filter.

By the way I'm moving this to the question.

chaosgray 19-May-11 1:35am

i changed it to string. but nothing happens.

Nithin Sundar 19-May-11 1:42am

Hmm that's weird. It's working for me. Are you sure that the controlID and the name you have passed are correct?

Solution 3

<templatefield>
<itemtemplate>
<asp:dropdownlist id="ddl2" runat="server" autopostback="true" onselectedindexchanged="ddl1_changed">
...
</templatefield>

protected void ddl1_changed(object sender,EventArgs e)
{
//filter here using ddl1.selectedvalue.
}

Posted 18-May-11 19:24pm

LakshmiNarayana Nalluri

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)

Nithin Sundar · Accepted Answer · 2011-05-18T17:51:00

With your SQL Data source, you can filter your GridView using this method:

First you provide your basic information for the data source:

<asp:sqldatasource id="DATASOURCENAME" runat="server" connectionstring="YOUR CONNECTION STRING HERE" SelectCommand = "YOUR SELECT STATEMENT HERE">

Now, below that you specify what will be called as the Control Parameter from which the data can be filtered. In this case, a combo box or a drop down.

<selectparameters>

<asp:controlparameter controlid="THE COMBO BOX CONTROL NAME" name="THE COLUMN WHICH YOU WANT TO FILTER" propertyname="PROPERTY NAME" Type="THE DATA TYPE WHICH IS BEING FILTERED" />
                                                                                           
</selectparameters>

And then, you need to close off the SQLDataSource tag.

</asp:sqldatasource>

You can add as many parameters as required to control the data being displayed on the grid. However, watch out for Server postbacks.