PivotChart with datatable

[Juan]

Hi, I want bind a PivotChart with a datatable. How can I do it?

Thanks.

[Ramesh Govindaraj]

Hi Juan, 

Thank you for using Syncfusion products. 

We have prepared a PivotChart sample where the datasource bound from database(Northwind.sdf) using LINQ query. Please find the sample in the following link.  

Sample link: http://www.syncfusion.com/downloads/support/forum/127925/ze/PivotChart_datatable-751034260  

Thanks and Regards, 

Ramesh G 

[Juan]

Hi Ramesh,

Thanks for the fast answer. I will review the example.

Thanks and Regards.

[Ramesh Govindaraj]

Hi Juan, 

We will wait until we hear from you. 

Regards,
Ramesh G. 

[Christopher]

So where is the actual code for DataTable only to a PivotChart DataSource, I'm using SyncFusion BI Web 4.6 and that property needs a PivotDataSource and there no help on how to configure that to use a DataTable.  The site I am working on DOES NOT have a WebApi and will not have one, so all of the articles I have came across all eventually uses a WebApi.

[AngelinFaithSheeba PaulvannanRajadurai]

Hi Christopher,

We have prepared a sample to render the pivot component using SQL database. Please find it from below link.

Sample: https://www.syncfusion.com/downloads/support/directtrac/general/ze/ASPNETWebFormsPivotChart1384045444

Kindly refer to the following UG document to render the pivot components using SQL data base.

UG Document: https://help.syncfusion.com/aspnet/pivotchart/relational-getting-started#creating-a-simple-application-with-pivot-chart-and-relational-data-sources-server-mode

Please let us know if you have any concerns.

Regards,

Angelin Faith Sheeba