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 to view and Postback the QueryBuilder String to the Controller?

The DataSource operations can be performed in the Controller side by using the DataManager Query property. The Query property is used to perform the data operation in ActionResult, but to perform the server side data operation, URL Adapter and URL DataSource binding should be used. The following are the DataManager Query properties:





It is an OData Expand query.


It is the total count of the records.


Details regarding current page is skipped.


Used to take the required records from the data manager.


Result to match the specified search expression.


It is used to return the grouped details of the Grid.


Used to select user required properties that are available in the DataSource.


Entries return in the ascending or descending order when the property is sorted.


It is a DataSource table.


It is used to extract only those records that fulfill the specified criteria.

The code example for URL DataSource binding in the Grid:



The following example shows the skip and take operation in the Controller. In this sample, records are taken in the load on demand from data manager and the details regarding the current page is passed by using skip.



DataSource operations

Article ID: Published Date: Last Revised Date: Platform: Control:
4704 04/25/2015 08/07/2015 ASP.NET MVC Grid
Did you find this information helpful?
Scott Morey May 07, 2015
I'm using MVC/Razor. It looks like I'm missing a using statement for DataResult. What reference is is needed for this?
Sellappandi Ramu [Syncfusion] May 11, 2015
Hi Scott Morey, DataResult is one of the class used in controller. Please refer the following code snippet. public class DataResult { public IEnumerable result { get; set; } public int count { get; set; } } We need to return the dataSource and count in server side. So we have used DataResult class to return the both data and count. We can use the DataResult class to return or we can return without DataResult class. Please refer the following code snippet. return Json(new { result = Data, count = Data.Count() }, JsonRequestBehavior.AllowGet); Regards, Sellappandi R
Add Comment
You must log in to leave a comment

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