spgridview clear filter programmatically

Question

I have a textbox a button and a spgridview. When the button is clicked I will search SharePoint with the value in the textbox and bind it to the spgridview. (I'm using LingDataSource). After I filter the spgridview and then click the button again, the new results is still filtered by the previous filter. I tried this

spgvSearchResults.FilterFieldName = string.Empty;

but this will not work since the property is read only.

How do I, upon button click clear any filter on the spgridview if there is any.

Thanks

Answer 1

Create a descendant of SPGridView and add a method to clear the filter.

public class MySPGridView : SPGridView
{
    public void ClearFilter()
    {
        base.RaisePostBackEvent("__SPGridView__;__Filter__;__ClearFilter__");
    }
}

Answer 2

About as far as I got on this was clearing out LinqDataSource.Where.

This seemed to reset the grid but it still had the Filter icon in the grid header so I don't think this is what you want.

I'm guessing what you'll have to do is...

1. Detect when they click the button (probably in the postback button click function)
2. Remove the grid and datasource from the page's Controls (maybe also in button click function)
3. Create a new grid and datasource, add to the page

Hopefully someone else has a better solution.