如何过滤GridView [英] how to flter gridview

问题描述

我想从下拉列表和文本框中过滤网格视图，就像我从下拉列表中选择列，然后从文本框中选择名称，id，电话号码一样，我该如何执行此过程

i want to filter grid view from dropdownlist and text box , like i select the column from dropdown and name,id,phone number anything from text box how can i do this process

推荐答案

1.如果您在后面的代码中绑定网格，请参阅此
http://msdn.microsoft.com/en-us/library/system. data.dataview.rowfilter.aspx

2.如果您使用的是SqlDatsource

1.If YOu are binding grid in code behind refer this
http://msdn.microsoft.com/en-us/library/system.data.dataview.rowfilter.aspx

2.If you are using SqlDatsource

<asp:textbox id="contractID" runat="server" >duration</asp:textbox>
<asp:textbox id="duration" runat="server" >duration</asp:textbox>
<asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1">
</asp:GridView>
<br />
<asp:SqlDataSource ID="SqlDataSource1" runat="server"

ConnectionString="<%

ConnectionStrings:ConnectionString SelectCommand =" FilterExpression contractID LIKE'{0}％'和工期LIKE'{1}％'" < FilterParameters > < asp:ControlParameter ControlID =" 名称 contractID " 属性名称 =" 类型 =" 字符串" ">/ > < asp:ControlParameter ControlID =" 名称 持续时间" PropertyName 文本" 类型 =" / > < /FilterParameters > < /asp:SqlDataSource >

ConnectionStrings:ConnectionString %>" SelectCommand="SELECT DISTINCT * FROM [Contract]" FilterExpression="contractID LIKE '{0}%' AND duration LIKE '{1}%'"> <FilterParameters> <asp:ControlParameter ControlID="contractID" Name="contractID" PropertyName="Text" Type="String" /> <asp:ControlParameter ControlID="duration" Name="duration" PropertyName="Text" Type="String" /> </FilterParameters> </asp:SqlDataSource>

以下是一些可以帮助您的示例:

Gridview标头过滤器 [ http://evonet.com.au/creating-a-great-looking-gridview -with-filtering/ [ ^ ]

http://www.aspdotnetexample.com/2011/01/how- to-gridview-header-filtering-in.html [ ^ ]

干杯

Here are a couple of example that could help you:

Gridview Header Filter[^]

http://evonet.com.au/creating-a-great-looking-gridview-with-filtering/[^]

http://www.aspdotnetexample.com/2011/01/how-to-gridview-header-filtering-in.html[^]

Cheers

这篇关于如何过滤GridView的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！