nazeer syed
Top achievements
Rank 1
Rank 1
nazeer syed
asked on 16 Sep 2017, 02:26 PM
New to Pivot Grid Want to know how to load data using the Sql Table
1 Answer, 1 is accepted
0
Hello Nazeer,
Thank you for writing.
You can follow various approaches to connect to your SQL server instance and fetch the data from it locally. Then you can bind the pivot`s data provider to a DataTable or even the entire DataSet. RadPivotGrid also supports the IQueryable interface so if needed you can also use EntityFramework the QueryableDataProvider.
Please check the following section of the documentation providing detailed information and examples: http://docs.telerik.com/devtools/winforms/pivotgrid/populating-with-data/design-time-data-binding.
I hope this helps. Should you have further questions please do not hesitate to write back.
Regards,
Hristo
Progress Telerik
Thank you for writing.
You can follow various approaches to connect to your SQL server instance and fetch the data from it locally. Then you can bind the pivot`s data provider to a DataTable or even the entire DataSet. RadPivotGrid also supports the IQueryable interface so if needed you can also use EntityFramework the QueryableDataProvider.
Please check the following section of the documentation providing detailed information and examples: http://docs.telerik.com/devtools/winforms/pivotgrid/populating-with-data/design-time-data-binding.
I hope this helps. Should you have further questions please do not hesitate to write back.
Regards,
Hristo
Progress Telerik
Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.