Filtering on auto-generated columns on page load

[Johnathan]

Is it possible to filter auto-generated columns on page load? If so, does anyone have an example of this?

Thanks,

Johnathan

[Shinu]

Hi Jonathan,

Please take a look into the following code snippet I tried to do filter on page load.

ASPX:

<telerik:RadGrid ID="RadGrid1" runat="server" AllowFilteringByColumn="True" EnableLinqExpressions="false"
    AutoGenerateColumns="true" DataSourceID="SqlDataSource1" OnPreRender="RadGrid1_PreRender">
</telerik:RadGrid>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
    SelectCommand="SELECT * FROM [Customers]" />

C#:

protected void RadGrid1_PreRender(object sender, EventArgs e)
{
    if (!Page.IsPostBack)
    {
        GridColumn column = RadGrid1.MasterTableView.GetColumnSafe("Country");
        column.CurrentFilterFunction = GridKnownFunction.Contains;
        column.CurrentFilterValue = "Germany";
        RadGrid1.MasterTableView.FilterExpression = "([Country] LIKE \'%Germany%\') ";
        RadGrid1.MasterTableView.Rebind();
    }
}

Thanks,
Shinu.