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.
Unfortunately, activation email could not send to your email. Please try again.

Loading and Paging Grid with Large Database

Thread ID:

Created:

Updated:

Platform:

Replies:

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

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 02:53 AM

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.

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.

;