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:

 

Queries

Description

Expand

It is an OData Expand query.

RequiresCounts

It is the total count of the records.

Skip

Details regarding current page is skipped.

Take

Used to take the required records from the data manager.

Search

Result to match the specified search expression.

Group

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

Select

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

Sorted

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

Table

It is a DataSource table.

Where

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

The code example for URL DataSource binding in the Grid:

CSHTML

 

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.

MVC

 

DataSource operations

Article ID: Published Date: Last Revised Date: Platform: Control:
4704 04/25/2015 08/07/2015 ASP.NET MVC Grid
Tags:
Did you find this information helpful?
Comments
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
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