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

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

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?

1 Reply

MS Madhu Sudhanan P Syncfusion Team 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

Loader.
Live Chat Icon For mobile
Up arrow icon