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. (Last updated on : November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Loading and Paging Grid with Large Database

Thread ID:

Created:

Updated:

Platform:

Replies:

107922 Mar 22,2013 07:05 PM UTC Apr 1,2013 06:53 AM UTC ASP.NET MVC (Classic) 1
loading
Tags: Grid
Marie CG
Asked On March 22, 2013 07:05 PM UTC

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();       
        
    }
 

Bala Murugan A.S [Syncfusion]
Replied On 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


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;