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

Use DataTable as DataSource

Thread ID:





104283 Jul 6,2012 04:51 PM UTC Jan 30,2014 04:37 AM UTC WPF 3
Tags: PivotGridControl
Asked On July 6, 2012 04:51 PM UTC


I've tried using PivotGrid with DataTable as DataSource but couldn't get it to work. Can you post example how to do this ?

Sabapathy K  [Syncfusion]
Replied On July 10, 2012 06:16 AM UTC

Hi Bartosz,
Thank you for contacting Syncfusion forum.
We have prepared a simple sample in that datatable is used as datasource of pivotgrid. Please find the sample in attachment. Please let me know, if you have any further queries.


Alexander Heimonen
Replied On January 29, 2014 09:48 AM UTC

The link is not working.

Rubini S [Syncfusion]
Replied On January 30, 2014 04:37 AM UTC

Hi Bartosz,


Sorry for the inconvenience.

The issue “Unable to download the sample updated in this forum”  is due to a technical problem in our files server. We have updated the sample again and now you can download it from the attachment.


1.      We have used SQLCe to connect the database “NorthWind” (Please refer the folder “Data”)

2.      If you face any problem with SQLCe connection, Please Unblock the dll “System.Data.SqlServerCe”exist at the folder “Binaries” inside the solution

Procedure to Unblock:

1.      Open the folder “Binaries”

2.      Right click on the dll “System.Data.SqlServerCe” and go to the option “Properties”

3.      Click on the button “Unblock” which is located at right bottom of Properties Wizard.


Please let us know, if you have any other concerns.






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

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