We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
close icon

Loading and Paging Grid with Large Database

I have a very large database and need to dynamtically load them as I paged through (possibly with filter).  I am hoping to use Syncfusion GRID virutal scrolling and paging but it does not seem to work for me.  Can you provide some examples?  Thanks.
 
[Controller]
public ActionResult Index()
        {
            var features = db.Features.Include(d => d.FeatureClass);
            return View(features.ToList());
        }
        [AcceptVerbs(HttpVerbs.Post)]
        public ActionResult Index(PagingParams args)
        {
            var features = db.Features.Include(d => d.FeatureClass);
            return features.GridActions<Feature>();
        }
 
[Index.chtml]
 @{Html.Syncfusion().Grid<gThiraMetrix.Models.DavaFeature>("FlatGrid")
          .Datasource(Model)
          .EnablePaging()
          .EnableSorting()
          .Scrolling(scroll => { scroll.AllowVirtualScrolling(true); })
          .Column(column =>
          {
              column.Add(c => c.FeatureID).HeaderText("Feature ID");
              column.Add(c => c.FeatureName).HeaderText("Feature Name");
              column.Add(c => c.FeatureClass.FeatureClass).HeaderText("Feature Class");
              column.Add(c => c.StateAlpha).HeaderText("State");
              column.Add(c => c.CountyName).HeaderText("County");
              column.Add(c => c.Country).HeaderText("Country");
          }).Render();       
        
    }
 

1 Reply

BM Bala Murugan A.S Syncfusion Team April 1, 2013 06:53 AM UTC

Hi Marie CG,

Thanks for using Syncfusion Products.

We have prepared a simple sample for virtual scrolling and the same can be downloaded from the below link.

Sample: http://www.syncfusion.com/downloads/Support/DirectTrac/105408/VirtualScrolling-1078708162.zip

Online documentation link: http://help.syncfusion.com/ug/asp.net%20mvc/grid/Documents/4112virtualscrollinginmvcgrid.htm

Online demo link: http://mvc.syncfusion.com/demos/ui/grid/ProductShowCase/VirtualScrolling

Please let us know if you have any concerns.

Regards,

Bala Murugan A.S


Loader.
Live Chat Icon For mobile
Up arrow icon