Loading data in Pivot Grid from SQL Table

2 posts, 0 answers
  1. nazeer syed
    nazeer syed avatar
    6 posts
    Member since:
    Sep 2017

    Posted 16 Sep Link to this post

    New to Pivot Grid Want to know how to load data using the Sql Table
  2. Hristo
    Admin
    Hristo avatar
    1019 posts

    Posted 18 Sep Link to this post

    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
    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.
Back to Top