WPF & DevExpress GridControl Dynamic Add Columns

c# code로 grid column  생성.

 

 

 

 

 

<Page xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:d="http://schemas.microsoft.com/expression/blend/2008" xmlns:local="clr-namespace:WpfSample.DevTest" xmlns:dxlc="http://schemas.devexpress.com/winfx/2008/xaml/layoutcontrol" xmlns:dx="http://schemas.devexpress.com/winfx/2008/xaml/core" xmlns:Serialization="clr-namespace:DevExpress.Xpf.LayoutControl.Serialization;assembly=DevExpress.Xpf.LayoutControl.v17.2" xmlns:dxe="http://schemas.devexpress.com/winfx/2008/xaml/editors" xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid" x:Class="WpfSample.DevTest.Grid13DynamicAddColumns" mc:Ignorable="d" d:DesignHeight="800" d:DesignWidth="1280" Title="Grid01"> <StackPanel Margin="0,10,10,10"> <dxlc:LayoutControl HorizontalAlignment="Stretch" VerticalAlignment="Stretch" Orientation="Vertical" > <dxlc:LayoutGroup Header="Button" View="GroupBox" HorizontalAlignment="Stretch" > <dx:SimpleButton x:Name="btnSearch" Content="Search" HorizontalAlignment="Left" Click="Button_Click" /> </dxlc:LayoutGroup> </dxlc:LayoutControl> <dxlc:LayoutControl HorizontalAlignment="Stretch" VerticalAlignment="Stretch" Orientation="Vertical"> <dxlc:LayoutGroup Header="Grid" View="GroupBox" HorizontalAlignment="Stretch" Height="500" > <dxg:GridControl x:Name="gcGrid" SelectionMode="Cell" > <dxg:GridControl.Columns > </dxg:GridControl.Columns> <dxg:GridControl.View> <dxg:TableView x:Name="tvView" AllowScrollAnimation="True" AllowEditing="False" /> </dxg:GridControl.View> </dxg:GridControl> </dxlc:LayoutGroup> </dxlc:LayoutControl> </StackPanel> </Page>

 

 

 

 

 

using System; using System.Collections.Generic; using System.Windows; using System.Windows.Controls; using DevExpress.Xpf.Grid; using BIZ.Common.Dac; namespace WpfSample.DevTest { /// <summary> /// Grid13DynamicAddColumns.xaml에 대한 상호 작용 논리 /// </summary> public partial class Grid13DynamicAddColumns : Page { public Grid13DynamicAddColumns() { InitializeComponent(); //GetBindGrid(); } private void CreateGridColumn() { CreateColumn("SalesOrderID", "SalesOrderID"); CreateColumn("CustomerID", "CustomerID"); CreateColumn("RevisionNumber", "RevisionNumber"); CreateColumn("OrderDate", "OrderDate"); CreateColumn("DueDate", "DueDate"); CreateColumn("ShipDate", "ShipDate"); CreateColumn("Status", "Status"); CreateColumn("OnlineOrderFlag", "OnlineOrderFlag"); CreateColumn("SalesOrderNumber", "SalesOrderNumber"); CreateColumn("PurchaseOrderNumber", "PurchaseOrderNumber"); CreateColumn("AccountNumber", "AccountNumber"); CreateColumn("CustomerID", "CustomerID"); CreateColumn("SalesPersonID", "SalesPersonID"); CreateColumn("TerritoryID", "TerritoryID"); CreateColumn("BillToAddressID", "BillToAddressID"); CreateColumn("ShipToAddressID", "ShipToAddressID"); CreateColumn("ShipMethodID", "ShipMethodID"); CreateColumn("CreditCardID", "CreditCardID"); CreateColumn("CreditCardApprovalCode", "CreditCardApprovalCode"); CreateColumn("CurrencyRateID", "CurrencyRateID"); CreateColumn("SubTotal", "SubTotal"); CreateColumn("TaxAmt", "TaxAmt"); CreateColumn("Freight", "Freight"); CreateColumn("TotalDue", "TotalDue"); CreateColumn("Comment", "Comment"); CreateColumn("ModifiedDate", "ModifiedDate"); } private void GetBindGrid() { Dictionary<string, object> dic = new Dictionary<string, object>(); dic.Add("param1", "111"); var data = (new ADOConnect()).GetDataSet("AdventureWorks2016", "Z_UP_SALES_ORDER2_LIST", dic); CreateGridColumn(); gcGrid.ItemsSource = data.Tables[0]; } private void Button_Click(object sender, RoutedEventArgs e) { GetBindGrid(); } private void CreateColumn(string fieldName, string header) { GridColumn gc = new GridColumn(); gc.FieldName = fieldName; gc.Header = header; gcGrid.Columns.Add(gc); } } }