Restoring Grid State after data refresh

Hello Mark,

In this scenario when the 'ID' of the DataBoundItem is used to find a RadGridView row reference there no any other solution than the ScrollToRow API. You can use the VScrollBar.PossitionOffset property of the TableElement to save / restore the scroll-bar position, but this solution will not work properly in cases when data is changed, sorting or filtering operation is applied.

If you continue to experience these issues, please send me a sample application with some part of your data so we can review the specific case and try to find the best solution it.

Thank you for your time and cooperation.

Regards,
Julian Benkov
the Telerik team

Hi Mark,

It may not be ideal, but one option to improve the performance of the ScrollToRow call, in your case, might be to wrap the invocation with methods to disable and enable your grid's other events.  The ScrollToRow call should, in theory, be doing nothing more than scrolling to the given row.  The grid should not be introducing any other "side effects" of scrolling; those should be handled explicitly, not accidentally.  How about something like:

DisableGridEvents();
try
{
    grid.ScrollToRow(rowIdx);
}
finally
{
    EnableGridEvents();
}

/// DisableGridEvents
private bool gridEventsEnabled = true;
private void DisableGridEvents();
{
    this.gridEventsEnabled = false;
}

private void Grid_CellFormatting(...)
{
    if (this.gridEventsEnabled)
    {
        // do the normal stuff.
    }
}

That's incomeplete, but I think you'll get the idea.

Hello,

Thank you for contacting Telerik Support.

Suspending the grid events is not a recommended solution because you may encounter a situation in which the CellFormatting will be suspended when it is necessary. Another option is to keep the CurrentRow before refreshing the grid and restore it afterwards, calling the EnsureVisible method as well or restoring the RadGridView.TableElement.VScrollBar.Value.

I hope this information helps. Should you have further questions, I would be glad to help.

Regards,
Desislava
Telerik

Julian,

You stated that when data is changed, sorting or filter the ScrollToRow API will  not work. Is there any solution you can recommend? It seems if you have such an API there should be a way to accommodate this. 

I have a similar issue that sorting and filtering make use of the ScrollToRow invalid. 

Regards

Hello Tim,

Thank you for writing.

According to Julian's post, the TableElement.VScrollBar.PossitionOffset property may not restore the scroll-bar position correctly when sorting or filtering operation is applied. The recommended approaches from my previous post behaves as expected on my end. However, note that you may have current row which is not visible in the view as the vertical scroll bar may be scrolled to a certain value. In this situation it would be better to keep and restore the TableElement.VScrollBar.Value. Calling the TableElement.ScrollToRow method place the specific row to be first into the view no matter if the grid is sorted or not.

If you are still experiencing any difficulties, I would recommend you to open a support thread with a sample project demonstrating the undesired behavior that you are facing. Thus, we would be able to investigate the precise case and assist you further. Thank you in advance.

I hope this information helps. Should you have further questions, I would be glad to help.

Regards,
Desislava
Telerik

Hello, Tel, 

Storing the TableElement.VScrollBar.Value before refreshing the grid and restoring its value after that is a suitable approach to return the vertical scrollbar to its previous location. However, have in mind that the scroll-bar's range depends on the number of rows that are loaded in RadGridView. In other words, the more rows you have, the bigger maximum the vertical scroll-bar has and vice versa. Hence, you have to be careful when setting the TableElement.VScrollBar.Value and prevent exceeding its Maximum.

Should you have further questions please let me know.

 

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik