Filtering in Telerik Radgrid

Question

We use Telerik Radgrid for the application we create. Whenever we click on Radgrid's filter button on each column, it opens up a new popup like window to select the filter options. We have made some changes like, displaying all the rows of column selected in that window.

But the issue is, only limited number of rows is loaded in that window, and not all. Can someone help me out of this, please?

Thanks Manikandan

Answer 1

You have to use FilterTemplate .

 <telerik:GridBoundColumn DataField="Name" FilterControlAltText="Filter Namecolumn"
                HeaderText="Name" UniqueName="Name">
                <FilterTemplate>
                    <telerik:RadComboBox ID="rcboName" DataSourceID="sqlNameDataSource" DataTextField="Name"
                        DataValueField="Name" AppendDataBoundItems="true" SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("Name").CurrentFilterValue %>'
                        runat="server" OnClientSelectedIndexChanged="NameIndexChange" Width="100px">
                        <Items>
                            <telerik:RadComboBoxItem Text="All" />
                        </Items>
                    </telerik:RadComboBox>
                    <telerik:RadScriptBlock ID="RadScriptBlock2" runat="server">
                        <script type="text/javascript">
                            function NameIndexChange(sender, args) {
                                var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
                                tableView.filter("Name", args.get_item().get_value(), "EqualTo");
                            }
                        </script>
                    </telerik:RadScriptBlock>
                </FilterTemplate>
            </telerik:GridBoundColumn>

In my example , I use sqlNameDataSource for combobox's datasource .

    <asp:SqlDataSource ID="sqlNameDataSource" runat="server"   
      ConnectionString="<%$ ConnectionStrings:MyConnectionString %>"
    SelectCommand="SELECT * FROM NameTable">
    </asp:SqlDataSource>

You can change this datasource and datafield of your table !