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.
Unfortunately, activation email could not send to your email. Please try again.

Use DataTable as DataSource

Thread ID:





104283 Jul 6,2012 12:51 PM Jan 29,2014 11:37 PM WPF 3
Tags: PivotGridControl
Asked On July 6, 2012 12:51 PM


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 02:16 AM

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 04:48 AM

The link is not working.

Rubini S [Syncfusion]
Replied On January 29, 2014 11:37 PM

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.

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.