|
|
How to create a Pivot Table?
|
Article Information
|
Article relates to VIBlend DataGridView for WinForms
|
How To
|
Create a Pivot Table.
|
Solution
|
To achieve this, follow these steps:
|
1. Create a new instance of the vDataGridView via drag and drop from the toolbox or create it programmatically.
|
2. Bind the grid to the Northwind Invoices table( NWind.mdb is included in the installation of the VIBlend Controls for WinForms installation package). Add “Country” and “City” to the BoundPivotRows collection. In this example, we use “Country” and “City”. Add "Shippers_Company" to the BoundPivotColumns collection. Finally, use the "ExtendedPrice" data field and fill the BoundPivotValues collection.
|
|
|
|
|