Data Grid - Remote Virtual Scrolling

With remote virtual scrolling, pages are loaded from the server when they enter the viewport. To enable this feature, set the scrolling.mode property to "virtual" and the remoteOperations property to true. The latter informs the DataGrid that the server handles paging.

Was this demo helpful?

Thank you!

Feel free to share demo-related thoughts here.
If you have technical questions, please create a support ticket in the DevExpress Support Center.

Thank you for the feedback!

Backend API

@(Html.DevExtreme().DataGrid<DevExtreme.MVC.Demos.Models.DataService.Sale>() .DataSource(d => d.RemoteController() .LoadUrl("https://js.devexpress.com/Demos/WidgetsGalleryDataService/api/Sales") .Key("Id") ) .RemoteOperations(true) .Scrolling(s => s .Mode(GridScrollingMode.Virtual) .RowRenderingMode(GridRowRenderingMode.Virtual) ) .Paging(p => p.PageSize(100)) .HeaderFilter(hf => { hf.Visible(true); hf.Search(hfs => hfs.Enabled(true)); }) .WordWrapEnabled(true) .Height(440) .ShowBorders(true) .Columns(columns => { columns.AddFor(m => m.Id) .Width(90); columns.AddFor(m => m.StoreName) .Width(150); columns.AddFor(m => m.ProductCategoryName) .Width(120); columns.AddFor(m => m.ProductName); columns.AddFor(m => m.DateKey) .Format("yyyy-MM-dd") .Width(110); columns.AddFor(m => m.SalesAmount) .Format("currency") .HeaderFilter(h => h.GroupInterval(1000)) .Width(100); }) )

using DevExtreme.MVC.Demos.Models; using DevExtreme.MVC.Demos.Models.DataGrid; using DevExtreme.MVC.Demos.Models.SampleData; using System; using System.Linq; using System.Web.Mvc; namespace DevExtreme.MVC.Demos.Controllers { public class DataGridController : Controller { public ActionResult RemoteVirtualScrolling() { return View(); } } }

using System; using System.Collections.Generic; using System.ComponentModel.DataAnnotations; namespace DevExtreme.MVC.Demos.Models.DataService { public partial class Sale { [Key] public int Id { get; set; } [Display(Name = "Category")] public string ProductCategoryName { get; set; } [Display(Name = "Subcategory")] public string ProductSubcategoryName { get; set; } [Display(Name = "Product")] public string ProductName { get; set; } public decimal UnitPrice { get; set; } [Display(Name = "Quantity")] public int SalesQuantity { get; set; } [Display(Name = "Amount")] public decimal SalesAmount { get; set; } [Display(Name = "Date")] public DateTime DateKey { get; set; } [Display(Name = "Store")] public string StoreName { get; set; } } }

In this demo, the server contains 1,000,000 records and returns 100 records per page. The page size is set using the paging.pageSize property. The larger it is, the fewer requests are sent to the server. To reduce the time required for rendering the loaded rows, set the scrolling.rowRenderingMode to "virtual" — the DataGrid renders only rows that are in the viewport.

NOTE

The data source in this demo is configured to return only 1000 records per request.