RadSearchBox in the filter template

[Joslyn]

Hi.
I am using a RadSearchBox in the filter template of a column "Country" .  But its not getting filtered . Can some one help me with some sample .

[Princy]

Hi Joslyn,

Please try the following code snippet to have a RadSearchBox for Filter.

ASPX:

<telerik:RadGrid ID="RadGrid1" runat="server" EnableLinqExpressions="False" AllowFilteringByColumn="True">
 <MasterTableView>
 <Columns>
  <telerik:GridBoundColumn DataField="Country" FilterControlAltText="Filter Country column"   HeaderText="Country" UniqueName="Country">
      <FilterTemplate>
        <telerik:RadSearchBox ID="RadSearchBox1" runat="server" DataSourceID="SqlDataSource2"
            DataTextField="Country" DataValueField="Country" ShowSearchButton="False"
            OnSearch="RadSearchBox1_Search">
        </telerik:RadSearchBox>
     </FilterTemplate>
     </telerik:GridBoundColumn>
 </Columns>
 </MasterTableView>
</telerik:RadGrid>

C#:

protected void RadSearchBox1_Search(object sender, SearchBoxEventArgs e)
 {
    string filterExpression;
    filterExpression = "(Country = '" + e.Value + "')";
    RadGrid1.MasterTableView.FilterExpression = filterExpression;
    RadGrid1.MasterTableView.Rebind();
 }

Thanks,
Princy