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

pivot grid with local data binding


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


7 Replies

AD Alagarsamy D Syncfusion Team 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.

MA Manolo August 10, 2015 07:18 AM UTC

Please, can you create a sample?

Thank you

NM Narendhran M Syncfusion Team 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.

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

RG Ramesh Govindaraj Syncfusion Team 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.

MA Manolo September 2, 2015 03:29 PM UTC

Ok, Thanks

RG Ramesh Govindaraj Syncfusion Team September 3, 2015 11:12 AM UTC

Hi Manolo,

Thanks for the update.

Please let us know if you have any query.

Ramesh G.

Live Chat Icon For mobile
Up arrow icon