如何过滤gridview？ [英] How do I filter gridview?

问题描述

我正在使用sqldatasource绑定的gridview ...我想用文本框文本过滤数据源，但查询为..

i am having a gridview binded with sqldatasource...i want to filter datasource with textbox text but with query as..

<asp:SqlDataSource ID="SqlDataSource1" runat="server"

        ConnectionString="<%$ ConnectionStrings:ConnectionString %>"

        DeleteCommand="DELETE FROM EXP_TBL WHERE (ExpID = @ExpID)"

        SelectCommand="SELECT * FROM EXP_TBL"

        FilterExpression="Title = SELECT * FROM EXP_TBL WHERE ((ExpID LIKE '%@SearchName%') OR (ExpName LIKE '%@SearchName%') OR (ExpAmount LIKE '%@SearchName%') OR (ExpDate LIKE '%@SearchName%') OR (ExpDescription LIKE '%@SearchName%'))">
        <DeleteParameters>
            <asp:Parameter Name="ExpenseID" />
        </DeleteParameters>
        <FilterParameters>
            <asp:ControlParameter Name="Title" ControlID="TextBox2"

                PropertyName="Text"/>
        </FilterParameters>

如何实现这个..................

它的工作原理从代码隐藏填充gridview .......

因为，我有一个绑定到gridview.so的formview以减少我使用sqldatasource的工作...

how to achieve this..................
it worked when filling gridview from codebehind.......
Since, i am having a formview binded to gridview.so to reduce efforts i am using sqldatasource...

推荐答案

ConnectionStrings：ConnectionString ％>

DeleteCommand = DELETE FROM EXP_TBL WHERE（ExpID = @ExpID）

< span class =code-attribute> SelectCommand = SELECT * FROM EXP_TBL

FilterExpression = Title = SELECT * FROM EXP_TBL WHERE（（ExpID LIKE'％@ SearchName％'）OR（ExpName LIKE'％@ SearchName％' ）OR（ExpAmount LIKE'％@ SearchName％'）或（ExpDate LIKE'％@ SearchName％'）或（ExpDescription LIKE'％@ SearchName％'）） >
< DeleteParameters >
< asp：参数 名称 = 费用ID / >
< / DeleteParameters >
< FilterParameters >
< span class =code-keyword>< asp：ControlParameter 名称 = 标题 ControlID = TextBox2

PropertyName = 文字 / >
< / FilterParameters >

ConnectionStrings:ConnectionString %>" DeleteCommand="DELETE FROM EXP_TBL WHERE (ExpID = @ExpID)" SelectCommand="SELECT * FROM EXP_TBL" FilterExpression="Title = SELECT * FROM EXP_TBL WHERE ((ExpID LIKE '%@SearchName%') OR (ExpName LIKE '%@SearchName%') OR (ExpAmount LIKE '%@SearchName%') OR (ExpDate LIKE '%@SearchName%') OR (ExpDescription LIKE '%@SearchName%'))"> <DeleteParameters> <asp:Parameter Name="ExpenseID" /> </DeleteParameters> <FilterParameters> <asp:ControlParameter Name="Title" ControlID="TextBox2" PropertyName="Text"/> </FilterParameters>

如何实现这一点......... .........

从代码隐藏中填充gridview时它起作用.......

因为，我有一个绑定到gridview的formview。所以为了减少我使用sqldatasource的努力...

how to achieve this..................
it worked when filling gridview from codebehind.......
Since, i am having a formview binded to gridview.so to reduce efforts i am using sqldatasource...

我不认为你需要da在 FilterExpression 中选择Statement。



您应该声明它... ...

I don't think you need a Select Statement inside FilterExpression.

You should declare it like...

FilterExpression="Title LIKE '{0}%'"

参考 - 使用TextBox在ASP.Net的SqlDataSource中使用FilterExpression过滤GridView [ ^ ]

尝试

带有过滤器的ASP.NET Gridview [ ^ ]

使用FilterExpression [ ^ ]

GridView with filtering [ ^ ]

Try
ASP.NET Gridview with Filter in Header[^]
Using FilterExpression[^]
GridView with filtering[^]

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