■ PivotGridControl 클래스에서 셀 값 포맷을 설정하는 방법을 보여준다.
▶ 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 25 26 27 28 29 30 31 32 33 34 35 36 |
<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="PivotGridControl 클래스 : 셀 값 포맷 설정하기" FontFamily="나눔고딕코딩" FontSize="16" Loaded="Window_Loaded"> <Grid> <dxpg:PivotGridControl x:Name="pivotGridControl"> <dxpg:PivotGridControl.Fields> <dxpg:PivotGridField x:Name="yearPivotGridField" FieldName="OrderDate" Area="ColumnArea" GroupInterval="DateYear" Caption="Year" /> <dxpg:PivotGridField x:Name="productNamePivotGridField" FieldName="ProductName" Area="RowArea" Caption="Product Name" /> <dxpg:PivotGridField x:Name="extendedPricePivotGridField" FieldName="Extended Price" Area="DataArea" GrandTotalCellFormat="c0" /> <dxpg:PivotGridField x:Name="quantityPivotGridField" FieldName="Quantity" Area="DataArea" CellFormat="({0})" /> </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 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 |
using System.Windows; using TestProject.NorthwindDataSetTableAdapters; namespace TestProject { /// <summary> /// 메인 윈도우 /// </summary> public partial class MainWindow : Window { //////////////////////////////////////////////////////////////////////////////////////////////////// Field ////////////////////////////////////////////////////////////////////////////////////////// Private #region Field /// <summary> /// Sales Person 데이터 테이블 /// </summary> private NorthwindDataSet.SalesPersonDataTable salesPersonDataTable = new NorthwindDataSet.SalesPersonDataTable(); /// <summary> /// Sales Person 테이블 어밷터 /// </summary> private SalesPersonTableAdapter salesPersonTableAdapter = new SalesPersonTableAdapter(); #endregion //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor ////////////////////////////////////////////////////////////////////////////////////////// Public #region 생성자 - MainWindow() /// <summary> /// 생성자 /// </summary> public MainWindow() { InitializeComponent(); this.pivotGridControl.DataSource = this.salesPersonDataTable; } #endregion //////////////////////////////////////////////////////////////////////////////////////////////////// Method ////////////////////////////////////////////////////////////////////////////////////////// Private //////////////////////////////////////////////////////////////////////////////// Event #region 윈도우 로드시 처리하기 - Window_Loaded(sender, e) /// <summary> /// 윈도우 로드시 처리하기 /// </summary> /// <param name="sender">이벤트 발생자</param> /// <param name="e">이벤트 인자</param> private void Window_Loaded(object sender, RoutedEventArgs e) { this.salesPersonTableAdapter.Fill(this.salesPersonDataTable); } #endregion } } |
