PivotGrid Data Binding at Design Time in C#.NET
KetticPivotGrid control for Windows Forms is capable of standard data binding. When we add the control to the Windows Forms, we can bind KetticPivotGrid to a new data source or an existing one through the DataSource property. The DataSource property is available in the Smart Tag menu in the Properties window of the KetticPivotGrid control. In this article, we are going through the features of binding KetticPivotGrid control to data at design time.
Aggregate Descriptor Collections and Group Descriptors Collections
KetticPivotGrid control for Windows Forms contains ColumnGroupDescriptions collection, RowGroupDescriptions collection, and AggregateDescriptions collection. By using these collections, the users can display the data in KetticPivotGrid according to specific requirements. The following are the steps show how to add these collections to KetticPivotGrid.
Add Report Filters to KetticPivotGrid Control
Apply Case Scenario to PivotGrid .NET Project
In the following sample, we bind the KetticPivotGrid control to a database scenario, a Northwind database, included in the control package. To bind the control to database, we will create a custom table adapter to choose tables like Customers, Product Orders, and Order Descriptions tables to import data that will be shown in KetticPivotGrid. The custom table adapter can be added through choosing Add and then TableAdapter from the context menu in the DataSet designer. Then add the tables to your .NET project via the SELECT command of our custom table adapter. The following steps will demonstrate a statistic of the Orders ordered by the customers and the users can preview the statistics of results filtered by city.
UI Controlsfor Windows Forms.NET WinForms UI Overview.NET WinForms UI Features.NET WinForms UI GuideC# WinForms UI DesignVB.NET WinForms UI Design
WinForms UI Controls