如何使用两个下拉按钮过滤gridview? [英] how to filter the gridview using two dropdown button?

问题描述

大家好.

我在过滤下拉菜单时遇到问题.
我有两个下拉按钮.
第一个下拉菜单就可以了.它会运行.
但在我的其他下拉菜单中.什么都没发生.

我从第一个下拉菜单开始使用数据库.
但是当我再次将其用于另一个下拉菜单时.

什么都没发生.

我希望你能帮助我.

谢谢.

OP的代码:

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-

-chaosgray-

推荐答案

ConnectionStrings:ConnectionString％> SelectCommand ="SELECT [ID]，[CourseTitle]，[Discipline]，[Status]，[Date_Modified]，[Date_Created]，[Date_Approved]，[Last_Modified_By] FROM [tblTrainingPlan]来自DeleteCommand ="从[tblTrainingPlan]中删除ID] = @ID"InsertCommand =" INSERT INTO [tblTrainingPlan]([CourseTitle]，[Discipline]，[Status]，[Date_Modified]，[Date_Created]，[Date_Approved]，[Last_Modified_By])值(@ 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，其中[ID] = @ID> <选择参数> < asp:controlparameter controlid ="type" name ="Discipline" propertyname ="SelectedValue" Type ="DBNull"/> </selectparameters> <删除参数> < asp:参数名称="ID"类型="Int32"/> </deleteparameters> < updateparameters> < asp:参数名称="CourseTitle" Type ="String"/> < asp:参数名称=学科" Type =字符串"/> < asp:参数名称=状态" Type ="String"/> < asp:参数名称="Date_Modified"类型="String"/> < asp:参数名称="Date_Created"类型="String"/> < asp:参数名称="Last_Modified_By"类型="String"/> < asp:参数名称="ID"类型="Int32"/> </updateparameters> <插入参数> < asp:参数名称="CourseTitle" Type ="String"/> < asp:参数名称=学科" Type =字符串"/> < asp:参数名称=状态" Type ="String"/> < asp:参数名称="Date_Modified"类型="String"/> < asp:参数名称="Date_Created"类型="String"/> < asp:参数名称="Last_Modified_By"类型="String"/> </insertparameters>

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-

-chaosgray-

由于不是答案而被质疑.

Moved to question since it is not an answer.

使用SQL数据源，可以使用以下方法过滤GridView:

首先，您需要提供数据源的基本信息:

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>

然后，您需要关闭SQLDataSource标记.

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.

这篇关于如何使用两个下拉按钮过滤gridview?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！