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

Server-side API for DataManager operations.

Platform: ASP.NET Web Forms |
Control: Grid |
Published Date: March 16, 2015 |
Last Revised Date: October 14, 2015

The DataManager class helps in binding the Grid queries passed to the server-side. Based on those queries you can perform server-side operation on the Grid data.

The query parameters that help you perform the server-side operations are as follows.

Table 1: Query Parameters

Expand

It is used as OData Expand query.

RequiresCounts

When this property is set as True, the total count of records are included in the result.

Skip

Details regarding current page are skipped.

Take

Used to take required records from data manager.

Sorted

Records return the sorted collection.

Table

It is a data source table name.

Where

Records return the filter collection.

DataManager Operations:

The query parameters are serialized by the DataManager class and the server-side operations such as sorting, filtering, paging are performed by the PerformSorting, PerfomWherFilter, PerformSkip and PerformTake methods.

C#

DataOperations Method:

You can also perform the server side operation such as filtering, paging and sorting by using the DataOperations Execute method instead of using the individual methods. The following code example shows you how to use the Execute method in the DataManager.

Table 2: Server side operation order for Execute method

Server side operation Orders

  1. PerformWhereFilter
  1. PerformSearching
  1. PerformSorting
  1. PerformSelect
  1. PerformSkip
  1. PerformTake

C#

MVC

In the following code example is demonstrated the server-side operation using UrlAdaptor.

C#

ASP

In ASP.NET, the server-side operation is performed by using the WebMethodAdaptor, and the DataManager parameter is set as value.

C#

 

2X faster development

The ultimate ASP.NET Web Forms UI toolkit to boost your development speed.
ADD COMMENT
You must log in to leave a comment
Comments
Laurentiu LAZAR
May 26, 2015
Is possible when load the data source for grid, to be empty? (I mean to no display existing records, and only the new added just to moment when the grid is saved? Reply
Not Known
May 26, 2015
Hi Laurentiu, Yes, It’s possible to load the datasource in Grid to be empty. We can bind the empty data source at Grid initial rendering and update the added records to the database using InsertURL to achieve your requirement. Please refer the documentation for UrlAdaptor in following link: http://help.syncfusion.com/ug/js/index.html#!Documents/urladaptor.htm Regards, Balaji Marimuthu
Soycake
May 11, 2016
I use DataManager to query JSON result from DataSource like this: var dm = ej.DataManager("Home/GetOrders").executeQuery(ej.Query().where("OrderID", "equal", 1, true)); There is no results. My JSON result from DataSource action like this: [{"result":[{"ID":2,"OrderID":1,"Country":"USA","City":"Canada"],"count":1}]; But if I assign var jsondata = [{"ID":2,"OrderID":1,"Country":"USA","City":"Canada"] and use ejQuery, it return 1 record. Do you have any suggestion to find OrderID from DataSource? Reply

Please sign in to access our KB

This page will automatically be redirected to the 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