Paging not working in Chrome and IE

[M Kumar]

Hi,
   We bind 6,00,000 rows in rad grid and we set page size is 50, in scroll bar event (OnScroll="ExGrid_OnScroll") we call next 50 rows using button event like adding 50 in paging with existing page size, in fire fox working, but in chrome not working.

Button click event 
  Protected Sub ExGridPagingBtn_Click(sender As Object, e As System.EventArgs) Handles ExGridPagingBtn.Click
        ExGrid.PageSize += 50
        ExGrid.Rebind()
    End Sub

In ExGrid_NeedDataSource

   Protected Sub ExGrid_NeedDataSource(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridNeedDataSourceEventArgs) Handles ExGrid.NeedDataSource
        If Not Session("ExGridDatas") Is Nothing Then
            ExGrid.DataSource = Session("ExGridDatas")
        End If
    End Sub

Note: ExGrid_NeedDataSource got 6,00,000 rows


Pls reply asap,
Thankx

[Eyup]

Hi,

There are couple of ways to achieve this kind of scenario:

1. Virtualization:
https://demos.telerik.com/aspnet-ajax/grid/examples/performance/virtualization/defaultcs.aspx
https://www.telerik.com/blogs/how-to-load-1m-records-in-telerik-s-asp.net-grid-without-compromising-performance

It has its own limitations to achieve such performance, like editing, selecting, templates, etc.:
https://docs.telerik.com/devtools/aspnet-ajax/controls/grid/functionality/scrolling/virtualization#limitations

2. Custom Paging:
https://demos.telerik.com/aspnet-ajax/grid/examples/functionality/paging/custom-paging/defaultcs.aspx

This is not supported with built-in aggregates.

3. Combination of Virtualization and Custom Paging:
https://www.telerik.com/support/kb/aspnet-ajax/grid/details/virtualization-and-custom-paging

4. Infinite paging implementation - this is your current approach by manually increasing the page size when scrolling occurs. You can find working samples here:
https://www.telerik.com/support/code-library/radgrid-lazy-loading-and-infinite-scroll
https://www.telerik.com/support/code-library/infinite-scrolling-with-radlistview

Regards,
Eyup
Progress Telerik

[M Kumar]

Hi 

    Thank's for reply

i enable the

<Virtualization EnableVirtualization="true" />

but i load 6 lakhs record load at time it through the error below screenshot check

http://prntscr.com/mxn4gm

http://prntscr.com/mxn3v5

 

but 1000 record i load the gridview load

[Eyup]

Hi,

The error indicates that you have enabled AJAX on the page which is hiding the real error behind it. You can temporarily disable AJAX. This should give you more details about the error so you can better track and troubleshoot it:
https://www.telerik.com/support/kb/aspnet-ajax/ajaxmanager/details/get-more-descriptive-errors-by-disabling-ajax

One of the messages says 500 Internal Error. This may mean the the database is not accessible.

Regards,
Eyup
Progress Telerik