Windows Forms PivotGrid Control

Create interactive user interface of Pivot table, build summarizations and highlight specific data

Home > WinForms UI Controls > User Manual > ADO.MDB Data Provider for PivotGrid in C#

C# Populate KetticPivotGrid with Data using AdomdDataProvider

KetticPivotGrid control allows the users to populate this control with data from OLAP Cube and it uses the AdomdDataProvider to import data from OLAP Cube. The KetticPivotGrid control supports Microsoft.AnalysisServices.AdomdClient and we need to install an Adomd client on our computer to use the AdomdDataProvider. In this tutorial, we shall go through the procedures of using the AdomdDataProvider to bind KetticPivotGrid to data in C#.NET.

Key Properties of AdomdDataProvider for PivotGrid

When we want to get data from OLAP Cube, we shall define the significant properties of AdomdDataProvider as below.

ConnectionSettings, this property is used to set the connection between the KetticPivotGrid control and the data from OLAP Cube. It has a few string properties for connecting to OLAP Cube, such as Cube, Database, and ConnectionString. The Cube string property defines the exact name of the Cube, the Database string property defines the exact name of the Database, and the ConnectionString property is used to open a database.
AggregatesLevel, this property is used to specify the position to place the aggregated groups.
AggregatesPosition, this property is used to set the either the Columns or Rows as the position of the Aggregates

Define AdomdDataProvider and Connect to OLAP Cube

In order to display data in KetticPivotGrid and KetticPivotFieldList, the users of the control need to connect the KetticPivotGrid to OLAP Cube. The C# code below demonstrates how to modify the ConnectionSettings property of the AdomdDataProvider to connect to OLAP Cube in .NET applications.


AdomdDataProvider provider = new AdomdDataProvider();
AdomdConnectionSettings settings = new AdomdConnectionSettings();

settings.Cube = "Adventure Works";
settings.Database = "Adventure Works DW 2008R2";
settings.ConnectionString = "Data Source";

provider.ConnectionSettings = settings;

Define Group Descriptions in AdomdDataProvider for PivotGrid

KetticPivotGrid control contains three different description collections to store data for the AdomdDataProvider to display in KetticPivotGrid and KetticPivotFieldList, including RowGroupDescription, ColumnGroupDescription, and AggregateDescriptions collections.

RowGroupDescriptions collection, this row description collection stores the data that will be shown as row headers of KetticPivotGrid. We can set the AdomdGroupDescription to this row description collection.
ColumnGroupDescriptions collection, this column description collection stores the data that will be shown as column headers of KetticPivotGrid. We can set the AdomdGroupDescription to this row description collection
AggregateDescriptions collection, this aggregates description collection stores the data that will be aggregated and included in the cells in KetticPivotGrid. We can set the AdomdAggregateDescription to this aggregates description collection.

The AdomdGroupDescription defines the data displaying in Rows and Columns in KetticPivotGrid. The AdomdGroupDescription contains the MemberName property for the users to set the string according to the OLAP Cube.

The AdomdAggregateDescription defines the data aggregated and displayed in cells in KetticPivotGrid. The AdomdAggregateDescription contains the MemberName property for the users to set the data that will be aggregated.

UI Controlsfor Windows Forms

.NET WinForms UI Overview .NET WinForms UI Features .NET WinForms UI Guide C# WinForms UI Design VB.NET WinForms UI Design

WinForms UI Controls