This is a migrated thread and some comments may be shown as answers.

Column sorting and retaining filter

1 Answer 67 Views

Grid

This is a migrated thread and some comments may be shown as answers.

hchattaway asked on 29 Aug 2008, 05:36 PM

I am using the RadGrid with a LinqDatasource, which is working great. I made the columns sortable and I have a couple of fields above the grid I use to filter the grid. The filtering works great also, but when I click on a column header, the filtering is not kept. Do I need to recreate the filter on each click of a column header?

I am creating the filter in the codebehind like this:

    
            Parameter Projectparam = new Parameter(); 
        
            Projectparam.Name = "ProjectID"; 
        
            Projectparam.DefaultValue = this.UserInfo.Profile.GetPropertyValue("ProjectID").ToString(); 
        
            Projectparam.Type = TypeCode.Int32; 
        
            TicketListDataSource.WhereParameters.Add(Projectparam); 
        
            TicketListDataSource.Where = "ProjectID == @ProjectID"

Should this filtering logic be run each time a column header is clicked? Using the "OnSortCommand"?
Thanks!
Harold

Column sorting and retaining filter

1 Answer, 1 is accepted