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

Use Grid without ToList()

Thread ID:





110526 Aug 9,2013 01:10 AM UTC Aug 13,2013 12:50 PM UTC ASP.NET MVC (Classic) 1
Tags: Grid
Asked On August 9, 2013 01:10 AM UTC

Hi there,

I have a very huge database and want to use Syncfusion Grid.
The problem is that all examples that I have seen all need to retrieve the whole database first, I couldnt find any example to query database ondemand.

I can't query the whole table all the time, is there any way to achieve this?


Satheeskumar S [Syncfusion]
Replied On August 13, 2013 12:50 PM UTC

Hi Joao,


Thanks for your interest in Syncfusion products.


If you are using IQueryable, every time the data is fetched from the database in OnDemand not the whole data. We have created a sample using IQueryable to avoid fetching full records from database and to avoid ToList().

We suggest you to refer our Online Sample and Online Documentation for EnableOnDemand.

Please visit the below links.

Online Sample- http://mvc.syncfusion.com/demos/ui/grid/DataBinding/CustomBinding

Online documentation- http://help.syncfusion.com/ug/asp.net%20mvc/grid/default.htm#!documents/custombinding.htm

In our online sample we have used IEnumerable, so we use ToList (). Then we have converted to IQueryable so the data fetching will be in on demand basis.


For your convenience we have attached a sample. Could you please use this sample and get back to us if you have any queries.


Please let us know if you have any other concerns.



Satheeskumar S



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.

Please sign in to access our forum

or the page will be automatically redirected to sign-in page in 10 seconds.

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