ASP.NET Dynamic Data

Re: How to search grid results based on user provided values?

sjnaughton — Sat, 21 Nov 2009 21:00:38 GMT

Hi Kisyv, have a look at my blog post here: http://csharpbits.notaclue.net/2009/01/dynamic-data-filtering-installation.html where I show how to get DD filtering working in your site I hope this helps

Re: How to search grid results based on user provided values?

kisyv — Sat, 21 Nov 2009 20:14:41 GMT

Im not sure where I shall put this code. Could anyone explain? Im new to ASP.NET and have also looked at http://heyse.us/blog/?p=100 but I can't get anything out of it. Thanks

Re: How to search grid results based on user provided values?

jfaigan — Fri, 24 Oct 2008 12:31:46 GMT

I tried my hand out at adding the attribute metadata part of the project. I got it working...don't know if it is optimal but it works. Here is the code:

[AttributeUsage(AttributeTargets.Property | AttributeTargets.Class, Inherited = true, AllowMultiple = false)]

public class FilterColumnAttribute : Attribute

{

public static FilterColumnAttribute Default = new FilterColumnAttribute(string.Empty);public FilterColumnAttribute(string columns)

{

Columns = columns;

}

public string Columns { get; private set; }

}

-----------------------------------------

Here are a couple of changes I made to your original code to use the new attribute:

private string FilterColumns(MetaTable table)

{

FilterColumnAttribute fc = table.Attributes.OfType<FilterColumnAttribute>().DefaultIfEmpty(FilterColumnAttribute.Default).First();return fc.Columns;

}

public override IEnumerable<Parameter> GetWhereParameters(System.Web.DynamicData.IDynamicDataSource dataSource)

