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.
Syncfusion Feedback

How can I configure the grid to perform paging, sorting, filtering and grouping in memory?

Thread ID:

Created:

Updated:

Platform:

Replies:

115911 Feb 25,2014 06:33 AM UTC Feb 26,2014 06:48 AM UTC ASP.NET MVC (Classic) 1
loading
Tags: Grid
Andrey kostogarov
Asked On February 25, 2014 06:33 AM UTC

I want to transfer to the client the full range of data

not to access the server for paging, sorting, filtering ...

because it is slow (in the query, data recalculated)

for example, Kendo UI Gid  is done so:

"By default ajax requests will be made for paging, sorting, filtering and grouping. The ToDataSourceResult extension method processes the data source server-side. To prevent that call the ServerOperation method and pass false as the argument.

Example: Perform Paging, Sorting, Filtering and Grouping In Memory

 // -- removed for brevity
 .DataSource(dataSource => dataSource.Ajax()
    .ServerOperation(false)
 // -- removed for brevity
"

are the options?

Madhu Sudhanan P [Syncfusion]
Replied On February 26, 2014 06:48 AM UTC

Hi Andrey,

 

Currently ASP.Net MVC Grid don’t have support for doing paging, filtering and grouping operation without sending AJAX request.

 

We suggest you to use our Essential JavaScript Studio which have complete client-side support including this feature. The request feature can be achieved in ejGrid by the setting offline as true in DataManager.

 

 

<div id="Grid"></div>

var dataManger = ej.DataManager({

                url: "http://mvc.syncfusion.com/Services/Northwnd.svc/Orders",

                offline:true,

            });

 

$("#Grid").ejGrid({

                    dataSource: dataManger,

                    . . . .

});

 

 

When setting offline as true in DataManager, the complete data will be requested from the database only once using Ajax request and further actions such as Filtering, Paging and Grouping will be handled by the client side itself.

 

The product details can be found in the following pages

Products page:

http://www.syncfusion.com/products/javascript

http://www.syncfusion.com/products/javascript/grid

 

Online Sample browser:

http://js.syncfusion.com/demos/

http://js.syncfusion.com/demos/#!/azure/grid  

 

User Guide:

http://help.syncfusion.com/js

 

For your convenience we have created a simple sample and please find the attached sample.

 

Please let us know if you have any queries.

 

Regards,

Madhu Sudhanan. P


Attachment: sample_f87d9f91.zip

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

;