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

pivot grid with local data binding

Thread ID:





119859 Aug 7,2015 11:49 AM UTC Sep 3,2015 11:12 AM UTC ASP.NET MVC 7
Tags: PivotGrid
Asked On August 7, 2015 11:49 AM UTC


I want test the pivot grid, but I don't know how to do data binding.

In a grid, I've  datasource function, but in the pivot grid not.

In examples, you use wcf for binding, but i don't want use it


Alagarsamy D [Syncfusion]
Replied On August 8, 2015 07:07 AM UTC

Hi Manolo,

Thank you for using Syncfusion products.

Data could be bound to PivotGrid in the form of JSON string. We have created a same sample in the below online link.

Sample Link:

NOTE: If you require a sample with WebAPI controller please let us know so that we will arrange for the same.

Please let us know if you have any concerns.

Alagarsamy D.

Replied On August 10, 2015 07:18 AM UTC

Please, can you create a sample?

Thank you

Narendhran M [Syncfusion]
Replied On August 10, 2015 01:30 PM UTC

Hi Manolo,
We have prepared samples for rendering PivotGrid with both JSON data and WebAPI controller. Please find the samples in the below links.

Sample using WebAPI Controller:

Sample with custom JSON data binding:

Narendhran M.

Replied On August 31, 2015 02:14 PM UTC


I return to test the PivotGrid.

I need get the data from store procedure , (pass the parameters and exec the sp), and show the data in pivotgrid.

In your examples, I need set the Url, but I don't need this, I want set the datasource.

How can I do it?

Ramesh Govindaraj [Syncfusion]
Replied On September 1, 2015 12:30 PM UTC

Hi Manolo,

In general, database is accessed and processed in service side only. Hence URL need to be assigned which is the only option which indicates the service (WCF or WebAPI) end point for our control. We have created a simple PivotGrid sample where SQL table is queried and assigned to the control as ItemSource. Please find the sample link below.  

Sample Link:   http://www.syncfusion.com/downloads/support/forum/119859/ze/SyncfusionMvcApplication15_(3)-1705608531

Please let us know if you require any further assistance on this.

Ramesh G.

Replied On September 2, 2015 03:29 PM UTC

Ok, Thanks

Ramesh Govindaraj [Syncfusion]
Replied On September 3, 2015 11:12 AM UTC

Hi Manolo,

Thanks for the update.

Please let us know if you have any query.

Ramesh G.


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

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