Remove Header Context Menu Filter Programatically

[Glenn Boothe]

I'm trying to remove a filter set in the header context menu of a RadGrid like so:

For Each gc As GridColumn In dtgCorp.MasterTableView.Columns

    With gc

        If .IsBoundToFieldName(strRemoveFilter) Then

            .CurrentFilterFunction = GridKnownFunction.NoFilter

            .CurrentFilterValue = ""

            .AndCurrentFilterFunction = GridKnownFunction.NoFilter

            .AndCurrentFilterValue = ""

        End If

    End With

Next

dtgCorp.Rebind()

This will update the actual drop downs and text boxes in the header context menu filter of the column I'm removing the filter for, but it will not actually reevaluate the grid's new FilterExpression, leaving the data filtered with the 'removed' filter.

Is there a way to invoke the grid's filter command or something, and refresh its FilterExpression?

[Tsvetoslav]

Hi Glenn,

You need to following code:

For Each gc As GridColumn In dtgCorp.MasterTableView.Columns
    With gc
        If .IsBoundToFieldName(strRemoveFilter) Then
            RadGrid1.MasterTableView.GetItems(GridItemType.FilteringItem)[0].FireCommandEvent(RadGrid.HeaderContextMenuFilterCommandName, new Triplet("strRemoveFilter", new Pair(GridKnownFunction.NoFilter, ""), new Pair(GridKnownFunction.NoFilter, "")));
        End If
    End With
Next

In addition, the following help article should prove helpful:
http://www.telerik.com/help/aspnet-ajax/grdfirecommandeventfromcode.html

All the best,
Tsvetoslav
the Telerik team

[Glenn Boothe]

Tsvetoslav,
That worked great! I had to make one minor change:

For Each gc As GridColumn In dtgCorp.MasterTableView.Columns
    With gc
        If .IsBoundToFieldName(strRemoveFilter) Then
            RadGrid1.MasterTableView.GetItems(GridItemType.FilteringItem)(0).FireCommandEvent(RadGrid.HeaderContextMenuFilterCommandName, new Triplet("strRemoveFilter", new Pair("NoFilter", ""), new Pair("NoFilter", "")))
        End If
    End With
Next

It seems the RadGrid uses the string value "NoFilter", rather than the enum value GridKnownFunction.NoFilter. So to mimic the filter's Command Event exactly, I had to change that.

Thanks a ton!
Glenn