This is a migrated thread and some comments may be shown as answers.

Filtering and Rebind

7 Answers 369 Views

Grid

This is a migrated thread and some comments may be shown as answers.

7 Answers, 1 is accepted

answered on 02 Oct 2008, 11:58 AM

Hi miksh,

Try clearing the grid filter expression as follows before you Rebind() it:

    
            protected void BtnRebind(object sender, EventArgs e)  
        
            {  
        
                RadGrid1.MasterTableView.FilterExpression = "";  
        
                GridColumn column = RadGrid1.MasterTableView.GetColumnSafe("<YourColumnName>");  
        
                column.CurrentFilterFunction = GridKnownFunction.NoFilter;  
        
                column.CurrentFilterValue = "";  
        
                RadGrid1.Rebind();  
        
            }

Let me know if this works for you.

Sincerely yours,
Iana
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

answered on 06 Oct 2008, 12:30 PM

RadGrid.zip

Hi miksh,

Indeed RadGrid should persist its filtering in the described situating.

Please find the attached a sample project illustrating RadGrid filtering functionality. Try it on your end and let me know what differs in your case and if I missed something from your logic.

Best wishes,
Iana
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

answered on 06 Oct 2008, 02:32 PM

Didn't find how to attach the file so the changes are:
1. Use .net 3.5 telerik dlls (ver. 2008.2.826.35)
2. Change Default1.aspx to (added FilterExpression - btw I couldn't add the filter for any field type of string, e.g. (Title LIKE '%Manager%'))

    
            <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default1.aspx.cs" Inherits="_Default" %> 
        
            <%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %> 
        
            <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 
        
            <html xmlns="http://www.w3.org/1999/xhtml">  
        
            <head runat="server">  
        
                <title>Untitled Page</title> 
        
            </head> 
        
            <body> 
        
                <form id="form1" runat="server">  
        
                    <asp:ScriptManager ID="ScriptManager1" runat="server">  
        
                    </asp:ScriptManager> 
        
                    <div> 
        
                        <asp:Button ID="Button1" runat="server" Text="Rebind" OnClick="Button1_Click" /> 
        
                        <telerik:RadGrid ID="RadGrid1" runat="server" DataSourceID="ObjectDataSource1" GridLines="None" 
        
                            AllowFilteringByColumn="true" OnPreRender="RadGrid1_PreRender">  
        
                            <MasterTableView AutoGenerateColumns="false" 
        
                            FilterExpression="(Supervisor = 2)">  
        
                                <Columns> 
        
                                    <telerik:GridBoundColumn DataField="LastName" HeaderText="LastName" UniqueName="LastName"></telerik:GridBoundColumn> 
        
                                    <telerik:GridBoundColumn DataField="FirstName" HeaderText="FirstName" UniqueName="FirstName"></telerik:GridBoundColumn> 
        
                                    <telerik:GridBoundColumn DataField="Title" HeaderText="Title" UniqueName="Title"></telerik:GridBoundColumn> 
        
                                    <telerik:GridBoundColumn DataField="Courtesy" HeaderText="Courtesy" UniqueName="Courtesy"></telerik:GridBoundColumn> 
        
                                    <telerik:GridBoundColumn DataField="Supervisor" HeaderText="Supervisor" UniqueName="Supervisor"></telerik:GridBoundColumn> 
        
                                </Columns> 
        
                            </MasterTableView> 
        
                        </telerik:RadGrid> 
        
                        <asp:ObjectDataSource ID="ObjectDataSource1" runat="server" SelectMethod="GetAllEmployees" 
        
                            TypeName="EmployeeLogic" />              
        
                    </div> 
        
                </form> 
        
            </body> 
        
            </html>

3. Comment out the code in RadGrid1_PreRender method because it threw the exception.

4. How to test:
a) Run project, by default it will show records with Supervisor =2
b) Add filter LastName contain 'Pe', the only 1 record will be displayed
c) Click Rebind button - it will show records as in a) but preservs LastName filter value 'Pe'.

Product Bundles

DevCraft

Web

Mobile

Document Management

Desktop

Reporting & Mocking

Automated Testing

CMS

UI/UX Tools

Debugging

Free Tools

Support and Learning

Productivity and Design Tools

Filtering and Rebind

7 Answers, 1 is accepted