RadGrid will not show results of RadFilter

3 posts, 0 answers
  1. Calin
    Calin avatar
    12 posts
    Member since:
    Feb 2019

    Posted 24 May 2019 Link to this post

    I am using RadFilter to filter results in a RadGrid. For whatever reason, it will not filter my results in the rad grid. If I used the asp Grid option though, it does work. Is there a setting I am missing? Pictures attatched show that I should be getting results when I filter for cartoon, using the RadGrid and RadFilter, but nothing comes up. 

     

    My code is as follows: (didn't give filter or grid ID names, I am just trying to get it to work at the moment.) 

     

    <telerik:RadFilter ID="RadFilter1" runat="server" FilterContainerID="RadGrid1">
        </telerik:RadFilter>
        <br />
        <br />
     
        <telerik:RadGrid ID="RadGrid1" runat="server" DataSourceID="ListViewFilter" Height="80px">
    <GroupingSettings CollapseAllTooltip="Collapse all groups"></GroupingSettings>
            <MasterTableView AutoGenerateColumns="False" DataSourceID="ListViewFilter">

                <Columns>
                    <telerik:GridBoundColumn DataField="EE" FilterControlAltText="Filter EE column" HeaderText="EE" SortExpression="EE" UniqueName="EE">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="Interest" FilterControlAltText="Filter Interest column" HeaderText="Interest" SortExpression="Interest" UniqueName="Interest">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="Like_or_Dislike" FilterControlAltText="Filter Like_or_Dislike column" HeaderText="Like_or_Dislike" ReadOnly="True" SortExpression="Like_or_Dislike" UniqueName="Like_or_Dislike">
                    </telerik:GridBoundColumn>
                </Columns>

            </MasterTableView>
        </telerik:RadGrid>
        <asp:SqlDataSource ID="ListViewFilter" runat="server" ConnectionString="<%$ ConnectionStrings:Interests.My.MySettings.dbInterests %>" SelectCommand="FilterList" SelectCommandType="StoredProcedure"></asp:SqlDataSource>

     

     

  2. Attila Antal
    Admin
    Attila Antal avatar
    440 posts

    Posted 29 May 2019 Link to this post

    Hi Calin,

    You have set everything correctly, and the filtering would work with case sensitive keywords. Only that the grid has case sensitive filtering enabled by default. You can turn it off by setting the CaseSensitive property to false in the GroupingSettings.

    <telerik:RadGrid ID="RadGrid2" runat="server" DataSourceID="ListViewFilter" Height="80px">
        <GroupingSettings CollapseAllTooltip="Collapse all groups" CaseSensitive="false"></GroupingSettings>
    </telerik:RadGrid>


    Kind regards,
    Attila Antal
    Progress Telerik
    Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
  3. Calin
    Calin avatar
    12 posts
    Member since:
    Feb 2019

    Posted 29 May 2019 in reply to Attila Antal Link to this post

    That did the trick! Thank you!
Back to Top