■ DataGridControl 엘리먼트를 사용하는 방법을 보여준다.
▶ 어셈블리 참조
|
1 2 3 4 5 6 7 |
Xceed Controls for WPF Xceed DataGrid for WPF Xceed DataGrid for WPF 3D Views Xceed DataGrid for WPF Theme Pack #1 Xceed DataGrid for WPF Theme Pack #2 |
▶ MainApplication.Xaml
|
1 2 3 4 5 6 7 8 |
<Application x:Class="TestProject.MainApplication" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" StartupUri="MainWindow.xaml"> </Application> |
▶ MainApplication.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 67 68 69 70 71 72 73 74 75 76 |
using System; using System.Data; using System.Data.OleDb; using System.Windows; namespace TestProject { /// <summary> /// 메인 애플리케이션 /// </summary> public partial class MainApplication : Application { //////////////////////////////////////////////////////////////////////////////////////////////////// Field ////////////////////////////////////////////////////////////////////////////////////////// Static //////////////////////////////////////////////////////////////////////////////// Private #region Field /// <summary> /// 주문 테이블 /// </summary> private static DataTable _orderTable; #endregion //////////////////////////////////////////////////////////////////////////////////////////////////// Property ////////////////////////////////////////////////////////////////////////////////////////// Static //////////////////////////////////////////////////////////////////////////////// Public #region 주문 테이블 - OrderTable /// <summary> /// 주문 테이블 /// </summary> public static DataTable OrderTable { get { return _orderTable; } } #endregion //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor ////////////////////////////////////////////////////////////////////////////////////////// Static #region 생성자 - MainApplication() /// <summary> /// 생성자 /// </summary> static MainApplication() { DataSet dataSet = new DataSet(); string filePath = @"C:\DS.Core\DS.Test.SampleDatabase\nwind.mdb"; //string connectionString = String.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0}", filePath); // MS Office 2007 버전 이후 string connectionString = String.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0}" , filePath); // MS Office 2003 버전 OleDbConnection oleDbConnection = new OleDbConnection(connectionString); OleDbDataAdapter oleDbDataAdapter = new OleDbDataAdapter(); oleDbDataAdapter.SelectCommand = new OleDbCommand("SELECT * FROM Orders;", oleDbConnection); oleDbDataAdapter.Fill(dataSet, "Order"); _orderTable = dataSet.Tables["Order"]; } #endregion } } |
▶ 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 |
<Window x:Class="TestProject.MainWindow" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:xcdg="http://schemas.xceed.com/wpf/xaml/datagrid" Width="800" Height="600" Title="XCEED 그리드 사용하기"> <Grid xmlns:xcdg="http://schemas.xceed.com/wpf/xaml/datagrid"> <Grid.Resources> <xcdg:DataGridCollectionViewSource x:Key="DataGridCollectionViewSourceKey" Source="{Binding Source={x:Static Application.Current}, Path=Orders}" /> </Grid.Resources> <xcdg:DataGridControl x:Name="dataGridControl" ItemsSource="{Binding Source={StaticResource DataGridCollectionViewSourceKey}}"> </xcdg:DataGridControl> </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 |
using System.Windows; using Xceed.Wpf.DataGrid; namespace TestProject { /// <summary> /// 메인 윈도우 /// </summary> public partial class MainWindow : Window { //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor ////////////////////////////////////////////////////////////////////////////////////////// Public #region 생성자 - MainWindow() /// <summary> /// 생성자 /// </summary> public MainWindow() { InitializeComponent(); this.dataGridControl.ItemsSource = new DataGridCollectionView(MainApplication.OrderTable.DefaultView ); } #endregion } } |