Google like filtering using the filter template

[Temp]

I have tried searching through threads for 20 minutes on how to use the new FilterTemplate functionality of the RadGrid to apply google type filters to my columns, but can't find anything.

Is there any working example of the google type filtering using the FilterTemplate ?

I would prefer this as my Grid has several non text columns that the google filter does not really apply to, and we would like to use normal filter functionality for that, but wire up the google suggest type for the text fields.

Also to create the grid declaratively with sqldatasource is big bonus.

Any help?

[Princy]

Hello Temp,

 Check out the following forum thread which shows how to implement google like filtering for GridTemplateColumn. Please download the sample and try it.
How to use GridTemplateColumn in Radgrid for google-like filtering.

Thanks,
Princy.

[Pavlina]

Hello,

I prepared a simple example which illustrates the "Google-like" filtering with FilterTemplate. Please find it attached to this message and let me know if it helps you.

Best wishes,
Pavlina
the Telerik team

[Hiren]

Hi Pavlina, i was searching for this sample from 3days today i got it and it matches my requirement, one change is that i want to apply google like filtering for all the columns.

<telerik:GridTemplateColumn DataField="City" HeaderText="City" SortExpression="City"
                        UniqueName="City">
                        <FilterTemplate>
                            <telerik:RadComboBox EnableLoadOnDemand="true" OnClientSelectedIndexChanged="onClientSelectedIndexChanged"
                                runat="server" ID="RadComboBox1" OnItemsRequested="RadComboBox1_ItemsRequested"
                                ShowToggleImage="false" MarkFirstMatch="true">
                            </telerik:RadComboBox>
                        </FilterTemplate>
                        <ItemTemplate>
                            <%# Eval("City")%>
                        </ItemTemplate>
                    </telerik:GridTemplateColumn>
                    <telerik:GridTemplateColumn DataField="FirstName" HeaderText="First Name" SortExpression="FirstName"
                        UniqueName="FirstName">
                        <FilterTemplate>
                            <telerik:RadComboBox EnableLoadOnDemand="true" OnClientSelectedIndexChanged="onClientSelectedIndexChanged"
                                runat="server" ID="RadComboBox2" OnItemsRequested="RadComboBox1_ItemsRequested"
                                ShowToggleImage="false" MarkFirstMatch="true">
                            </telerik:RadComboBox>
                        </FilterTemplate>
                        <ItemTemplate>
                            <%# Eval("FirstName") %></ItemTemplate>
                    </telerik:GridTemplateColumn>

Let me know how to do that, i want to call generic method for combobox selectedIndexChange & ItemsRequested events, based on selected filtering column it should pass the datafield name as parameter so that we can get data related to that particular column

[Pavlina]

Hello Giri,

Please, refer to this forum post for additional information.

Kind regards,
Pavlina
the Telerik team