Use DataTable as DataSource

Question

Hi,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 · Answer

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.
 
Regards,
Sabapathy.KDataTable_Sample_2e265634.zip

Alexander Heimonen · Answer

The link is not working.

Rubini S · Answer

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.

Note: 

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.

 

Regards,

Rubini

DataSet_Support_31b9629d.zip