Text Filtering with Dynamic Data

re: Text Filtering with Dynamic Data

Kushi Bobby — Mon, 19 Sep 2011 10:04:44 GMT

Hi, Pranav,

When i click "here" this is the link its opening 'skydrive.live.com/.../TextSearchFilter and showing page cannot be displayed.

Anyway can u pls update me whether using FilterUIHint(“Search”) in VS2008 is possible?

When i google it comes under V4.0

re: Text Filtering with Dynamic Data

pranav rastogi — Mon, 19 Sep 2011 05:52:58 GMT

Kushi,

can you please try again. I just tried the link and it is accessible.

re: Text Filtering with Dynamic Data

Kushi Bobby — Mon, 19 Sep 2011 01:40:35 GMT

Hi, Having problem in downloading Search.ascx control, can you pls provide alternate location to get it.

Thanks

re: Text Filtering with Dynamic Data

olle — Tue, 29 Mar 2011 15:44:25 GMT

Hi,

Thanks for a very good post.

I have a question though, I have downloaded and added the "Search" FilterUserControl, but how do I use it? I want the textbox search instead of a dropdown list used in this code:¨

<asp:FilterRepeater ID="FilterRepeater" runat="server">

<asp:Label runat="server" Text='<%# Eval("DisplayName") %>' AssociatedControlID="DynamicFilter$DropDownList1" />

<asp:DynamicFilter runat="server" ID="DynamicFilter" OnSelectedIndexChanged="OnFilterSelectedIndexChanged" />

</ItemTemplate

</asp:FilterRepeater>

How do I rewrite the above code to use the "Search" user control (textbox + button) instead of the dropdownlist above? I know I have to tie the Search user control to one or multiple database columns, but at the moment I cannot see the textbox.

Would be grateful for advice.

re: Text Filtering with Dynamic Data

mb — Tue, 15 Mar 2011 09:52:52 GMT

Thanks for the code :)

I don't get it to work though:

I added the Search.aspx, Search.aspx.cs, Search.aspx.designer.cs etc and in Annotations.cs I set

public class Customer_ReportingMetaData

{

[DisplayName("Customer Id")]

[UIHint("TextReadOnly")]

[FilterUIHint("Search")]

public int CustomerId { get; set; }

it compiles but the search textbox is not showing up, what magic is it that will show it?

I guess I'm missing something.

re: Text Filtering with Dynamic Data

ocking — Tue, 15 Mar 2011 04:21:16 GMT

Hi mb. FYR below. It is a integer exact match

Any experts can advise the case insensitive search ? many thx

public override IQueryable GetQueryable(IQueryable source)

{

int searchInt = 0 ;

// Match DB Column Type = Integer

if (Column.TypeCode != TypeCode.Int32)

return source;

if (String.IsNullOrEmpty(TextBox1.Text))

return source;

if (int.TryParse(TextBox1.Text, out searchInt) == false)

TextBox1.ToolTip = "Input correct code";

Type type = typeof(Int32);

string searchProperty = Column.DisplayName;

ConstantExpression searchFilter = Expression.Constant(searchInt);

ParameterExpression parameter = Expression.Parameter(source.ElementType);

MemberExpression property = Expression.Property(parameter, this.Column.Name);

if (Nullable.GetUnderlyingType(property.Type) != null)

{

property = Expression.Property(property, "Value");

}

MethodInfo method = typeof(Int32).GetMethod("Equals", new[] { typeof(Int32) });

var containsMethodExp = Expression.Call(property, method, searchFilter);

var containsLambda = Expression.Lambda(containsMethodExp, parameter);

var resultExpression = Expression.Call(typeof(Queryable), "Where", new Type[] { source.ElementType }, source.Expression, Expression.Quote(containsLambda));

return source.Provider.CreateQuery(resultExpression);

}

protected void Page_Load(object sender, EventArgs e)

{

this.TextBox1.ToolTip = this.Column.DisplayName;

this.validator.ErrorMessage = "Invalid number format specified for " +

this.Column.DisplayName;

this.validator.ToolTip = this.validator.ErrorMessage;

}

protected void Validate(object sender, ServerValidateEventArgs e)

{

int value;

e.IsValid = int.TryParse(e.Value, out value);

}

re: Text Filtering with Dynamic Data

mb — Mon, 14 Mar 2011 18:57:47 GMT

Can you do the same for an int column?

Thanks for a great article.

re: Text Filtering with Dynamic Data

ocking — Mon, 14 Mar 2011 09:57:05 GMT

Hi pranav,

You have a great work and have a top rank in google search

I’ve deployed your coding but it is a case sensitive search

How can I use case in-sensitive search ? Please kindly advise.

System.StringComparison.OrdinalIgnoreCase

Thank you so much

re: Text Filtering with Dynamic Data

WesSmith100 — Tue, 11 Jan 2011 20:45:26 GMT

I forgot to mention I did have to change one line to get it to compile (I'm using pre-release 4 of DD4 because I can't get the admins to install .NET 40 yet)

Changed:

Expression.Parameter(source.ElementType);

to:

Expression.Parameter(source.ElementType, string.Empty);

re: Text Filtering with Dynamic Data

WesSmith100 — Tue, 11 Jan 2011 20:38:38 GMT

Thanks, worked for me first try :-)