ASP.NET Dynamic Data TextSearch Custom Filter Template

Question

I'm trying to implement a custom filter template for all text based searches and running into problems constructing the query. I've been following the instructions posted on this blog but not sure how change the GetQueryable method to perform a

WHERE columnAttribute LIKE '%something%'

query. In the example on the blog the expression is an equality which works if the text I enter exactly matches the text in the database column.

At the moment I'm using the new QueryExtender feature along with the SearchExpression control but this requires creating several custom pages for all the tables I need text search functionality for. I would like to DRY this up by creating the custom filter template. Any help would be greatly appreciated.

Michael Kropat · Accepted Answer · 2011-02-20T19:58:22.870

In LINQ to SQL, the Strings.Contains method is how you express the LIKE operator. What follows is an example of how you could build a filter template around the LIKE operator. For this example, we'll give our custom filter template the name "Text".

The first step is to update the Dynamic Data metadata. Annotate all the columns you want to be able to search on with the FilterUIHintAttribute like so:

[FilterUIHint("Text")]

Now we need to create the "Text" filter template. Create the Text.ascx user control in the filter templates folder (typically "~/DynamicData/Filters"):

<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="Text.ascx.cs" Inherits="Text" %>

<asp:TextBox runat="server" ID="TextBox1" autocomplete="off" OnTextChanged="TextBox1_Changed" />

Next create the code behind, Text.ascx.cs:

public partial class Text : QueryableFilterUserControl {
    public override Control FilterControl {
        get { return TextBox1; }
    }

    protected void TextBox1_Changed(object sender, EventArgs e) {
        OnFilterChanged();
    }

    public override IQueryable GetQueryable(IQueryable source) {
        var value = TextBox1.Text;
        if (String.IsNullOrWhiteSpace(value)) return source;

        if (DefaultValues != null) {
            DefaultValues[Column.Name] = value;
        }

        var parameter = Expression.Parameter(source.ElementType);
        var columnProperty = Expression.PropertyOrField(parameter, Column.Name);
        var likeValue = Expression.Constant(value, typeof (string));
        var condition = Expression.Call(
            columnProperty,
            typeof (string).GetMethod("Contains"),
            likeValue);
        var where = Expression.Call(
            typeof (Queryable),
            "Where",
            new[] { source.ElementType },
            source.Expression,
            Expression.Lambda(condition, parameter));
        return source.Provider.CreateQuery(where);
    }
}

Notice that we have provided no way for the user to postback the page (and hence, update the results) after updating the Text filter. As a matter of style, I find TextBox controls that auto-postback to be confusing, and I find that it is redundant to have a separate button to postback each individual filter. Instead, I like to add a single Button to the page template (for example, "~/DynamicData/PageTemplates/List.aspx") that allows the user to postback the page and update the results. Here is the relevant excerpt:

<asp:Panel runat="server" DefaultButton="UpdateFilter">
    <asp:QueryableFilterRepeater runat="server" ID="FilterRepeater">
        <ItemTemplate>
            <asp:Label runat="server" Text='<%# Eval("DisplayName") %>' OnPreRender="Label_PreRender" />
            <asp:DynamicFilter runat="server" ID="DynamicFilter" OnFilterChanged="DynamicFilter_FilterChanged" /><br />
        </ItemTemplate>
    </asp:QueryableFilterRepeater>
    <asp:Button runat="server" ID="UpdateFilter" Text="Search" />
</asp:Panel>

That's all there is to it. Users should now be able to search for records that contain fragments of text in the specified columns.

What does the UpdateFilter button do to make the filters update? When I implement this button it just does nothing when I click on it. — jpierson, Mar 28 '12 at 05:03
@jpierson All the button does is cause a page postback. During the page lifecycle of the postback, `TextBox1_Changed` should fire, which is what actually triggers an update of the filters. If you’re having issues, you should verify that `TextBox1_Changed` is actually being called. — Michael Kropat, Apr 03 '12 at 23:52

score -2 · Answer 2 · edited Apr 06 '12 at 16:13

-2

Have you tried to use jQuery to handle the filtering and searching?

Here is a great tutorial that shows you how to filter and sort data with jQuery and ASP.NET.

edited Apr 06 '12 at 16:13

рüффп

5,172
34
67
113

answered Dec 01 '10 at 17:21

Mysteric

106
1
9

ASP.NET Dynamic Data TextSearch Custom Filter Template

2 Answers2

Linked