■ PivotGridControl 클래스에서 MDB 데이터베이스에 피벗 그리드를 바인딩하는 방법을 보여준다.
▶ MainWindow.xaml
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 |
<Window x:Class="TestProject.MainWindow" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:dxpg="http://schemas.devexpress.com/winfx/2008/xaml/pivotgrid" Width="800" Height="600" Title="MDB 데이터베이스에 피벗 그리드 바인딩 하기" FontFamily="나눔고딕코딩" FontSize="16"> <Grid> <dxpg:PivotGridControl x:Name="pivotGridControl"> <dxpg:PivotGridControl.Fields> <dxpg:PivotGridField FieldName="Country" Area="RowArea" Caption="Country" /> <dxpg:PivotGridField FieldName="Slaes Person" Area="RowArea" Caption="Sales Person" /> <dxpg:PivotGridField FieldName="CategoryName" Area="ColumnArea" Caption="Product Category" /> <dxpg:PivotGridField FieldName="OrderDate" Area="ColumnArea" Caption="Year" GroupInterval="DateYear" /> <dxpg:PivotGridField FieldName="ProductName" Caption="Product" /> <dxpg:PivotGridField FieldName="Extended Price" Area="DataArea" CellFormat="c0" /> </dxpg:PivotGridControl.Fields> </dxpg:PivotGridControl> </Grid> </Window> |
▶ MainWindow.xaml.cs
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 |
using System.Windows; using TestProject.NorthwindDataSetTableAdapters; namespace TestProject { /// <summary> /// 메인 윈도우 /// </summary> public partial class MainWindow : Window { //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor ////////////////////////////////////////////////////////////////////////////////////////// Public #region 생성자 - MainWindow() /// <summary> /// 생성자 /// </summary> public MainWindow() { InitializeComponent(); SalesPersonTableAdapter salesPersonTableAdapter = new SalesPersonTableAdapter(); this.pivotGridControl.DataSource = salesPersonTableAdapter.GetData(); } #endregion } } |