RadGridView Scrolling & Paging

I have a lot of data contained in a RadGridView with scrolling and paging. I need to find a specific element in the Grid. To find it, I need to scroll down through the entire GridView and go through every page verifying the data.

Solution

This is possible with a coded solution. To accomplish the main goal, we need to combine the solutions of the two sub-problems (Scrolling and Paging) seen here and here. We need to take the following steps to implement the solution:

1. Change the default Find Strategy of the Grid to WhenNotVisibleReturnNull, otherwise the Find method will return a FindElementException if the element is not found.

2. Scroll down to the bottom of the Grid.

3. Go through the Grid page by page, repeating step two until the desired element is found

The following code demonstrates how to accomplished this on a Telerik demo site.

public FrameworkElement FindElementByTextContent(string content)
{
    int extentHeight; // The total height of the grid, visible plus non-visible     
    int rowHeight; // The height of the row
    int viewPortHeight; // The height of the visible part of the grid
    int verticalOffset = 0; // Holds the current vertical offset in the viewport

    // Copy the RadGridView into a local variable as a shortcut
    RadGridView grid = Pages.TelerikGridViewFor.SilverlightApp.GridViewRadgridview;

    // Grab the VirtualizingPanel contained in the RadGridView. This is used to control the viewable portion of the grid.
    FrameworkElement VirtualizingPanel = grid.Find.ByType("GridViewVirtualizingPanel");

    // Detect the extent height, view port height and the row height
    extentHeight = (int)VirtualizingPanel.GetProperty(new AutomationProperty("ExtentHeight", typeof(int)));
    rowHeight = (int)grid.GetProperty(new AutomationProperty("RowHeight", typeof(int)));
    viewPortHeight = (int)VirtualizingPanel.GetProperty(new AutomationProperty("ViewportHeight", typeof(int)));

    //Save the original find Find Strategy
    FindStrategy originalStrategy = grid.Find.Strategy;

    //Change the Find Strategy for the RadGridView
    grid.Find.Strategy = FindStrategy.WhenNotVisibleReturnNull;

    // Scroll through each RadGridView page until the element is found or until the "Next Page" is no longer Enabled  
    do
    {
        verticalOffset = 0;
        VirtualizingPanel.InvokeMethod("SetVerticalOffset", 0);
        while (verticalOffset < extentHeight)
        {          
                FrameworkElement fe = grid.Find.ByTextContent(content);
                if(fe != null)
                {  
                    //Return the original strategy
                    grid.Find.Strategy = originalStrategy;

                    //Return the element
                    return fe;
                }

                verticalOffset += viewPortHeight;
                VirtualizingPanel.InvokeMethod("SetVerticalOffset", verticalOffset); 

        }
        Pages.TelerikGridViewFor.SilverlightApp.MoveToNextPageButtonRadbutton.User.Click(ArtOfTest.WebAii.Core.MouseClickType.LeftClick);
    }
    while(Pages.TelerikGridViewFor.SilverlightApp.MoveToNextPageButtonRadbutton.IsEnabled);

    //Return the original strategy
    grid.Find.Strategy = originalStrategy;
    return null;
}

Public Function FindElementByTextContent(content As String) As FrameworkElement

    Dim extentHeight As Integer

    Dim rowHeight As Integer

    Dim viewPortHeight As Integer

    Dim verticalOffset As Integer = 0


    Dim grid As RadGridView = Pages.TelerikGridViewFor.SilverlightApp.GridViewRadgridview


    Dim VirtualizingPanel As FrameworkElement = grid.Find.ByType("GridViewVirtualizingPanel")


    extentHeight = CInt(VirtualizingPanel.GetProperty(New AutomationProperty("ExtentHeight", GetType(Integer))))
    rowHeight = CInt(grid.GetProperty(New AutomationProperty("RowHeight", GetType(Integer))))
    viewPortHeight = CInt(VirtualizingPanel.GetProperty(New AutomationProperty("ViewportHeight", GetType(Integer))))


    Dim originalStrategy As FindStrategy = grid.Find.Strategy


    grid.Find.Strategy = FindStrategy.WhenNotVisibleReturnNull


    Do
        verticalOffset = 0
        VirtualizingPanel.InvokeMethod("SetVerticalOffset", 0)
        While verticalOffset < extentHeight
            Dim fe As FrameworkElement = grid.Find.ByTextContent(content)
            If fe IsNot Nothing Then

                grid.Find.Strategy = originalStrategy


                Return fe
            End If

            verticalOffset += viewPortHeight

            VirtualizingPanel.InvokeMethod("SetVerticalOffset", verticalOffset)
        End While
        Pages.TelerikGridViewFor.SilverlightApp.MoveToNextPageButtonRadbutton.User.Click(ArtOfTest.WebAii.Core.MouseClickType.LeftClick)
    Loop While Pages.TelerikGridViewFor.SilverlightApp.MoveToNextPageButtonRadbutton.IsEnabled


    grid.Find.Strategy = originalStrategy
    Return Nothing
End Function

Place this in the code-behind and then call this method from a coded step.