pivot grid with local data binding

[Manolo]

Hi,

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

Thanks

[Alagarsamy D]

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:
http://jsplayground.syncfusion.com/elm3ohwe

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.

Thanks,
Alagarsamy D.

[Manolo]

Please, can you create a sample?

Thank you

[Narendhran M]

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:
http://www.syncfusion.com/downloads/support/directtrac/141759/ze/PivotGrid_SummaryType1745876630

Sample with custom JSON data binding:
http://www.syncfusion.com/downloads/support/forum/119859/PivotGrid_JSONBinding-764314067.zip

Regards,
Narendhran M.

[Manolo]

Hi,

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]

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.

Thanks,
Ramesh G.

[Manolo]

Ok, Thanks

[Ramesh Govindaraj]

 
Hi Manolo,

Thanks for the update.

Please let us know if you have any query.

Regards,
Ramesh G.