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
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?

Platform: ASP.NET MVC |
Control: Grid

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

2X faster development

The ultimate ASP.NET MVC UI toolkit to boost your development speed.
You must log in to leave a comment
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? Reply
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 Reply

Please sign in to access our KB

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

Up arrow icon

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

Live Chat Icon For mobile