Automatic filter on telrik grid with auto generated column

[Anuj]

Is there any way to apply excel like automatic filter on telrik grid ? I have autogeneratedcolumn=true and based on condition I am showing the column 

<telerik:RadGrid ID="gvinvoice" Width="98%" AllowPaging="true" PageSize="10" runat="server"
                                AutoGenerateColumns="true" 
                                OnPageIndexChanged="gvinvoice_PageIndexChanged" 
                                ShowFooter="True">
                                <PagerStyle Mode="NextPrevAndNumeric" />
                            </telerik:RadGrid>


So, at design time I am not sure the number and name of the column. How can I apply filter to these columns ? 

[Princy]

Hello,

I guess you want to enable filtering option for AutoGeneratedColumns in RadGrid. If so you can easily achieve this by setting AllowFilteringByColumn="true" property for RadGrid . Please elaborate your requirement more if it doesn’t help.

Thanks,
Princy.

[Boris]

how do u set

CurrentFilterFunction="EqualTo" 

on all auto-generated columns?

[Doncho]

Hi Boris, 

You should be able to use the GridCreated event as shown in the Customizing auto-generated columns.

For instance:

protected void RadGrid1_ColumnCreated(object sender, Telerik.Web.UI.GridColumnCreatedEventArgs e)
{
    var col = e.Column;
    col.AutoPostBackOnFilter = true;
    col.CurrentFilterFunction = Telerik.Web.UI.GridKnownFunction.EqualTo;
}

Please give it a try and let me know how it goes.