{

OrExpressionParameter parameter = new OrExpressionParameter();

string[] cols = null;

if (!string.IsNullOrEmpty(FilterColumns(Table)))

{

cols = FilterColumns(Table).Split(',');

for (int i = 0; i < cols.Length; i++)

cols[i] = cols[i].Trim();

--------------------------------------------------------

This is how I implemented it:

[FilterColumn("NameEn,NameFr,DescriptionEn,DescriptionFr")]

partial class PCFSCategory

{

}

Re: How to search grid results based on user provided values?

jfaigan — Thu, 23 Oct 2008 17:10:51 GMT

Hey Josh,

Doh! Ok, silly of me not to have noticed that.

Thanks for everything.

Regards,
Joel.

Re: How to search grid results based on user provided values?

jheyse — Thu, 23 Oct 2008 13:07:44 GMT

Joel,

With this implementation of the Filter Control you don't need to use any attributes. You can specify which columns can be sorted via the Columns property on the TableTextFilterControl to supply a list of comma separated values of searchable columns. I had mentioned in my blog post that a better implementation would be one which read in the Metadata about the model as opposed to the column. The example I posted was just a short implementation to give you an idea of how to implement such functionality.

I hope this helps.

Josh

Re: How to search grid results based on user provided values?

jfaigan — Thu, 23 Oct 2008 00:30:38 GMT

jheyse:

Joel,

The in the code above cols is an array of strings. The Trim() method should be being called on the index of cols at i. cols[i] = cols[i].Trim().ToUpper(); If you just comment the code out you will have some adverse side effects.

I'm not sure what you mean when you refer to the attribute for the metadata. Can you please clarify.

Josh

Ok, just saw the problem...I did not have the array indexer...must have got lost when I did the original copy...I was trying to apply theTrim to the array which is why I was getting the missing extension error.

As for the attribute...how do I specify on the partial class which columns should participate in this search. You mentioned that if no columns are specified then all columns will be searched...but how do you specify the distinct set of columns to search? What is the attribute to be used?

Thanks a lot!

Joel.

Re: How to search grid results based on user provided values?

jheyse — Wed, 22 Oct 2008 23:30:59 GMT

Joel,

The in the code above cols is an array of strings. The Trim() method should be being called on the index of cols at i. cols[i] = cols[i].Trim().ToUpper(); If you just comment the code out you will have some adverse side effects.

I'm not sure what you mean when you refer to the attribute for the metadata. Can you please clarify.

Josh

Re: How to search grid results based on user provided values?

jfaigan — Wed, 22 Oct 2008 22:25:33 GMT

Hi jheye,

Thanks for getting back to me.

I was able to get your original code to compile but I had to remove

//for (int i = 0; i < cols.Length; i++)
// cols = cols.Trim().ToUpper();

because Trim().ToUpper() are extensions to the array class that I do not have. Did you create these extensions?

Also, I do not have the attribute class for defining the metadata. Do you have the code for the attribute?

Please let me know if you don't know what I am talking about.

Thanks for all of your help!

Joel.

Re: How to search grid results based on user provided values?

jheyse — Wed, 22 Oct 2008 14:52:48 GMT

Hey Joel,

Sorry for the late response. My blog had some issues with the converting code into emotiocons.

Below should be a version of the filter column that compiles.

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

using Catalyst.Web.DynamicData;

public partial class TableTextSearch : Catalyst.Web.DynamicData.FilterTemplateUserControlBase
{
    public string Columns { get; set; }
 
    private MetaTable Table
    {
        get
        {
            IDynamicDataSource source = this.FindDataSourceControl();
            if (source != null)
                return source.GetTable();
            return null;
        }
    }
 
    public override IEnumerable GetWhereParameters(System.Web.DynamicData.IDynamicDataSource dataSource)
    {
        OrExpressionParameter parameter = new OrExpressionParameter();
 
        string[] cols = null;
        if (!string.IsNullOrEmpty(Columns))
        {
            cols = Columns.Split(',');
            for (int i = 0; i < cols.Length; i++)
                cols[i] = cols[i].Trim().ToUpper();
        }
 
        var columns = (from c in Table.Columns
                       where cols == null || cols.Length == 0 || cols.Contains(c.Name)
                       group c by c.TypeCode).ToDictionary(g => g.Key, g => g);
 
        foreach (var column in columns[TypeCode.String])
        {
            parameter.Parameters.Add(new LikeExpressionParameter()
                    {
                        Type = TypeCode.String,
                        Name = column.Name,
                        Value = TextBox1.Text,
                        Like = LikeExpressionParameter.LikeType.Contains
                    });
        }
        yield return parameter;
    }
 
    public override void LoadQueryStringParameters(System.Collections.Specialized.NameValueCollection parameters)
    {
        TextBox1.Text = parameters["TableTextSearch"];
    }
 
    public override System.Collections.Specialized.NameValueCollection SaveQueryStringParameters()
    {
        return new NameValueCollection() { { "TableTextSearch", TextBox1.Text } };
    }
 
    public override void Clear()
    {
        TextBox1.Text = string.Empty;
    }
}

Re: How to search grid results based on user provided values?

jfaigan — Wed, 22 Oct 2008 11:35:08 GMT

Hey jheyse,

Have you had a chance to review this post?

I removed the Trim() call from the code and everything compiles but without the attribute class it is only searching across all columns. Do you have the code for your attribute class? Will you be publishing a new version of your code soon?

Regards,
Joel.

Re: How to search grid results based on user provided values?

jfaigan — Sat, 18 Oct 2008 23:14:51 GMT

Hey jheyse,

I've been trying to implement your TableTextSeach filter control and I've copied over the code from your post but I am getting compile errors about missing references (for example it cannot find IDynamicDataSource). Am I missing a reference?

Have you added this component to CodePlex?

Thanks a lot!

Joel.

--EDIT--

Forget what I said...I was just missing a using stmt.

Joel.

--EDIT--

Ok, almost have it compiling without errors...most recent error is on cols.Trim()...getting an error that System.Array does not support Trim()
Am I missing a reference or using stmt?

Also, where is your Columns attribute defined? Which namespace? I assume that this becomes metadata on the table partial class.

Do you perhaps have a working example?

Thanks,
Joel.

Re: How to search grid results based on user provided values?

jfaigan — Sat, 18 Oct 2008 17:00:09 GMT

jheyse:

Here is a short example on how to accomplish this:

http://blogs.catalystss.com/blogs/josh_heyse/archive/2008/10/17/dynamic-data-filtering-table-text-search.aspx

I just checked out the example and that looks pretty amazing! I am going to try to implement it (hopefully today) and I will post feedback here.

Once again, thank you very much for your help.

Joel.

Re: How to search grid results based on user provided values?

jfaigan — Sat, 18 Oct 2008 16:55:07 GMT

jheyse:

Are you trying to search for only text or all values? For example if you put a date into the text box shoudl it be able to convert and search DateTime columns?

This is similar to the custom column defined here:

http://blogs.catalystss.com/blogs/josh_heyse/archive/2008/05/23/a-richer-dynamicdatafilter-part-5-columncontains.aspx

Hadn't really thought about that...I guess that could be very interesting...if the "multi-filter" took into account the data type and tried to convert the user input...

The "multi-filter" would only need to check against columns that subscribed to it...for example if I had a birthdate field I wouldn't want the created and modified date fields to be searched as well...that would affect the filter results.

I wil check out your link! Thanks for the input!

Joel.

Re: How to search grid results based on user provided values?

jheyse — Sat, 18 Oct 2008 01:48:31 GMT

Here is a short example on how to accomplish this:

http://blogs.catalystss.com/blogs/josh_heyse/archive/2008/10/17/dynamic-data-filtering-table-text-search.aspx

Re: How to search grid results based on user provided values?

jheyse — Fri, 17 Oct 2008 15:16:01 GMT

Are you trying to search for only text or all values? For example if you put a date into the text box shoudl it be able to convert and search DateTime columns?

This is similar to the custom column defined here:

http://blogs.catalystss.com/blogs/josh_heyse/archive/2008/05/23/a-richer-dynamicdatafilter-part-5-columncontains.aspx