GRID Archives - 18 중 2 번째 페이지

[C#/WINFORM/DEVEXPRESS] CardView 클래스 : CustomDrawCardCaption 이벤트를 사용해 카드 제목 커스텀 그리기

■ CardView 클래스의 CustomDrawCardCaption 이벤트를 사용해 카드 제목을 커스텀 그리는 방법을 보여준다. ▶ MainForm.cs


using System.Drawing;
using System.Drawing.Drawing2D;

using DevExpress.XtraEditors;
using DevExpress.XtraGrid.Views.Card;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            this.cardView.OptionsBehavior.AutoPopulateColumns = true;

            this.gridControl.DataSource = new nwindDataSetTableAdapters.ProductsTableAdapter().GetData();

            this.cardView.CustomDrawCardCaption += cardView_CustomDrawCardCaption;
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region 카드 뷰 카드 제목 커스텀 그리기 - cardView_CustomDrawCardCaption(sender, e)

        /// <summary>
        /// 카드 뷰 카드 제목 커스텀 그리기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void cardView_CustomDrawCardCaption(object sender, CardCaptionCustomDrawEventArgs e)
        {
            CardView cardView = sender as CardView;

            bool isFocused = e.RowHandle == cardView.FocusedRowHandle;

            Brush backgroundBrush;
            Brush foregroundBrush;

            Color color1 = Color.FromArgb(142, 57 , 80);
            Color color2 = Color.FromArgb(240, 140, 40);
            Color color3 = Color.FromArgb(70 , 55 , 94);
            Color color4 = Color.FromArgb(144, 84 , 84);

            if(isFocused)
            {
                backgroundBrush = e.Cache.GetGradientBrush(e.Bounds, color1, color2, LinearGradientMode.ForwardDiagonal);
                foregroundBrush = Brushes.White;
            }
            else
            {
                backgroundBrush = e.Cache.GetGradientBrush(e.Bounds, color3, color4, LinearGradientMode.ForwardDiagonal);
                foregroundBrush = Brushes.Coral;
            }

            Rectangle rectangle = e.Bounds;

            rectangle.Inflate(1, 0);

            e.Cache.FillRectangle(backgroundBrush, rectangle);

            e.Appearance.DrawString(e.Cache, cardView.GetCardCaption(e.RowHandle),rectangle, foregroundBrush);

            e.Handled = true;
        }

        #endregion
    }
}

using System.Drawing;

using System.Drawing.Drawing2D;

using DevExpress.XtraEditors;

using DevExpress.XtraGrid.Views.Card;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

this.cardView.OptionsBehavior.AutoPopulateColumns = true;

this.gridControl.DataSource = new nwindDataSetTableAdapters.ProductsTableAdapter().GetData();

this.cardView.CustomDrawCardCaption += cardView_CustomDrawCardCaption;

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Private

#region 카드 뷰 카드 제목 커스텀 그리기 - cardView_CustomDrawCardCaption(sender, e)

/// <summary>

/// 카드 뷰 카드 제목 커스텀 그리기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void cardView_CustomDrawCardCaption(object sender, CardCaptionCustomDrawEventArgs e)

{

CardView cardView = sender as CardView;

bool isFocused = e.RowHandle == cardView.FocusedRowHandle;

Brush backgroundBrush;

Brush foregroundBrush;

Color color1 = Color.FromArgb(142, 57 , 80);

Color color2 = Color.FromArgb(240, 140, 40);

Color color3 = Color.FromArgb(70 , 55 , 94);

Color color4 = Color.FromArgb(144, 84 , 84);

if(isFocused)

{

backgroundBrush = e.Cache.GetGradientBrush(e.Bounds, color1, color2, LinearGradientMode.ForwardDiagonal);

foregroundBrush = Brushes.White;

}

else

{

backgroundBrush = e.Cache.GetGradientBrush(e.Bounds, color3, color4, LinearGradientMode.ForwardDiagonal);

foregroundBrush = Brushes.Coral;

}

Rectangle rectangle = e.Bounds;

rectangle.Inflate(1, 0);

e.Cache.FillRectangle(backgroundBrush, rectangle);

e.Appearance.DrawString(e.Cache, cardView.GetCardCaption(e.RowHandle),rectangle, foregroundBrush);

e.Handled = true;

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] GridView 클래스 : MouseWheel 이벤트를 사용해 수평 스크롤 하기

■ GridView 클래스의 MouseWheel 이벤트를 사용해 수평 스크롤하는 방법을 보여준다. ▶ MainForm.cs


using System.Windows.Forms;

using DevExpress.Utils;
using DevExpress.XtraEditors;
using DevExpress.XtraGrid.Views.Grid;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            this.gridView.InitializeView
            (
                true,                           // Multi Select
                GridMultiSelectMode.CellSelect, // Grid Multi Select Mode
                DrawFocusRectStyle.CellFocus,   // Draw Focus Rect Style
                true,                           // Show Indicator
                true,                           // Show Column Headers
                true,                           // Allow Column Moving
                true,                           // Allow Column Resizing
                true,                           // Allow Filter
                true,                           // Allow Sort
                false,                          // Allow Cell Merge
                EditorShowMode.Default,         // Editor Show Mode
                false                           // Editable
            );

            this.gridView.OptionsBehavior.AutoPopulateColumns = true;

            this.gridControl.DataSource = new nwindDataSetTableAdapters.ProductsTableAdapter().GetData();

            this.gridView.BestFitColumns();

            this.gridView.MouseWheel += gridView_MouseWheel;
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region 그리드 뷰 마우스 WHEEL 처리하기 - gridView_MouseWheel(sender, e)

        /// <summary>
        /// 그리드 뷰 마우스 WHEEL 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void gridView_MouseWheel(object sender, MouseEventArgs e)
        {
            GridView gridView = (sender as GridView);

            if(Control.ModifierKeys == Keys.Control)
            {
                gridView.LeftCoord += e.Delta;

                (e as DXMouseEventArgs).Handled = true;
            }
        }

        #endregion
    }
}

using System.Windows.Forms;

using DevExpress.Utils;

using DevExpress.XtraEditors;

using DevExpress.XtraGrid.Views.Grid;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

this.gridView.InitializeView

(

true, // Multi Select

GridMultiSelectMode.CellSelect, // Grid Multi Select Mode

DrawFocusRectStyle.CellFocus, // Draw Focus Rect Style

true, // Show Indicator

true, // Show Column Headers

true, // Allow Column Moving

true, // Allow Column Resizing

true, // Allow Filter

true, // Allow Sort

false, // Allow Cell Merge

EditorShowMode.Default, // Editor Show Mode

false // Editable

);

this.gridView.OptionsBehavior.AutoPopulateColumns = true;

this.gridControl.DataSource = new nwindDataSetTableAdapters.ProductsTableAdapter().GetData();

this.gridView.BestFitColumns();

this.gridView.MouseWheel += gridView_MouseWheel;

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Private

#region 그리드 뷰 마우스 WHEEL 처리하기 - gridView_MouseWheel(sender, e)

/// <summary>

/// 그리드 뷰 마우스 WHEEL 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void gridView_MouseWheel(object sender, MouseEventArgs e)

{

GridView gridView = (sender as GridView);

if(Control.ModifierKeys == Keys.Control)

{

gridView.LeftCoord += e.Delta;

(e as DXMouseEventArgs).Handled = true;

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] GridView 클래스 : GetSelectedRows 메소드를 사용해 선택 행 설정하기

■ GridView 클래스의 GetSelectedRows 메소드를 사용해 선택 행을 설정하는 방법을 보여준다. ▶ MainForm.cs


using System;
using System.Collections;
using System.Data;

using DevExpress.Utils;
using DevExpress.XtraEditors;
using DevExpress.XtraGrid.Views.Grid;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            this.gridView.InitializeView
            (
                true,                           // Multi Select
                GridMultiSelectMode.CellSelect, // Grid Multi Select Mode
                DrawFocusRectStyle.CellFocus,   // Draw Focus Rect Style
                true,                           // Show Indicator
                true,                           // Show Column Headers
                true,                           // Allow Column Moving
                true,                           // Allow Column Resizing
                true,                           // Allow Filter
                true,                           // Allow Sort
                false,                          // Allow Cell Merge
                EditorShowMode.Default,         // Editor Show Mode
                false                           // Editable
            );

            this.gridView.OptionsBehavior.AutoPopulateColumns = true;

            this.gridControl.DataSource = new nwindDataSetTableAdapters.ProductsTableAdapter().GetData();

            this.gridView.BestFitColumns();

            this.executeButton.Click += executeButton_Click;
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region 실행하기 버튼 클릭시 처리하기 - executeButton_Click(sender, e)

        /// <summary>
        /// 실행하기 버튼 클릭시 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void executeButton_Click(object sender, EventArgs e)
        {
            ArrayList arrayList = new ArrayList();

            int[] selectedRowHandleArray = this.gridView.GetSelectedRows();

            for(int i = 0; i < selectedRowHandleArray.Length; i++)
            {
                int selectedRowHandle = selectedRowHandleArray[i];

                if(selectedRowHandle >= 0)
                {
                    arrayList.Add(this.gridView.GetDataRow(selectedRowHandle));
                }
            }

            try
            {
                this.gridView.BeginUpdate();

                for(int i = 0; i < arrayList.Count; i++)
                {
                    DataRow row = arrayList[i] as DataRow;

                    row["Discontinued"] = !(bool)row["Discontinued"];
                }
            }
            finally
            {
                this.gridView.EndUpdate();
            }
        }

        #endregion
    }
}

100

101

102

using System;

using System.Collections;

using System.Data;

using DevExpress.Utils;

using DevExpress.XtraEditors;

using DevExpress.XtraGrid.Views.Grid;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

this.gridView.InitializeView

(

true, // Multi Select

GridMultiSelectMode.CellSelect, // Grid Multi Select Mode

DrawFocusRectStyle.CellFocus, // Draw Focus Rect Style

true, // Show Indicator

true, // Show Column Headers

true, // Allow Column Moving

true, // Allow Column Resizing

true, // Allow Filter

true, // Allow Sort

false, // Allow Cell Merge

EditorShowMode.Default, // Editor Show Mode

false // Editable

);

this.gridView.OptionsBehavior.AutoPopulateColumns = true;

this.gridControl.DataSource = new nwindDataSetTableAdapters.ProductsTableAdapter().GetData();

this.gridView.BestFitColumns();

this.executeButton.Click += executeButton_Click;

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Private

#region 실행하기 버튼 클릭시 처리하기 - executeButton_Click(sender, e)

/// <summary>

/// 실행하기 버튼 클릭시 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void executeButton_Click(object sender, EventArgs e)

{

ArrayList arrayList = new ArrayList();

int[] selectedRowHandleArray = this.gridView.GetSelectedRows();

for(int i = 0; i < selectedRowHandleArray.Length; i++)

{

int selectedRowHandle = selectedRowHandleArray[i];

if(selectedRowHandle >= 0)

{

arrayList.Add(this.gridView.GetDataRow(selectedRowHandle));

}

try

{

this.gridView.BeginUpdate();

for(int i = 0; i < arrayList.Count; i++)

{

DataRow row = arrayList[i] as DataRow;

row["Discontinued"] = !(bool)row["Discontinued"];

}

finally

{

this.gridView.EndUpdate();

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] GridControl 클래스 : EmbeddedNavigator 속성을 사용해 특정 버튼 숨기기

■ GridControl 클래스의 EmbeddedNavigator 속성을 사용해 특정 버튼을 숨기는 방법을 보여준다. ▶ MainForm.cs


using DevExpress.Utils;
using DevExpress.XtraEditors;
using DevExpress.XtraGrid.Views.Grid;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            this.gridView.InitializeView
            (
                false,                          // Multi Select
                GridMultiSelectMode.CellSelect, // Grid Multi Select Mode
                DrawFocusRectStyle.CellFocus,   // Draw Focus Rect Style
                true,                           // Show Indicator
                true,                           // Show Column Headers
                true,                           // Allow Column Moving
                true,                           // Allow Column Resizing
                true,                           // Allow Filter
                true,                           // Allow Sort
                false,                          // Allow Cell Merge
                EditorShowMode.Default,         // Editor Show Mode
                true                            // Editable
            );

            this.gridView.OptionsBehavior.AutoPopulateColumns = true;

            this.gridControl.UseEmbeddedNavigator = true;

            ControlNavigator navigator = this.gridControl.EmbeddedNavigator;

            navigator.Buttons.BeginUpdate();

            try
            {
                navigator.Buttons.Append.Visible = false;
                navigator.Buttons.Remove.Visible = false;
            }
            finally
            {
                navigator.Buttons.EndUpdate();
            }

            this.gridControl.DataSource = new nwindDataSetTableAdapters.CustomersTableAdapter().GetData();

            this.gridView.BestFitColumns();
        }

        #endregion
    }
}

using DevExpress.Utils;

using DevExpress.XtraEditors;

using DevExpress.XtraGrid.Views.Grid;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

this.gridView.InitializeView

(

false, // Multi Select

GridMultiSelectMode.CellSelect, // Grid Multi Select Mode

DrawFocusRectStyle.CellFocus, // Draw Focus Rect Style

true, // Show Indicator

true, // Show Column Headers

true, // Allow Column Moving

true, // Allow Column Resizing

true, // Allow Filter

true, // Allow Sort

false, // Allow Cell Merge

EditorShowMode.Default, // Editor Show Mode

true // Editable

);

this.gridView.OptionsBehavior.AutoPopulateColumns = true;

this.gridControl.UseEmbeddedNavigator = true;

ControlNavigator navigator = this.gridControl.EmbeddedNavigator;

navigator.Buttons.BeginUpdate();

try

{

navigator.Buttons.Append.Visible = false;

navigator.Buttons.Remove.Visible = false;

}

finally

{

navigator.Buttons.EndUpdate();

}

this.gridControl.DataSource = new nwindDataSetTableAdapters.CustomersTableAdapter().GetData();

this.gridView.BestFitColumns();

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] GridView 클래스 : GetRowExpanded/SetRowExpanded 메소드를 사용해 행 확장/축소하기

■ GridView 클래스의 GetRowExpanded/SetRowExpanded 메소드를 사용해 행을 확장/축소하는 방법을 보여준다. ▶ MainForm.cs


using DevExpress.Utils;
using DevExpress.XtraEditors;
using DevExpress.XtraGrid.Views.Base;
using DevExpress.XtraGrid.Views.Grid;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            this.gridView.InitializeView
            (
                false,                          // Multi Select
                GridMultiSelectMode.CellSelect, // Grid Multi Select Mode
                DrawFocusRectStyle.CellFocus,   // Draw Focus Rect Style
                true,                           // Show Indicator
                true,                           // Show Column Headers
                true,                           // Allow Column Moving
                true,                           // Allow Column Resizing
                true,                           // Allow Filter
                true,                           // Allow Sort
                false,                          // Allow Cell Merge
                EditorShowMode.Default,         // Editor Show Mode
                false                           // Editable
            );

            this.gridView.OptionsBehavior.AutoPopulateColumns = true;

            this.gridView.OptionsView.ShowGroupPanel = true;

            this.gridView.OptionsView.ShowGroupedColumns = true;

            this.gridView.FocusedRowChanged += gridView_FocusedRowChanged;

            this.gridControl.DataSource = new nwindDataSetTableAdapters.CustomersTableAdapter().GetData();

            this.gridView.Columns["Country"].GroupIndex = 0;

            this.gridView.BestFitColumns();
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region 그리드 뷰 포커스 행 변경시 처리하기 - gridView_FocusedRowChanged(sender, e)

        /// <summary>
        /// 그리드 뷰 포커스 행 변경시 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void gridView_FocusedRowChanged(object sender, FocusedRowChangedEventArgs e)
        {
            GridView gridView = sender as GridView;

            if(gridView.IsGroupRow(e.FocusedRowHandle))
            {
                bool expanded = gridView.GetRowExpanded(e.FocusedRowHandle);

                gridView.SetRowExpanded(e.FocusedRowHandle, !expanded);
            }
        }

        #endregion
    }
}

using DevExpress.Utils;

using DevExpress.XtraEditors;

using DevExpress.XtraGrid.Views.Base;

using DevExpress.XtraGrid.Views.Grid;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

this.gridView.InitializeView

(

false, // Multi Select

GridMultiSelectMode.CellSelect, // Grid Multi Select Mode

DrawFocusRectStyle.CellFocus, // Draw Focus Rect Style

true, // Show Indicator

true, // Show Column Headers

true, // Allow Column Moving

true, // Allow Column Resizing

true, // Allow Filter

true, // Allow Sort

false, // Allow Cell Merge

EditorShowMode.Default, // Editor Show Mode

false // Editable

);

this.gridView.OptionsBehavior.AutoPopulateColumns = true;

this.gridView.OptionsView.ShowGroupPanel = true;

this.gridView.OptionsView.ShowGroupedColumns = true;

this.gridView.FocusedRowChanged += gridView_FocusedRowChanged;

this.gridControl.DataSource = new nwindDataSetTableAdapters.CustomersTableAdapter().GetData();

this.gridView.Columns["Country"].GroupIndex = 0;

this.gridView.BestFitColumns();

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Private

#region 그리드 뷰 포커스 행 변경시 처리하기 - gridView_FocusedRowChanged(sender, e)

/// <summary>

/// 그리드 뷰 포커스 행 변경시 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void gridView_FocusedRowChanged(object sender, FocusedRowChangedEventArgs e)

{

GridView gridView = sender as GridView;

if(gridView.IsGroupRow(e.FocusedRowHandle))

{

bool expanded = gridView.GetRowExpanded(e.FocusedRowHandle);

gridView.SetRowExpanded(e.FocusedRowHandle, !expanded);

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] GridView 클래스 : DragObjectOver 이벤트를 사용해 컬럼 헤더 이동 제한하기

■ GridView 클래스의 DragObjectOver 이벤트를 사용해 컬럼 헤더 이동을 제한하는 방법을 보여준다. ▶ MainForm.cs


using System.Data.OleDb;

using DevExpress.Utils;
using DevExpress.XtraEditors;
using DevExpress.XtraGrid.Columns;
using DevExpress.XtraGrid.Views.Base;
using DevExpress.XtraGrid.Views.Grid;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Field
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region Field

        /// <summary>
        /// 연결
        /// </summary>
        private OleDbConnection connection;

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            this.connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb");

            this.gridView.InitializeView
            (
                true,                           // Multi Select
                GridMultiSelectMode.CellSelect, // Grid Multi Select Mode
                DrawFocusRectStyle.CellFocus,   // Draw Focus Rect Style
                true,                           // Show Indicator
                true,                           // Show Column Headers
                true,                           // Allow Column Moving
                true,                           // Allow Column Resizing
                true,                           // Allow Filter
                true,                           // Allow Sort
                false,                          // Allow Cell Merge
                EditorShowMode.Default,         // Editor Show Mode
                false                           // Editable
            );

            this.gridView.OptionsBehavior.AutoPopulateColumns = true;

            this.gridControl.DataSource = Order.GetOrderList(this.connection);

            this.gridView.BestFitColumns();

            this.gridView.DragObjectOver += gridView_DragObjectOver;
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region 그리드 뷰 객체 드래그 오버 처리하기 - gridView_DragObjectOver(sender, e)

        /// <summary>
        /// 그리드 뷰 객체 드래그 오버 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void gridView_DragObjectOver(object sender, DragObjectOverEventArgs e)
        {
            GridColumn column = e.DragObject as GridColumn;

            if(column != null)
            {
                if(column.FieldName == "CustomerID" && e.DropInfo.Index == 0)
                {
                    e.DropInfo.Valid = false;
                }
            }
        }

        #endregion
    }
}

using System.Data.OleDb;

using DevExpress.Utils;

using DevExpress.XtraEditors;

using DevExpress.XtraGrid.Columns;

using DevExpress.XtraGrid.Views.Base;

using DevExpress.XtraGrid.Views.Grid;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Field

////////////////////////////////////////////////////////////////////////////////////////// Private

#region Field

/// <summary>

/// 연결

/// </summary>

private OleDbConnection connection;

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

this.connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb");

this.gridView.InitializeView

(

true, // Multi Select

GridMultiSelectMode.CellSelect, // Grid Multi Select Mode

DrawFocusRectStyle.CellFocus, // Draw Focus Rect Style

true, // Show Indicator

true, // Show Column Headers

true, // Allow Column Moving

true, // Allow Column Resizing

true, // Allow Filter

true, // Allow Sort

false, // Allow Cell Merge

EditorShowMode.Default, // Editor Show Mode

false // Editable

);

this.gridView.OptionsBehavior.AutoPopulateColumns = true;

this.gridControl.DataSource = Order.GetOrderList(this.connection);

this.gridView.BestFitColumns();

this.gridView.DragObjectOver += gridView_DragObjectOver;

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Private

#region 그리드 뷰 객체 드래그 오버 처리하기 - gridView_DragObjectOver(sender, e)

/// <summary>

/// 그리드 뷰 객체 드래그 오버 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void gridView_DragObjectOver(object sender, DragObjectOverEventArgs e)

{

GridColumn column = e.DragObject as GridColumn;

if(column != null)

{

if(column.FieldName == "CustomerID" && e.DropInfo.Index == 0)

{

e.DropInfo.Valid = false;

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] CardView 클래스 : 상세 뷰 사이의 카드 드래그(DRAG) 사용하기

■ CardView 클래스에서 상세 뷰 사이의 카드 드래그(DRAG)를 사용하는 방법을 보여준다. ▶ MainForm.cs


using System;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Windows.Forms;

using DevExpress.Utils;
using DevExpress.XtraEditors;
using DevExpress.XtraEditors.Controls;
using DevExpress.XtraEditors.Repository;
using DevExpress.XtraGrid;
using DevExpress.XtraGrid.Views.Base;
using DevExpress.XtraGrid.Views.Card;
using DevExpress.XtraGrid.Views.Card.ViewInfo;
using DevExpress.XtraGrid.Views.Grid;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Field
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region Field

        /// <summary>
        /// 데이터 셋
        /// </summary>
        private DataSet dataSet = null;

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            #region 데이터를 로드한다.

            OleDbConnection connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\\..\\nwind.mdb");

            OleDbDataAdapter categoryAdapter = new OleDbDataAdapter
            (
                "SELECT CategoryID, CategoryName, Picture FROM Categories",
                connection
            );

            OleDbDataAdapter productAdapter  = new OleDbDataAdapter
            (
                "SELECT CategoryID, ProductID, ProductName, UnitPrice FROM Products",
                connection
            );

            this.dataSet = new DataSet();

            categoryAdapter.Fill(this.dataSet, "Categories");
            productAdapter.Fill (this.dataSet, "Products"  );

            DataTable categoryTable = this.dataSet.Tables["Categories"];
            DataTable productTable  = this.dataSet.Tables["Products"  ];

            productTable.PrimaryKey = new DataColumn[] { productTable.Columns["ProductID"] };

            DataColumn keyColumn        = categoryTable.Columns["CategoryID"];
            DataColumn foreignKeyColumn = productTable.Columns ["CategoryID"];

            this.dataSet.Relations.Add("CategoriesProducts", keyColumn, foreignKeyColumn);

            #endregion
            #region 저장소 항목 픽처 에디터를 설정한다.

            RepositoryItemPictureEdit repositoryItemPictureEdit = new RepositoryItemPictureEdit();

            repositoryItemPictureEdit.SizeMode = PictureSizeMode.Stretch;

            #endregion

            this.gridControl.RepositoryItems.Add(repositoryItemPictureEdit);

            this.gridControl.AllowDrop = true;

            CardView cardView = new CardView(this.gridControl);

            cardView.ViewCaption = "Category Products";

            this.gridControl.LevelTree.Nodes.Add("CategoriesProducts", cardView);

            this.gridControl.DataSource = categoryTable;

            this.gridView.RowHeight = 50;

            this.gridView.Columns["CategoryID"].VisibleIndex = -1;

            this.gridView.Columns["Picture"].ColumnEdit               = repositoryItemPictureEdit;
            this.gridView.Columns["Picture"].OptionsColumn.FixedWidth = true;
            this.gridView.Columns["Picture"].Width                    = 180;

            cardView.PopulateColumns(productTable);

            cardView.Columns["CategoryID"].VisibleIndex = -1;

            cardView.Columns["UnitPrice"].DisplayFormat.FormatType   = FormatType.Numeric;
            cardView.Columns["UnitPrice"].DisplayFormat.FormatString = "c2";

            this.gridControl.DragOver += gridControl_DragOver;
            this.gridControl.DragDrop += gridControl_DragDrop;
            cardView.MouseDown        += cardView_MouseDown;
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region 그리드 컨트롤 DRAG OVER 처리하기 - gridControl_DragOver(sender, e)

        /// <summary>
        /// 그리드 컨트롤 DRAG OVER 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void gridControl_DragOver(object sender, DragEventArgs e)
        {
            GridControl gridControl = sender as GridControl;

            Point point = gridControl.PointToClient(new Point(e.X, e.Y));

            BaseView baseView = gridControl.GetViewAt(point);

            if(baseView is CardView)
            {
                e.Effect = DragDropEffects.Move;
            }
            else
            {
                e.Effect = DragDropEffects.None;
            }
        }

        #endregion
        #region 그리드 컨트롤 DRAG DROP 처리하기 - gridControl_DragDrop(sender, e)

        /// <summary>
        /// 그리드 컨트롤 DRAG DROP 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void gridControl_DragDrop(object sender, DragEventArgs e)
        {
            GridControl gridControl = sender as GridControl;

            Point point = gridControl.PointToClient(new Point(e.X, e.Y));

            CardView cardView = gridControl.GetViewAt(point) as CardView;

            string dragData = e.Data.GetData(DataFormats.Text).ToString();

            int productID = Convert.ToInt32(dragData);

            GridView gridView = cardView.ParentView as GridView;

            object categoryIDObject = gridView.GetRowCellValue
            (
                cardView.SourceRowHandle,
                gridView.Columns["CategoryID"]
            );

            int categoryID = Convert.ToInt32(categoryIDObject);

            DataRow dataRow = this.dataSet.Tables["Products"].Rows.Find(productID);

            if(dataRow != null)
            {
                dataRow.SetField("CategoryID", categoryID);
            }
        }

        #endregion
        #region 카드 뷰 마우스 DOWN 처리하기 - cardView_MouseDown(sender, e)

        /// <summary>
        /// 카드 뷰 마우스 DOWN 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void cardView_MouseDown(object sender, MouseEventArgs e)
        {
            CardView cardView = sender as CardView;
            GridView gridView = cardView.ParentView as GridView;

            CardHitInfo cardHitInfo = cardView.CalcHitInfo(e.Location);

            if(cardHitInfo.HitTest == CardHitTest.CardCaption)
            {
                string productID = cardView.GetRowCellValue
                (
                    cardHitInfo.RowHandle,
                    cardView.Columns["ProductID"]
                ).ToString();

                this.gridControl.DoDragDrop(productID, DragDropEffects.Move);
            }
        }

        #endregion
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

using System;

using System.Data;

using System.Data.OleDb;

using System.Drawing;

using System.Windows.Forms;

using DevExpress.Utils;

using DevExpress.XtraEditors;

using DevExpress.XtraEditors.Controls;

using DevExpress.XtraEditors.Repository;

using DevExpress.XtraGrid;

using DevExpress.XtraGrid.Views.Base;

using DevExpress.XtraGrid.Views.Card;

using DevExpress.XtraGrid.Views.Card.ViewInfo;

using DevExpress.XtraGrid.Views.Grid;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Field

////////////////////////////////////////////////////////////////////////////////////////// Private

#region Field

/// <summary>

/// 데이터 셋

/// </summary>

private DataSet dataSet = null;

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

#region 데이터를 로드한다.

OleDbConnection connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\\..\\nwind.mdb");

OleDbDataAdapter categoryAdapter = new OleDbDataAdapter

(

"SELECT CategoryID, CategoryName, Picture FROM Categories",

connection

);

OleDbDataAdapter productAdapter = new OleDbDataAdapter

(

"SELECT CategoryID, ProductID, ProductName, UnitPrice FROM Products",

connection

);

this.dataSet = new DataSet();

categoryAdapter.Fill(this.dataSet, "Categories");

productAdapter.Fill (this.dataSet, "Products" );

DataTable categoryTable = this.dataSet.Tables["Categories"];

DataTable productTable = this.dataSet.Tables["Products" ];

productTable.PrimaryKey = new DataColumn[] { productTable.Columns["ProductID"] };

DataColumn keyColumn = categoryTable.Columns["CategoryID"];

DataColumn foreignKeyColumn = productTable.Columns ["CategoryID"];

this.dataSet.Relations.Add("CategoriesProducts", keyColumn, foreignKeyColumn);

#endregion

#region 저장소 항목 픽처 에디터를 설정한다.

RepositoryItemPictureEdit repositoryItemPictureEdit = new RepositoryItemPictureEdit();

repositoryItemPictureEdit.SizeMode = PictureSizeMode.Stretch;

#endregion

this.gridControl.RepositoryItems.Add(repositoryItemPictureEdit);

this.gridControl.AllowDrop = true;

CardView cardView = new CardView(this.gridControl);

cardView.ViewCaption = "Category Products";

this.gridControl.LevelTree.Nodes.Add("CategoriesProducts", cardView);

this.gridControl.DataSource = categoryTable;

this.gridView.RowHeight = 50;

this.gridView.Columns["CategoryID"].VisibleIndex = -1;

this.gridView.Columns["Picture"].ColumnEdit = repositoryItemPictureEdit;

this.gridView.Columns["Picture"].OptionsColumn.FixedWidth = true;

this.gridView.Columns["Picture"].Width = 180;

cardView.PopulateColumns(productTable);

cardView.Columns["CategoryID"].VisibleIndex = -1;

cardView.Columns["UnitPrice"].DisplayFormat.FormatType = FormatType.Numeric;

cardView.Columns["UnitPrice"].DisplayFormat.FormatString = "c2";

this.gridControl.DragOver += gridControl_DragOver;

this.gridControl.DragDrop += gridControl_DragDrop;

cardView.MouseDown += cardView_MouseDown;

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Private

#region 그리드 컨트롤 DRAG OVER 처리하기 - gridControl_DragOver(sender, e)

/// <summary>

/// 그리드 컨트롤 DRAG OVER 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void gridControl_DragOver(object sender, DragEventArgs e)

{

GridControl gridControl = sender as GridControl;

Point point = gridControl.PointToClient(new Point(e.X, e.Y));

BaseView baseView = gridControl.GetViewAt(point);

if(baseView is CardView)

{

e.Effect = DragDropEffects.Move;

}

else

{

e.Effect = DragDropEffects.None;

}

#endregion

#region 그리드 컨트롤 DRAG DROP 처리하기 - gridControl_DragDrop(sender, e)

/// <summary>

/// 그리드 컨트롤 DRAG DROP 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void gridControl_DragDrop(object sender, DragEventArgs e)

{

GridControl gridControl = sender as GridControl;

Point point = gridControl.PointToClient(new Point(e.X, e.Y));

CardView cardView = gridControl.GetViewAt(point) as CardView;

string dragData = e.Data.GetData(DataFormats.Text).ToString();

int productID = Convert.ToInt32(dragData);

GridView gridView = cardView.ParentView as GridView;

object categoryIDObject = gridView.GetRowCellValue

(

cardView.SourceRowHandle,

gridView.Columns["CategoryID"]

);

int categoryID = Convert.ToInt32(categoryIDObject);

DataRow dataRow = this.dataSet.Tables["Products"].Rows.Find(productID);

if(dataRow != null)

{

dataRow.SetField("CategoryID", categoryID);

}

#endregion

#region 카드 뷰 마우스 DOWN 처리하기 - cardView_MouseDown(sender, e)

/// <summary>

/// 카드 뷰 마우스 DOWN 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void cardView_MouseDown(object sender, MouseEventArgs e)

{

CardView cardView = sender as CardView;

GridView gridView = cardView.ParentView as GridView;

CardHitInfo cardHitInfo = cardView.CalcHitInfo(e.Location);

if(cardHitInfo.HitTest == CardHitTest.CardCaption)

{

string productID = cardView.GetRowCellValue

(

cardHitInfo.RowHandle,

cardView.Columns["ProductID"]

).ToString();

this.gridControl.DoDragDrop(productID, DragDropEffects.Move);

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] CardView 클래스 : ZoomView 메소드를 사용해 특정 상세 뷰 최대화 하기

■ CardView 클래스의 ZoomView 메소드를 사용해 특정 상세 뷰를 최대화하는 방법을 보여준다. ▶ MainForm.cs


using System;
using System.Data;
using System.Data.OleDb;

using DevExpress.Utils;
using DevExpress.XtraEditors;
using DevExpress.XtraEditors.Controls;
using DevExpress.XtraEditors.Repository;
using DevExpress.XtraGrid.Views.Card;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            #region 데이터를 로드한다.

            OleDbConnection connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\\..\\nwind.mdb");

            OleDbDataAdapter categoryAdapter = new OleDbDataAdapter
            (
                "SELECT CategoryID, CategoryName, Picture FROM Categories",
                connection
            );

            OleDbDataAdapter productAdapter  = new OleDbDataAdapter
            (
                "SELECT CategoryID, ProductID, ProductName, UnitPrice FROM Products",
                connection
            );

            DataSet dataSet = new DataSet();

            categoryAdapter.Fill(dataSet, "Categories");
            productAdapter.Fill (dataSet, "Products"  );

            DataTable categoryTable = dataSet.Tables["Categories"];
            DataTable productTable  = dataSet.Tables["Products"  ];

            DataColumn keyColumn        = categoryTable.Columns["CategoryID"];
            DataColumn foreignKeyColumn = productTable.Columns ["CategoryID"];

            dataSet.Relations.Add("CategoriesProducts", keyColumn, foreignKeyColumn);

            #endregion
            #region 저장소 항목 픽처 에디터를 설정한다.

            RepositoryItemPictureEdit repositoryItemPictureEdit = new RepositoryItemPictureEdit();

            repositoryItemPictureEdit.SizeMode = PictureSizeMode.Stretch;

            #endregion

            this.gridControl.RepositoryItems.Add(repositoryItemPictureEdit);

            CardView cardView = new CardView(this.gridControl);

            cardView.ViewCaption = "Category Products";

            this.gridControl.LevelTree.Nodes.Add("CategoriesProducts", cardView);

            this.gridControl.DataSource = categoryTable;

            this.gridView.RowHeight = 50;

            this.gridView.Columns["CategoryID"].VisibleIndex = -1;

            this.gridView.Columns["Picture"].ColumnEdit               = repositoryItemPictureEdit;
            this.gridView.Columns["Picture"].OptionsColumn.FixedWidth = true;
            this.gridView.Columns["Picture"].Width                    = 180;

            cardView.PopulateColumns(dataSet.Tables["Products"]);

            cardView.Columns["CategoryID"].VisibleIndex = -1;

            cardView.Columns["UnitPrice"].DisplayFormat.FormatType   = FormatType.Numeric;
            cardView.Columns["UnitPrice"].DisplayFormat.FormatString = "c2";

            this.executeButton.Click += executeButton_Click;
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region 실행하기 버튼 클릭시 처리하기 - executeButton_Click(sender, e)

        /// <summary>
        /// 실행하기 버튼 클릭시 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void executeButton_Click(object sender, EventArgs e)
        {
            int rowHandle = 0;

            this.gridView.SetMasterRowExpanded(rowHandle, true);

            CardView cardView = this.gridView.GetDetailView(rowHandle, 0) as CardView;

            cardView.ZoomView();
        }

        #endregion
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

using System;

using System.Data;

using System.Data.OleDb;

using DevExpress.Utils;

using DevExpress.XtraEditors;

using DevExpress.XtraEditors.Controls;

using DevExpress.XtraEditors.Repository;

using DevExpress.XtraGrid.Views.Card;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

#region 데이터를 로드한다.

OleDbConnection connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\\..\\nwind.mdb");

OleDbDataAdapter categoryAdapter = new OleDbDataAdapter

(

"SELECT CategoryID, CategoryName, Picture FROM Categories",

connection

);

OleDbDataAdapter productAdapter = new OleDbDataAdapter

(

"SELECT CategoryID, ProductID, ProductName, UnitPrice FROM Products",

connection

);

DataSet dataSet = new DataSet();

categoryAdapter.Fill(dataSet, "Categories");

productAdapter.Fill (dataSet, "Products" );

DataTable categoryTable = dataSet.Tables["Categories"];

DataTable productTable = dataSet.Tables["Products" ];

DataColumn keyColumn = categoryTable.Columns["CategoryID"];

DataColumn foreignKeyColumn = productTable.Columns ["CategoryID"];

dataSet.Relations.Add("CategoriesProducts", keyColumn, foreignKeyColumn);

#endregion

#region 저장소 항목 픽처 에디터를 설정한다.

RepositoryItemPictureEdit repositoryItemPictureEdit = new RepositoryItemPictureEdit();

repositoryItemPictureEdit.SizeMode = PictureSizeMode.Stretch;

#endregion

this.gridControl.RepositoryItems.Add(repositoryItemPictureEdit);

CardView cardView = new CardView(this.gridControl);

cardView.ViewCaption = "Category Products";

this.gridControl.LevelTree.Nodes.Add("CategoriesProducts", cardView);

this.gridControl.DataSource = categoryTable;

this.gridView.RowHeight = 50;

this.gridView.Columns["CategoryID"].VisibleIndex = -1;

this.gridView.Columns["Picture"].ColumnEdit = repositoryItemPictureEdit;

this.gridView.Columns["Picture"].OptionsColumn.FixedWidth = true;

this.gridView.Columns["Picture"].Width = 180;

cardView.PopulateColumns(dataSet.Tables["Products"]);

cardView.Columns["CategoryID"].VisibleIndex = -1;

cardView.Columns["UnitPrice"].DisplayFormat.FormatType = FormatType.Numeric;

cardView.Columns["UnitPrice"].DisplayFormat.FormatString = "c2";

this.executeButton.Click += executeButton_Click;

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Private

#region 실행하기 버튼 클릭시 처리하기 - executeButton_Click(sender, e)

/// <summary>

/// 실행하기 버튼 클릭시 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void executeButton_Click(object sender, EventArgs e)

{

int rowHandle = 0;

this.gridView.SetMasterRowExpanded(rowHandle, true);

CardView cardView = this.gridView.GetDetailView(rowHandle, 0) as CardView;

cardView.ZoomView();

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] GridView 클래스 : 마스터-상세 관계 설정하기

■ GridView 클래스에서 마스터-상세 관계를 설정하는 방법을 보여준다. ▶ MainForm.cs


using System.Data;
using System.Data.OleDb;

using DevExpress.Utils;
using DevExpress.XtraEditors;
using DevExpress.XtraEditors.Controls;
using DevExpress.XtraEditors.Repository;
using DevExpress.XtraGrid.Views.Card;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            #region 데이터를 로드한다.

            OleDbConnection connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\\..\\nwind.mdb");

            OleDbDataAdapter categoryAdapter = new OleDbDataAdapter
            (
                "SELECT CategoryID, CategoryName, Picture FROM Categories",
                connection
            );

            OleDbDataAdapter productAdapter  = new OleDbDataAdapter
            (
                "SELECT CategoryID, ProductID, ProductName, UnitPrice FROM Products",
                connection
            );

            DataSet dataSet = new DataSet();

            categoryAdapter.Fill(dataSet, "Categories");
            productAdapter.Fill (dataSet, "Products"  );

            DataTable categoryTable = dataSet.Tables["Categories"];
            DataTable productTable  = dataSet.Tables["Products"  ];

            DataColumn keyColumn        = categoryTable.Columns["CategoryID"];
            DataColumn foreignKeyColumn = productTable.Columns ["CategoryID"];

            dataSet.Relations.Add("CategoriesProducts", keyColumn, foreignKeyColumn);

            #endregion
            #region 저장소 항목 픽처 에디터를 설정한다.

            RepositoryItemPictureEdit repositoryItemPictureEdit = new RepositoryItemPictureEdit();

            repositoryItemPictureEdit.SizeMode = PictureSizeMode.Stretch;

            #endregion

            this.gridControl.RepositoryItems.Add(repositoryItemPictureEdit);

            CardView cardView = new CardView(this.gridControl);

            cardView.ViewCaption = "Category Products";

            this.gridControl.LevelTree.Nodes.Add("CategoriesProducts", cardView);

            this.gridControl.DataSource = categoryTable;

            this.gridView.RowHeight = 50;

            this.gridView.Columns["CategoryID"].VisibleIndex = -1;

            this.gridView.Columns["Picture"].ColumnEdit               = repositoryItemPictureEdit;
            this.gridView.Columns["Picture"].OptionsColumn.FixedWidth = true;
            this.gridView.Columns["Picture"].Width                    = 180;

            cardView.PopulateColumns(dataSet.Tables["Products"]);

            cardView.Columns["CategoryID"].VisibleIndex = -1;

            cardView.Columns["UnitPrice"].DisplayFormat.FormatType   = FormatType.Numeric;
            cardView.Columns["UnitPrice"].DisplayFormat.FormatString = "c2";
        }

        #endregion
    }
}

using System.Data;

using System.Data.OleDb;

using DevExpress.Utils;

using DevExpress.XtraEditors;

using DevExpress.XtraEditors.Controls;

using DevExpress.XtraEditors.Repository;

using DevExpress.XtraGrid.Views.Card;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

#region 데이터를 로드한다.

OleDbConnection connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\\..\\nwind.mdb");

OleDbDataAdapter categoryAdapter = new OleDbDataAdapter

(

"SELECT CategoryID, CategoryName, Picture FROM Categories",

connection

);

OleDbDataAdapter productAdapter = new OleDbDataAdapter

(

"SELECT CategoryID, ProductID, ProductName, UnitPrice FROM Products",

connection

);

DataSet dataSet = new DataSet();

categoryAdapter.Fill(dataSet, "Categories");

productAdapter.Fill (dataSet, "Products" );

DataTable categoryTable = dataSet.Tables["Categories"];

DataTable productTable = dataSet.Tables["Products" ];

DataColumn keyColumn = categoryTable.Columns["CategoryID"];

DataColumn foreignKeyColumn = productTable.Columns ["CategoryID"];

dataSet.Relations.Add("CategoriesProducts", keyColumn, foreignKeyColumn);

#endregion

#region 저장소 항목 픽처 에디터를 설정한다.

RepositoryItemPictureEdit repositoryItemPictureEdit = new RepositoryItemPictureEdit();

repositoryItemPictureEdit.SizeMode = PictureSizeMode.Stretch;

#endregion

this.gridControl.RepositoryItems.Add(repositoryItemPictureEdit);

CardView cardView = new CardView(this.gridControl);

cardView.ViewCaption = "Category Products";

this.gridControl.LevelTree.Nodes.Add("CategoriesProducts", cardView);

this.gridControl.DataSource = categoryTable;

this.gridView.RowHeight = 50;

this.gridView.Columns["CategoryID"].VisibleIndex = -1;

this.gridView.Columns["Picture"].ColumnEdit = repositoryItemPictureEdit;

this.gridView.Columns["Picture"].OptionsColumn.FixedWidth = true;

this.gridView.Columns["Picture"].Width = 180;

cardView.PopulateColumns(dataSet.Tables["Products"]);

cardView.Columns["CategoryID"].VisibleIndex = -1;

cardView.Columns["UnitPrice"].DisplayFormat.FormatType = FormatType.Numeric;

cardView.Columns["UnitPrice"].DisplayFormat.FormatString = "c2";

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] GridView 클래스 : 표준 포맷 문자열을 사용해 컬럼 포맷 설정하기

■ GridView 클래스에서 표준 포맷 문자열을 사용해 컬럼 포맷을 설정하는 방법을 보여준다. ▶ MainForm.cs


using System.Data.OleDb;

using DevExpress.Utils;
using DevExpress.XtraEditors;
using DevExpress.XtraGrid.Views.Grid;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Field
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region Field

        /// <summary>
        /// 연결
        /// </summary>
        private OleDbConnection connection;

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            this.connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb");

            this.gridView.InitializeView
            (
                true,                           // Multi Select
                GridMultiSelectMode.CellSelect, // Grid Multi Select Mode
                DrawFocusRectStyle.CellFocus,   // Draw Focus Rect Style
                true,                           // Show Indicator
                true,                           // Show Column Headers
                true,                           // Allow Column Moving
                true,                           // Allow Column Resizing
                true,                           // Allow Filter
                true,                           // Allow Sort
                false,                          // Allow Cell Merge
                EditorShowMode.Default,         // Editor Show Mode
                false                           // Editable
            );

            this.gridView.OptionsBehavior.AutoPopulateColumns = true;

            this.gridControl.DataSource = Order.GetOrderList(this.connection);

            this.gridView.Columns["OrderDate"].DisplayFormat.FormatType   = FormatType.DateTime;
            this.gridView.Columns["OrderDate"].DisplayFormat.FormatString = "D";

            this.gridView.Columns["Freight"  ].DisplayFormat.FormatType   = FormatType.Numeric;
            this.gridView.Columns["Freight"  ].DisplayFormat.FormatString = "N1";

            this.gridView.BestFitColumns();
        }

        #endregion
    }
}

using System.Data.OleDb;

using DevExpress.Utils;

using DevExpress.XtraEditors;

using DevExpress.XtraGrid.Views.Grid;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Field

////////////////////////////////////////////////////////////////////////////////////////// Private

#region Field

/// <summary>

/// 연결

/// </summary>

private OleDbConnection connection;

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

this.connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb");

this.gridView.InitializeView

(

true, // Multi Select

GridMultiSelectMode.CellSelect, // Grid Multi Select Mode

DrawFocusRectStyle.CellFocus, // Draw Focus Rect Style

true, // Show Indicator

true, // Show Column Headers

true, // Allow Column Moving

true, // Allow Column Resizing

true, // Allow Filter

true, // Allow Sort

false, // Allow Cell Merge

EditorShowMode.Default, // Editor Show Mode

false // Editable

);

this.gridView.OptionsBehavior.AutoPopulateColumns = true;

this.gridControl.DataSource = Order.GetOrderList(this.connection);

this.gridView.Columns["OrderDate"].DisplayFormat.FormatType = FormatType.DateTime;

this.gridView.Columns["OrderDate"].DisplayFormat.FormatString = "D";

this.gridView.Columns["Freight" ].DisplayFormat.FormatType = FormatType.Numeric;

this.gridView.Columns["Freight" ].DisplayFormat.FormatString = "N1";

this.gridView.BestFitColumns();

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] GridView 클래스 : 적절한 문자열로 부울 값을 대체하기 위한 커스텀 포매터 생성하기

■ GridView 클래스에서 적절한 문자열로 부울 값을 대체하기 위한 커스텀 포매터를 생성하는 방법을 보여준다. ▶ MainForm.cs


using System.Data.OleDb;

using DevExpress.Utils;
using DevExpress.XtraEditors;
using DevExpress.XtraGrid.Views.Grid;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Field
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region Field

        /// <summary>
        /// 연결
        /// </summary>
        private OleDbConnection connection;

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            this.connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb");

            this.gridView.InitializeView
            (
                true,                           // Multi Select
                GridMultiSelectMode.CellSelect, // Grid Multi Select Mode
                DrawFocusRectStyle.CellFocus,   // Draw Focus Rect Style
                true,                           // Show Indicator
                true,                           // Show Column Headers
                true,                           // Allow Column Moving
                true,                           // Allow Column Resizing
                true,                           // Allow Filter
                true,                           // Allow Sort
                false,                          // Allow Cell Merge
                EditorShowMode.Default,         // Editor Show Mode
                false                           // Editable
            );

            this.gridView.OptionsBehavior.AutoPopulateColumns = true;

            this.gridControl.DataSource = Product.GetProductList(this.connection);

            this.gridView.Columns["Discontinued"].ColumnEdit               = this.gridView.GridControl.RepositoryItems.Add("TextEdit");
            this.gridView.Columns["Discontinued"].DisplayFormat.FormatType = FormatType.Custom;
            this.gridView.Columns["Discontinued"].DisplayFormat.Format     = new BooleanFormatter("Discontinued", "");

            this.gridView.BestFitColumns();
        }

        #endregion
    }
}

using System.Data.OleDb;

using DevExpress.Utils;

using DevExpress.XtraEditors;

using DevExpress.XtraGrid.Views.Grid;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Field

////////////////////////////////////////////////////////////////////////////////////////// Private

#region Field

/// <summary>

/// 연결

/// </summary>

private OleDbConnection connection;

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

this.connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb");

this.gridView.InitializeView

(

true, // Multi Select

GridMultiSelectMode.CellSelect, // Grid Multi Select Mode

DrawFocusRectStyle.CellFocus, // Draw Focus Rect Style

true, // Show Indicator

true, // Show Column Headers

true, // Allow Column Moving

true, // Allow Column Resizing

true, // Allow Filter

true, // Allow Sort

false, // Allow Cell Merge

EditorShowMode.Default, // Editor Show Mode

false // Editable

);

this.gridView.OptionsBehavior.AutoPopulateColumns = true;

this.gridControl.DataSource = Product.GetProductList(this.connection);

this.gridView.Columns["Discontinued"].ColumnEdit = this.gridView.GridControl.RepositoryItems.Add("TextEdit");

this.gridView.Columns["Discontinued"].DisplayFormat.FormatType = FormatType.Custom;

this.gridView.Columns["Discontinued"].DisplayFormat.Format = new BooleanFormatter("Discontinued", "");

this.gridView.BestFitColumns();

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] GridView 클래스 : RTF 데이터를 표시하는 그리드 컬럼에 대해 필터 처리하기

■ GridView 클래스에서 RTF 데이터를 표시하는 그리드 컬럼에 대해 필터를 처리하는 방법을 보여준다. ▶ MainForm.cs


using System;
using System.Data;

using DevExpress.XtraEditors;
using DevExpress.XtraGrid.Views.Base;
using DevExpress.XtraGrid.Views.Grid;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            Load                                  += Form_Load;
            this.gridView.CustomUnboundColumnData += gridView_CustomUnboundColumnData;
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region 폼 로드시 처리하기 - Form_Load(sender, e)

        /// <summary>
        /// 폼 로드시 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void Form_Load(object sender, EventArgs e)
        {
            DataTable dataTable = new DataTable();

            dataTable.Columns.Add("ID"         , typeof(int   ));
            dataTable.Columns.Add("Name"       , typeof(string));
            dataTable.Columns.Add("Description", typeof(string));

            for(int i = 1; i < 10; i++)
            {
                dataTable.Rows.Add(i, string.Format("Item{0}", i), DataProvider.DescriptionArray[i % 4]);
            }

            this.gridControl.DataSource = dataTable;
        }

        #endregion
        #region 그리드 뷰 언바운드 컬럼 데이터 커스텀 설정하기 - gridView_CustomUnboundColumnData(sender, e)

        /// <summary>
        /// 그리드 뷰 언바운드 컬럼 데이터 커스텀 설정하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void gridView_CustomUnboundColumnData(object sender, CustomColumnDataEventArgs e)
        {
            GridView gridView = sender as GridView;

            if(e.Column.FieldName == "SimpleText" && e.IsGetData)
            {
                object value = gridView.GetListSourceRowCellValue(e.ListSourceRowIndex, descriptionColumn);

                e.Value = this.descriptionRepositoryItemRichTextEdit.ConvertEditValueToPlainText(value);
            }
        }

        #endregion
    }
}

using System;

using System.Data;

using DevExpress.XtraEditors;

using DevExpress.XtraGrid.Views.Base;

using DevExpress.XtraGrid.Views.Grid;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

Load += Form_Load;

this.gridView.CustomUnboundColumnData += gridView_CustomUnboundColumnData;

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Private

#region 폼 로드시 처리하기 - Form_Load(sender, e)

/// <summary>

/// 폼 로드시 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void Form_Load(object sender, EventArgs e)

{

DataTable dataTable = new DataTable();

dataTable.Columns.Add("ID" , typeof(int ));

dataTable.Columns.Add("Name" , typeof(string));

dataTable.Columns.Add("Description", typeof(string));

for(int i = 1; i < 10; i++)

{

dataTable.Rows.Add(i, string.Format("Item{0}", i), DataProvider.DescriptionArray[i % 4]);

}

this.gridControl.DataSource = dataTable;

}

#endregion

#region 그리드 뷰 언바운드 컬럼 데이터 커스텀 설정하기 - gridView_CustomUnboundColumnData(sender, e)

/// <summary>

/// 그리드 뷰 언바운드 컬럼 데이터 커스텀 설정하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void gridView_CustomUnboundColumnData(object sender, CustomColumnDataEventArgs e)

{

GridView gridView = sender as GridView;

if(e.Column.FieldName == "SimpleText" && e.IsGetData)

{

object value = gridView.GetListSourceRowCellValue(e.ListSourceRowIndex, descriptionColumn);

e.Value = this.descriptionRepositoryItemRichTextEdit.ConvertEditValueToPlainText(value);

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] GridView 클래스 : ActiveFilter 속성을 사용해 필터 설정하기

■ GridView 클래스의 ActiveFilter 속성을 사용해 필터를 설정하는 방법을 보여준다. ▶ MainForm.cs


using System.Data.OleDb;

using DevExpress.Utils;
using DevExpress.XtraEditors;
using DevExpress.XtraGrid.Views.Grid;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Field
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region Field

        /// <summary>
        /// 연결
        /// </summary>
        private OleDbConnection connection;

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            this.connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb");

            this.gridView.InitializeView
            (
                true,                           // Multi Select
                GridMultiSelectMode.CellSelect, // Grid Multi Select Mode
                DrawFocusRectStyle.CellFocus,   // Draw Focus Rect Style
                true,                           // Show Indicator
                true,                           // Show Column Headers
                true,                           // Allow Column Moving
                true,                           // Allow Column Resizing
                true,                           // Allow Filter
                true,                           // Allow Sort
                false,                          // Allow Cell Merge
                EditorShowMode.Default,         // Editor Show Mode
                true                            // Editable
            );

            this.gridView.OptionsBehavior.AutoPopulateColumns = true;

            this.gridView.OptionsView.ShowFooter = true;

            this.gridControl.DataSource = Customer.GetCustomerList(this.connection);

            this.gridView.ActiveFilter.Clear();

            this.gridView.ActiveFilter.NonColumnFilter = "ContactName LIKE 'A%' AND Country LIKE 'M%'";

            this.gridView.BestFitColumns();
        }

        #endregion
    }
}

using System.Data.OleDb;

using DevExpress.Utils;

using DevExpress.XtraEditors;

using DevExpress.XtraGrid.Views.Grid;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Field

////////////////////////////////////////////////////////////////////////////////////////// Private

#region Field

/// <summary>

/// 연결

/// </summary>

private OleDbConnection connection;

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

this.connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb");

this.gridView.InitializeView

(

true, // Multi Select

GridMultiSelectMode.CellSelect, // Grid Multi Select Mode

DrawFocusRectStyle.CellFocus, // Draw Focus Rect Style

true, // Show Indicator

true, // Show Column Headers

true, // Allow Column Moving

true, // Allow Column Resizing

true, // Allow Filter

true, // Allow Sort

false, // Allow Cell Merge

EditorShowMode.Default, // Editor Show Mode

true // Editable

);

this.gridView.OptionsBehavior.AutoPopulateColumns = true;

this.gridView.OptionsView.ShowFooter = true;

this.gridControl.DataSource = Customer.GetCustomerList(this.connection);

this.gridView.ActiveFilter.Clear();

this.gridView.ActiveFilter.NonColumnFilter = "ContactName LIKE 'A%' AND Country LIKE 'M%'";

this.gridView.BestFitColumns();

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] GridView 클래스 : CustomFilterDisplayText 이벤트를 사용해 필터 디스플레이 텍스트 커스텀 설정하기

■ GridView 클래스의 CustomFilterDisplayText 이벤트를 사용해 필터 디스플레이 텍스트를 커스텀 설정하는 방법을 보여준다. ▶ MainForm.cs


using System.Data.OleDb;

using DevExpress.Utils;
using DevExpress.XtraEditors;
using DevExpress.XtraEditors.Controls;
using DevExpress.XtraGrid.Columns;
using DevExpress.XtraGrid.Views.Grid;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Field
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region Field

        /// <summary>
        /// 연결
        /// </summary>
        private OleDbConnection connection;

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            this.connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb");

            this.gridView.InitializeView
            (
                true,                           // Multi Select
                GridMultiSelectMode.CellSelect, // Grid Multi Select Mode
                DrawFocusRectStyle.CellFocus,   // Draw Focus Rect Style
                true,                           // Show Indicator
                true,                           // Show Column Headers
                true,                           // Allow Column Moving
                true,                           // Allow Column Resizing
                true,                           // Allow Filter
                true,                           // Allow Sort
                false,                          // Allow Cell Merge
                EditorShowMode.Default,         // Editor Show Mode
                true                            // Editable
            );

            this.gridView.OptionsBehavior.AutoPopulateColumns = true;

            this.gridView.OptionsView.ShowFooter = true;

            this.gridControl.DataSource = Customer.GetCustomerList(this.connection);

            this.gridView.ActiveFilter.Add(this.gridView.Columns["Country"], new ColumnFilterInfo("[Country] LIKE 'G%'"));

            this.gridView.BestFitColumns();

            this.gridView.CustomFilterDisplayText += gridView_CustomFilterDisplayText;
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region 그리드 뷰 필터 디스플레이 텍스트 커스텀 설정하기 - gridView_CustomFilterDisplayText(sender, e)

        /// <summary>
        /// 그리드 뷰 필터 디스플레이 텍스트 커스텀 설정하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void gridView_CustomFilterDisplayText(object sender, ConvertEditValueEventArgs e)
        {
            if(e.Value == null)
            {
                e.Value = "No Filter";
            }
            else
            {
                e.Value = $"필터식 : {e.Value}";
            }

            e.Handled = true;
        }

        #endregion
    }
}

100

101

using System.Data.OleDb;

using DevExpress.Utils;

using DevExpress.XtraEditors;

using DevExpress.XtraEditors.Controls;

using DevExpress.XtraGrid.Columns;

using DevExpress.XtraGrid.Views.Grid;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Field

////////////////////////////////////////////////////////////////////////////////////////// Private

#region Field

/// <summary>

/// 연결

/// </summary>

private OleDbConnection connection;

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

this.connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb");

this.gridView.InitializeView

(

true, // Multi Select

GridMultiSelectMode.CellSelect, // Grid Multi Select Mode

DrawFocusRectStyle.CellFocus, // Draw Focus Rect Style

true, // Show Indicator

true, // Show Column Headers

true, // Allow Column Moving

true, // Allow Column Resizing

true, // Allow Filter

true, // Allow Sort

false, // Allow Cell Merge

EditorShowMode.Default, // Editor Show Mode

true // Editable

);

this.gridView.OptionsBehavior.AutoPopulateColumns = true;

this.gridView.OptionsView.ShowFooter = true;

this.gridControl.DataSource = Customer.GetCustomerList(this.connection);

this.gridView.ActiveFilter.Add(this.gridView.Columns["Country"], new ColumnFilterInfo("[Country] LIKE 'G%'"));

this.gridView.BestFitColumns();

this.gridView.CustomFilterDisplayText += gridView_CustomFilterDisplayText;

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Private

#region 그리드 뷰 필터 디스플레이 텍스트 커스텀 설정하기 - gridView_CustomFilterDisplayText(sender, e)

/// <summary>

/// 그리드 뷰 필터 디스플레이 텍스트 커스텀 설정하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void gridView_CustomFilterDisplayText(object sender, ConvertEditValueEventArgs e)

{

if(e.Value == null)

{

e.Value = "No Filter";

}

else

{

e.Value = $"필터식 : {e.Value}";

}

e.Handled = true;

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] GridView 클래스 : ActiveFilterCriteria 속성을 사용해 활성 필터 기준 설정하기

■ GridView 클래스의 ActiveFilterCriteria 속성을 사용해 활성 필터 기준을 설정하는 방법을 보여준다. ▶ MainForm.cs


using System.Data.OleDb;

using DevExpress.Data.Filtering;
using DevExpress.Utils;
using DevExpress.XtraEditors;
using DevExpress.XtraGrid.Views.Grid;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Field
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region Field

        /// <summary>
        /// 연결
        /// </summary>
        private OleDbConnection connection;

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            this.connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb");

            this.gridView.InitializeView
            (
                true,                           // Multi Select
                GridMultiSelectMode.CellSelect, // Grid Multi Select Mode
                DrawFocusRectStyle.CellFocus,   // Draw Focus Rect Style
                true,                           // Show Indicator
                true,                           // Show Column Headers
                true,                           // Allow Column Moving
                true,                           // Allow Column Resizing
                true,                           // Allow Filter
                true,                           // Allow Sort
                false,                          // Allow Cell Merge
                EditorShowMode.Default,         // Editor Show Mode
                true                            // Editable
            );

            this.gridView.OptionsBehavior.AutoPopulateColumns = true;

            this.gridControl.DataSource = Customer.GetCustomerList(this.connection);

            this.gridView.BestFitColumns();

            CriteriaOperator criteriaOperator1 = new BinaryOperator("Country", "Germany");
            CriteriaOperator criteriaOperator2 = new BinaryOperator("Country", "Mexico" );

            this.gridView.ActiveFilterCriteria = GroupOperator.Or(new CriteriaOperator[] { criteriaOperator1, criteriaOperator2 });
        }

        #endregion
    }
}

using System.Data.OleDb;

using DevExpress.Data.Filtering;

using DevExpress.Utils;

using DevExpress.XtraEditors;

using DevExpress.XtraGrid.Views.Grid;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Field

////////////////////////////////////////////////////////////////////////////////////////// Private

#region Field

/// <summary>

/// 연결

/// </summary>

private OleDbConnection connection;

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

this.connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb");

this.gridView.InitializeView

(

true, // Multi Select

GridMultiSelectMode.CellSelect, // Grid Multi Select Mode

DrawFocusRectStyle.CellFocus, // Draw Focus Rect Style

true, // Show Indicator

true, // Show Column Headers

true, // Allow Column Moving

true, // Allow Column Resizing

true, // Allow Filter

true, // Allow Sort

false, // Allow Cell Merge

EditorShowMode.Default, // Editor Show Mode

true // Editable

);

this.gridView.OptionsBehavior.AutoPopulateColumns = true;

this.gridControl.DataSource = Customer.GetCustomerList(this.connection);

this.gridView.BestFitColumns();

CriteriaOperator criteriaOperator1 = new BinaryOperator("Country", "Germany");

CriteriaOperator criteriaOperator2 = new BinaryOperator("Country", "Mexico" );

this.gridView.ActiveFilterCriteria = GroupOperator.Or(new CriteriaOperator[] { criteriaOperator1, criteriaOperator2 });

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] GridView 클래스 : ActiveFilter 속성을 사용해 필터 추가하기

■ GridView 클래스의 ActiveFilter 속성을 사용해 필터를 추가하는 방법을 보여준다. ▶ MainForm.cs


using System.Data.OleDb;

using DevExpress.Utils;
using DevExpress.XtraEditors;
using DevExpress.XtraGrid.Columns;
using DevExpress.XtraGrid.Views.Base;
using DevExpress.XtraGrid.Views.Grid;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Field
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region Field

        /// <summary>
        /// 연결
        /// </summary>
        private OleDbConnection connection;

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            this.connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb");

            this.gridView.InitializeView
            (
                true,                           // Multi Select
                GridMultiSelectMode.CellSelect, // Grid Multi Select Mode
                DrawFocusRectStyle.CellFocus,   // Draw Focus Rect Style
                true,                           // Show Indicator
                true,                           // Show Column Headers
                true,                           // Allow Column Moving
                true,                           // Allow Column Resizing
                true,                           // Allow Filter
                true,                           // Allow Sort
                false,                          // Allow Cell Merge
                EditorShowMode.Default,         // Editor Show Mode
                true                            // Editable
            );

            this.gridView.OptionsBehavior.AutoPopulateColumns = true;

            this.gridControl.DataSource = Product.GetProductList(this.connection);

            this.gridView.BestFitColumns();

            this.gridView.ActiveFilter.Clear();

            ViewColumnFilterInfo viewColumnFilterInfo = new ViewColumnFilterInfo
            (
                this.gridView.Columns["ProductName"],
                new ColumnFilterInfo("[ProductName] LIKE 'A%'", "")
            );

            this.gridView.ActiveFilter.Add(viewColumnFilterInfo);
        }

        #endregion
    }
}

using System.Data.OleDb;

using DevExpress.Utils;

using DevExpress.XtraEditors;

using DevExpress.XtraGrid.Columns;

using DevExpress.XtraGrid.Views.Base;

using DevExpress.XtraGrid.Views.Grid;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Field

////////////////////////////////////////////////////////////////////////////////////////// Private

#region Field

/// <summary>

/// 연결

/// </summary>

private OleDbConnection connection;

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

this.connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb");

this.gridView.InitializeView

(

true, // Multi Select

GridMultiSelectMode.CellSelect, // Grid Multi Select Mode

DrawFocusRectStyle.CellFocus, // Draw Focus Rect Style

true, // Show Indicator

true, // Show Column Headers

true, // Allow Column Moving

true, // Allow Column Resizing

true, // Allow Filter

true, // Allow Sort

false, // Allow Cell Merge

EditorShowMode.Default, // Editor Show Mode

true // Editable

);

this.gridView.OptionsBehavior.AutoPopulateColumns = true;

this.gridControl.DataSource = Product.GetProductList(this.connection);

this.gridView.BestFitColumns();

this.gridView.ActiveFilter.Clear();

ViewColumnFilterInfo viewColumnFilterInfo = new ViewColumnFilterInfo

(

this.gridView.Columns["ProductName"],

new ColumnFilterInfo("[ProductName] LIKE 'A%'", "")

);

this.gridView.ActiveFilter.Add(viewColumnFilterInfo);

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] GridView 클래스 : ActiveFilter 속성을 사용해 필터 추가하기

■ GridView 클래스의 ActiveFilter 속성을 사용해 필터를 추가하는 방법을 보여준다. ▶ MainForm.cs


using System.Data.OleDb;

using DevExpress.Utils;
using DevExpress.XtraEditors;
using DevExpress.XtraGrid.Columns;
using DevExpress.XtraGrid.Views.Grid;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Field
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region Field

        /// <summary>
        /// 연결
        /// </summary>
        private OleDbConnection connection;

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            this.connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb");

            this.gridView.InitializeView
            (
                true,                           // Multi Select
                GridMultiSelectMode.CellSelect, // Grid Multi Select Mode
                DrawFocusRectStyle.CellFocus,   // Draw Focus Rect Style
                true,                           // Show Indicator
                true,                           // Show Column Headers
                true,                           // Allow Column Moving
                true,                           // Allow Column Resizing
                true,                           // Allow Filter
                true,                           // Allow Sort
                false,                          // Allow Cell Merge
                EditorShowMode.Default,         // Editor Show Mode
                true                            // Editable
            );

            this.gridView.OptionsBehavior.AutoPopulateColumns = true;

            this.gridControl.DataSource = Product.GetProductList(this.connection);

            this.gridView.BestFitColumns();

            this.gridView.ActiveFilter.Clear();

            this.gridView.ActiveFilter.Add(this.gridView.Columns["ProductName"], new ColumnFilterInfo("[ProductName] LIKE 'A%'"));
        }

        #endregion
    }
}

using System.Data.OleDb;

using DevExpress.Utils;

using DevExpress.XtraEditors;

using DevExpress.XtraGrid.Columns;

using DevExpress.XtraGrid.Views.Grid;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Field

////////////////////////////////////////////////////////////////////////////////////////// Private

#region Field

/// <summary>

/// 연결

/// </summary>

private OleDbConnection connection;

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

this.connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb");

this.gridView.InitializeView

(

true, // Multi Select

GridMultiSelectMode.CellSelect, // Grid Multi Select Mode

DrawFocusRectStyle.CellFocus, // Draw Focus Rect Style

true, // Show Indicator

true, // Show Column Headers

true, // Allow Column Moving

true, // Allow Column Resizing

true, // Allow Filter

true, // Allow Sort

false, // Allow Cell Merge

EditorShowMode.Default, // Editor Show Mode

true // Editable

);

this.gridView.OptionsBehavior.AutoPopulateColumns = true;

this.gridControl.DataSource = Product.GetProductList(this.connection);

this.gridView.BestFitColumns();

this.gridView.ActiveFilter.Clear();

this.gridView.ActiveFilter.Add(this.gridView.Columns["ProductName"], new ColumnFilterInfo("[ProductName] LIKE 'A%'"));

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] GridView 클래스 : ExportToPdf 메소드를 사용해 PDF 파일 내보내기

■ GridView 클래스의 ExportToPdf 메소드를 사용해 PDF 파일을 내보내는 방법을 보여준다. ▶ MainForm.cs


using System;
using System.Collections.Generic;
using System.Data.OleDb;
using System.Diagnostics;

using DevExpress.Utils;
using DevExpress.XtraEditors;
using DevExpress.XtraGrid.Views.Grid;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Field
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region Field

        /// <summary>
        /// 연결
        /// </summary>
        private OleDbConnection connection;

        /// <summary>
        /// 소스 리스트
        /// </summary>
        private List<OrderDetail> sourceList;

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            this.connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb");

            this.gridView.InitializeView
            (
                true,                           // Multi Select
                GridMultiSelectMode.CellSelect, // Grid Multi Select Mode
                DrawFocusRectStyle.CellFocus,   // Draw Focus Rect Style
                true,                           // Show Indicator
                true,                           // Show Column Headers
                true,                           // Allow Column Moving
                true,                           // Allow Column Resizing
                true,                           // Allow Filter
                true,                           // Allow Sort
                false,                          // Allow Cell Merge
                EditorShowMode.Default,         // Editor Show Mode
                false                           // Editable
            );

            this.gridView.OptionsBehavior.AutoPopulateColumns = true;

            this.sourceList = OrderDetail.GetOrderDetailList(this.connection);

            this.gridControl.DataSource = this.sourceList;

            this.gridView.BestFitColumns();

            this.exportButton.Click += exportButton_Click;
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region PDF 파일 내보내기 버튼 클릭시 처리하기 - previewButton_Click(sender, e)

        /// <summary>
        /// PDF 파일 내보내기 버튼 클릭시 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void exportButton_Click(object sender, EventArgs e)
        {
            this.gridView.OptionsPrint.ExpandAllDetails = true;

            this.gridView.ExportToPdf("d:\\sample.pdf");

            Process.Start("d:\\sample.pdf");
        }

        #endregion
    }
}

100

using System;

using System.Collections.Generic;

using System.Data.OleDb;

using System.Diagnostics;

using DevExpress.Utils;

using DevExpress.XtraEditors;

using DevExpress.XtraGrid.Views.Grid;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Field

////////////////////////////////////////////////////////////////////////////////////////// Private

#region Field

/// <summary>

/// 연결

/// </summary>

private OleDbConnection connection;

/// <summary>

/// 소스 리스트

/// </summary>

private List<OrderDetail> sourceList;

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

this.connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb");

this.gridView.InitializeView

(

true, // Multi Select

GridMultiSelectMode.CellSelect, // Grid Multi Select Mode

DrawFocusRectStyle.CellFocus, // Draw Focus Rect Style

true, // Show Indicator

true, // Show Column Headers

true, // Allow Column Moving

true, // Allow Column Resizing

true, // Allow Filter

true, // Allow Sort

false, // Allow Cell Merge

EditorShowMode.Default, // Editor Show Mode

false // Editable

);

this.gridView.OptionsBehavior.AutoPopulateColumns = true;

this.sourceList = OrderDetail.GetOrderDetailList(this.connection);

this.gridControl.DataSource = this.sourceList;

this.gridView.BestFitColumns();

this.exportButton.Click += exportButton_Click;

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Private

#region PDF 파일 내보내기 버튼 클릭시 처리하기 - previewButton_Click(sender, e)

/// <summary>

/// PDF 파일 내보내기 버튼 클릭시 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void exportButton_Click(object sender, EventArgs e)

{

this.gridView.OptionsPrint.ExpandAllDetails = true;

this.gridView.ExportToPdf("d:\\sample.pdf");

Process.Start("d:\\sample.pdf");

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] GridControl 클래스 : 데이터 식별 엑셀 내보내기

■ GridControl 클래스에서 데이터 식별 엑셀을 내보내는 방법을 보여준다. ▶ MainForm.cs


using System;
using System.Collections.Generic;
using System.Data.OleDb;
using System.Diagnostics;
using System.Drawing;
using System.IO;
using System.Reflection;
using System.Windows.Forms;

using DevExpress.Export;
using DevExpress.Export.Xl;
using DevExpress.Printing.ExportHelpers;
using DevExpress.Utils;
using DevExpress.XtraEditors;
using DevExpress.XtraPrinting;
using DevExpress.XtraGrid.Views.Base;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Delegate
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region 셀 추가 대리자 - AddCellDelegate(e, formattingObject1, formattingObject2)

        /// <summary>
        /// 셀 추가 대리자
        /// </summary>
        /// <param name="e">이벤트 인자</param>
        /// <param name="formattingObject1">포맷 객체 1</param>
        /// <param name="formattingObject2">포맷 객체 2</param>
        private delegate void AddCellDelegate(ContextEventArgs e, XlFormattingObject formattingObject1, XlFormattingObject formattingObject2);

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Field
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region Field

        /// <summary>
        /// Discontinued 셀 정렬
        /// </summary>
        private XlCellAlignment discontinuedCellAlignment = new XlCellAlignment()
        {
            HorizontalAlignment = XlHorizontalAlignment.Center,
            VerticalAlignment   = XlVerticalAlignment.Center
        };

        /// <summary>
        /// 셀 추가 대리자 딕셔너리
        /// </summary>
        private Dictionary<int, AddCellDelegate> addCellDelegateDictionary;

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            string filePath = FilesHelper.FindingFileName(Application.StartupPath, "nwind.mdb");

            string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath;

            OleDbDataAdapter adapter1 = new OleDbDataAdapter("SELECT * FROM Products"  , connectionString);
            OleDbDataAdapter adapter2 = new OleDbDataAdapter("SELECT * FROM Categories", connectionString);

            this.gridView.OptionsView.ColumnAutoWidth = false;

            adapter1.Fill(nwindDataSet.Products  );
            adapter2.Fill(nwindDataSet.Categories);

            this.addCellDelegateDictionary = GetAddCellDelegateDictionary();

            this.gridView.ExpandAllGroups();

            Load                                  += Form_Load;
            this.exportButton.Click               += exportButton_Click;
            this.gridView.CustomUnboundColumnData += gridView_CustomUnboundColumnData;
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private
        //////////////////////////////////////////////////////////////////////////////// Event

        #region 폼 로드시 처리하기 - Form_Load(sender, e)

        /// <summary>
        /// 폼 로드시 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void Form_Load(object sender, EventArgs e)
        {
            this.gridView.BestFitColumns(true);
        }

        #endregion
        #region 내보내기 옵션 시트 설정 커스텀 설정하기 - exportOptionsEx_CustomizeSheetSettings(e)

        /// <summary>
        /// 내보내기 옵션 시트 설정 커스텀 설정하기
        /// </summary>
        /// <param name="e">이벤트 인자</param>
        private void exportOptionsEx_CustomizeSheetSettings(CustomizeSheetEventArgs e)
        {
            const int lastHeaderRowIndex = 15;

            e.ExportContext.SetFixedHeader(lastHeaderRowIndex);

            e.ExportContext.AddAutoFilter
            (
                new XlCellRange
                (
                    new XlCellPosition(0, lastHeaderRowIndex),
                    new XlCellPosition(5, 100)
                )
            );
        }

        #endregion
        #region 내보내기 옵션 시트 헤더 커스텀 설정하기 - exportOptionsEx_CustomizeSheetHeader(e)

        /// <summary>
        /// 내보내기 옵션 시트 헤더 커스텀 설정하기
        /// </summary>
        /// <param name="e">이벤트 인자</param>
        private void exportOptionsEx_CustomizeSheetHeader(ContextEventArgs e)
        {
            XlFormattingObject formattingObject1 = GetFormattingObject(true, 24);
            XlFormattingObject formattingObject2 = GetFormattingObject(true, 18);

            for(int i = 0; i < 15; i++)
            {
                AddCellDelegate addCellDelegate;

                if(addCellDelegateDictionary.TryGetValue(i, out addCellDelegate))
                {
                    addCellDelegate(e, formattingObject1, formattingObject2);
                }
                else
                {
                    e.ExportContext.AddRow();
                }
            }

            MergeCells(e);

            Stream stream = Assembly.GetExecutingAssembly().GetManifestResourceStream("TestProject.RESOURCE.1.jpg");

            if(stream != null)
            {
                Bitmap bitmap = new Bitmap(Image.FromStream(stream));

                XlCellRange cellRange = new XlCellRange
                (
                    new XlCellPosition(0, 0),
                    new XlCellPosition(5, 7)
                );

                e.ExportContext.MergeCells(cellRange);

                e.ExportContext.InsertImage(bitmap, cellRange);
            }

            e.ExportContext.MergeCells
            (
                new XlCellRange
                (
                    new XlCellPosition(0, 8),
                    new XlCellPosition(5, 8)
                )
            );
        }

        #endregion
        #region 내보내기 옵션 셀 커스텀 설정하기 - exportOptionsEx_CustomizeCell(e)

        /// <summary>
        /// 내보내기 옵션 셀 커스텀 설정하기
        /// </summary>
        /// <param name="e">이벤트 인자</param>
        private void exportOptionsEx_CustomizeCell(CustomizeCellEventArgs e)
        {
            if(e.ColumnFieldName == "Discontinued")
            {
                if(e.Value is bool)
                {
                    e.Handled = true;

                    e.Formatting.Alignment = this.discontinuedCellAlignment;

                    e.Value = ((bool)e.Value) ? "☑" : "☐";
                }
            }
        }

        #endregion
        #region 내보내기 옵션 시트 FOOTER 커스텀 설정하기 - exportOptionsEx_CustomizeSheetFooter(e)

        /// <summary>
        /// 내보내기 옵션 시트 FOOTER 커스텀 설정하기
        /// </summary>
        /// <param name="e">이벤트 인자</param>
        private void exportOptionsEx_CustomizeSheetFooter(ContextEventArgs e)
        {
            e.ExportContext.AddRow();

            XlFormattingObject rowFormattingObject = GetFormattingObject(true, 18);

            rowFormattingObject.Alignment.HorizontalAlignment = XlHorizontalAlignment.Left;

            CellObject firstCellObject = new CellObject();

            firstCellObject.Value      = "The report is generated from the NorthWind database.";
            firstCellObject.Formatting = rowFormattingObject;

            e.ExportContext.AddRow(new[]{ firstCellObject });

            CellObject secondCellObject = new CellObject();

            secondCellObject.Value = "The addresses and phone numbers are fictitious.";

            rowFormattingObject.Font.Size   = 14;
            rowFormattingObject.Font.Bold   = false;
            rowFormattingObject.Font.Italic = true;

            secondCellObject.Formatting = rowFormattingObject;

            e.ExportContext.AddRow(new[]{ secondCellObject });
        }

        #endregion
        #region 내보내기 옵션 행 추가 후 처리하기 - exportOptionsEx_AfterAddRow(e)

        /// <summary>
        /// 내보내기 옵션 행 추가 후 처리하기
        /// </summary>
        /// <param name="e">이벤트 인자</param>
        private void exportOptionsEx_AfterAddRow(AfterAddRowEventArgs e)
        {
            if(e.DataSourceRowIndex < 0)
            {
                e.ExportContext.MergeCells
                (
                    new XlCellRange
                    (
                        new XlCellPosition(0, e.DocumentRow - 1),
                        new XlCellPosition(5, e.DocumentRow - 1)
                    )
                );
            }
        }

        #endregion
        #region 엑셀 XLSX 포맷 내보내기 버튼 클릭시 처리하기 - exportButton_Click(sender, e)

        /// <summary>
        /// 엑셀 XLSX 포맷 내보내기 버튼 클릭시 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void exportButton_Click(object sender, EventArgs e)
        {
            ExportSettings.DefaultExportType = ExportType.DataAware;

            XlsxExportOptionsEx exportOptionsEx = new XlsxExportOptionsEx();

            exportOptionsEx.SheetName = "DevAV price";

            exportOptionsEx.CustomizeSheetSettings += exportOptionsEx_CustomizeSheetSettings;
            exportOptionsEx.CustomizeSheetHeader   += exportOptionsEx_CustomizeSheetHeader;
            exportOptionsEx.CustomizeCell          += exportOptionsEx_CustomizeCell;
            exportOptionsEx.CustomizeSheetFooter   += exportOptionsEx_CustomizeSheetFooter;
            exportOptionsEx.AfterAddRow            += exportOptionsEx_AfterAddRow;

            this.gridControl.ExportToXlsx("grid-export.xlsx", exportOptionsEx);

            Process.Start("grid-export.xlsx");
        }

        #endregion
        #region 그리드 뷰 언바운드 컬럼 데이터 커스텀 처리하기 - gridView_CustomUnboundColumnData(sender, e)

        /// <summary>
        /// 그리드 뷰 언바운드 컬럼 데이터 커스텀 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void gridView_CustomUnboundColumnData(object sender, CustomColumnDataEventArgs e)
        {
            if(e.Column == this.categoryNameColumn)
            {
                if(e.IsGetData)
                {
                    e.Value = nwindDataSet.Categories.FindByCategoryID
                    (
                        (int)(gridView.GetRowCellValue(gridView.GetRowHandle(e.ListSourceRowIndex), categoryIDColumn))
                    ).CategoryName;
                }
            }
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////// Event

        #region 셀 객체 구하기 - GetCellObject(value, formattingObject)

        /// <summary>
        /// 셀 객체 구하기
        /// </summary>
        /// <param name="value">값</param>
        /// <param name="formattingObject">포맷 객체</param>
        /// <returns>셀 객체</returns>
        private CellObject GetCellObject(object value, XlFormattingObject formattingObject)
        {
            return new CellObject{ Value = value, Formatting = formattingObject };
        }

        #endregion
        #region 주소 행 추가하기 1 - AddAddressRow1(e, formattingObjec1, formattingObjec2)

        /// <summary>
        /// 주소 행 추가하기 1
        /// </summary>
        /// <param name="e">이벤트 인자</param>
        /// <param name="formattingObjec1">포맷 객체 1</param>
        /// <param name="formattingObjec2">포맷 객체 2</param>
        private void AddAddressRow1(ContextEventArgs e, XlFormattingObject formattingObjec1, XlFormattingObject formattingObjec2)
        {
            CellObject labelCellObject = GetCellObject("Address : "            , formattingObjec1);
            CellObject valueCellObject = GetCellObject("807 West Paseo Del Mar", formattingObjec2);

            e.ExportContext.AddRow(new[]{ labelCellObject, null, valueCellObject });
        }

        #endregion
        #region 주소 행 추가하기 2 - AddAddressRow2(e, formattingObject1, formattingObject2)

        /// <summary>
        /// 주소 행 추가하기 2
        /// </summary>
        /// <param name="e">이벤트 인자</param>
        /// <param name="formattingObject1">포맷 객체 1</param>
        /// <param name="formattingObject2">포맷 객체 2</param>
        private void AddAddressRow2(ContextEventArgs e, XlFormattingObject formattingObject1, XlFormattingObject formattingObject2)
        {
            CellObject valueCellObject = GetCellObject("Los Angeles CA 90731 USA", formattingObject2);

            e.ExportContext.AddRow(new[]{ null, null, valueCellObject });
        }

        #endregion
        #region 전화 행 추가하기 - AddPhoneRow(e, formattingObject1, formattingObject2)

        /// <summary>
        /// 전화 행 추가하기
        /// </summary>
        /// <param name="e">이벤트 인자</param>
        /// <param name="formattingObject1">포맷 객체 1</param>
        /// <param name="formattingObject2">포맷 객체 2</param>
        private void AddPhoneRow(ContextEventArgs e, XlFormattingObject formattingObject1, XlFormattingObject formattingObject2)
        {
            CellObject labelCellObject = GetCellObject("Phone :"           , formattingObject1);
            CellObject valueCellObject = GetCellObject("+ 1 (213) 555-2828", formattingObject2);

            e.ExportContext.AddRow(new[]{ labelCellObject, null, valueCellObject });
        }

        #endregion
        #region 팩스 행 추가하기 - AddFAXRow(e, formattingObject1, formattingObject2)

        /// <summary>
        /// 팩스 행 추가하기
        /// </summary>
        /// <param name="e">이벤트 인자</param>
        /// <param name="formattingObject1">포맷 객체 1</param>
        /// <param name="formattingObject2">포맷 객체 2</param>
        private void AddFAXRow(ContextEventArgs e, XlFormattingObject formattingObject1, XlFormattingObject formattingObject2)
        {
            CellObject labelCellObject = GetCellObject("Fax :"             , formattingObject1);
            CellObject valueCellObject = GetCellObject("+ 1 (213) 555-1824", formattingObject2);

            e.ExportContext.AddRow(new[]{ labelCellObject, null, valueCellObject });
        }

        #endregion
        #region 이메일 행 추가하기 - AddEMailRow(e, formattingObject1, formattingObject2)

        /// <summary>
        /// 이메일 행 추가하기
        /// </summary>
        /// <param name="e">이벤트 인자</param>
        /// <param name="formattingObject1">포맷 객체 1</param>
        /// <param name="formattingObject2">포맷 객체 2</param>
        private void AddEMailRow(ContextEventArgs e, XlFormattingObject formattingObject1, XlFormattingObject formattingObject2)
        {
            CellObject labelCellObject = GetCellObject("Email :"            , formattingObject1);
            CellObject valueCellObject = GetCellObject("corpsales@devav.com", formattingObject2);

            valueCellObject.Hyperlink = "corpsales@devav.com";

            e.ExportContext.AddRow(new[]{ labelCellObject, null, valueCellObject });
        }

        #endregion
        #region 셀 추가 대리자 딕셔너리 구하기 - GetAddCellDelegateDictionary()

        /// <summary>
        /// 셀 추가 대리자 딕셔너리 구하기
        /// </summary>
        /// <returns>셀 추가 대리자 딕셔너리</returns>
        private Dictionary<int, AddCellDelegate> GetAddCellDelegateDictionary()
        {
            Dictionary<int, AddCellDelegate> dictionary = new Dictionary<int, AddCellDelegate>();

            dictionary.Add(9 , AddAddressRow1);
            dictionary.Add(10, AddAddressRow2);
            dictionary.Add(11, AddPhoneRow   );
            dictionary.Add(12, AddFAXRow     );
            dictionary.Add(13, AddEMailRow   );

            return dictionary;
        }

        #endregion
        #region 포맷 객체 구하기 - GetFormattingObject(bold, size)

        /// <summary>
        /// 포맷 객체 구하기
        /// </summary>
        /// <param name="bold">볼드체 여부</param>
        /// <param name="size">크기</param>
        /// <returns>포맷 객체</returns>
        private XlFormattingObject GetFormattingObject(bool bold, double size)
        {
            XlFormattingObject formattingObject = new XlFormattingObject
            {
                Font = new XlCellFont
                {
                    Bold = bold,
                    Size = size
                },
                Alignment = new XlCellAlignment
                {
                    RelativeIndent      = 10,
                    HorizontalAlignment = XlHorizontalAlignment.Center,
                    VerticalAlignment   = XlVerticalAlignment.Center
                }
            };

            return formattingObject;
        }

        #endregion
        #region 셀 병합하기 - MergeCells(e, left, top, right, bottom)

        /// <summary>
        /// 셀 병합하기
        /// </summary>
        /// <param name="e">이벤트 인자</param>
        /// <param name="left">왼쪽</param>
        /// <param name="top">위쪽</param>
        /// <param name="right">오른쪽</param>
        /// <param name="bottom">아래쪽</param>
        private void MergeCells(ContextEventArgs e, int left, int top, int right, int bottom)
        {
            e.ExportContext.MergeCells
            (
                new XlCellRange
                (
                    new XlCellPosition(left , top   ),
                    new XlCellPosition(right, bottom)
                )
            );
        }

        #endregion
        #region 셀 병합하기 - MergeCells(e)

        /// <summary>
        /// 셀 병합하기
        /// </summary>
        /// <param name="e">이벤트 인자</param>
        private void MergeCells(ContextEventArgs e)
        {
            MergeCells(e, 2, 9 , 5, 9 );
            MergeCells(e, 0, 9 , 1, 10);
            MergeCells(e, 2, 10, 5, 10);
            MergeCells(e, 0, 11, 1, 11);
            MergeCells(e, 2, 11, 5, 11);
            MergeCells(e, 0, 12, 1, 12);
            MergeCells(e, 2, 12, 5, 12);
            MergeCells(e, 0, 13, 1, 13);
            MergeCells(e, 2, 13, 5, 13);
            MergeCells(e, 0, 14, 5, 14);
        }

        #endregion
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

264

265

266

267

268

269

270

271

272

273

274

275

276

277

278

279

280

281

282

283

284

285

286

287

288

289

290

291

292

293

294

295

296

297

298

299

300

301

302

303

304

305

306

307

308

309

310

311

312

313

314

315

316

317

318

319

320

321

322

323

324

325

326

327

328

329

330

331

332

333

334

335

336

337

338

339

340

341

342

343

344

345

346

347

348

349

350

351

352

353

354

355

356

357

358

359

360

361

362

363

364

365

366

367

368

369

370

371

372

373

374

375

376

377

378

379

380

381

382

383

384

385

386

387

388

389

390

391

392

393

394

395

396

397

398

399

400

401

402

403

404

405

406

407

408

409

410

411

412

413

414

415

416

417

418

419

420

421

422

423

424

425

426

427

428

429

430

431

432

433

434

435

436

437

438

439

440

441

442

443

444

445

446

447

448

449

450

451

452

453

454

455

456

457

458

459

460

461

462

463

464

465

466

467

468

469

470

471

472

473

474

475

476

477

478

479

480

481

482

483

484

485

486

487

488

489

490

491

492

493

494

495

496

497

498

499

500

501

502

503

504

505

506

507

508

509

510

511

512

513

514

515

516

517

518

using System;

using System.Collections.Generic;

using System.Data.OleDb;

using System.Diagnostics;

using System.Drawing;

using System.IO;

using System.Reflection;

using System.Windows.Forms;

using DevExpress.Export;

using DevExpress.Export.Xl;

using DevExpress.Printing.ExportHelpers;

using DevExpress.Utils;

using DevExpress.XtraEditors;

using DevExpress.XtraPrinting;

using DevExpress.XtraGrid.Views.Base;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Delegate

////////////////////////////////////////////////////////////////////////////////////////// Private

#region 셀 추가 대리자 - AddCellDelegate(e, formattingObject1, formattingObject2)

/// <summary>

/// 셀 추가 대리자

/// </summary>

/// <param name="e">이벤트 인자</param>

/// <param name="formattingObject1">포맷 객체 1</param>

/// <param name="formattingObject2">포맷 객체 2</param>

private delegate void AddCellDelegate(ContextEventArgs e, XlFormattingObject formattingObject1, XlFormattingObject formattingObject2);

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Field

////////////////////////////////////////////////////////////////////////////////////////// Private

#region Field

/// <summary>

/// Discontinued 셀 정렬

/// </summary>

private XlCellAlignment discontinuedCellAlignment = new XlCellAlignment()

{

HorizontalAlignment = XlHorizontalAlignment.Center,

VerticalAlignment = XlVerticalAlignment.Center

};

/// <summary>

/// 셀 추가 대리자 딕셔너리

/// </summary>

private Dictionary<int, AddCellDelegate> addCellDelegateDictionary;

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

string filePath = FilesHelper.FindingFileName(Application.StartupPath, "nwind.mdb");

string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath;

OleDbDataAdapter adapter1 = new OleDbDataAdapter("SELECT * FROM Products" , connectionString);

OleDbDataAdapter adapter2 = new OleDbDataAdapter("SELECT * FROM Categories", connectionString);

this.gridView.OptionsView.ColumnAutoWidth = false;

adapter1.Fill(nwindDataSet.Products );

adapter2.Fill(nwindDataSet.Categories);

this.addCellDelegateDictionary = GetAddCellDelegateDictionary();

this.gridView.ExpandAllGroups();

Load += Form_Load;

this.exportButton.Click += exportButton_Click;

this.gridView.CustomUnboundColumnData += gridView_CustomUnboundColumnData;

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Private

//////////////////////////////////////////////////////////////////////////////// Event

#region 폼 로드시 처리하기 - Form_Load(sender, e)

/// <summary>

/// 폼 로드시 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void Form_Load(object sender, EventArgs e)

{

this.gridView.BestFitColumns(true);

}

#endregion

#region 내보내기 옵션 시트 설정 커스텀 설정하기 - exportOptionsEx_CustomizeSheetSettings(e)

/// <summary>

/// 내보내기 옵션 시트 설정 커스텀 설정하기

/// </summary>

/// <param name="e">이벤트 인자</param>

private void exportOptionsEx_CustomizeSheetSettings(CustomizeSheetEventArgs e)

{

const int lastHeaderRowIndex = 15;

e.ExportContext.SetFixedHeader(lastHeaderRowIndex);

e.ExportContext.AddAutoFilter

(

new XlCellRange

(

new XlCellPosition(0, lastHeaderRowIndex),

new XlCellPosition(5, 100)

)

);

}

#endregion

#region 내보내기 옵션 시트 헤더 커스텀 설정하기 - exportOptionsEx_CustomizeSheetHeader(e)

/// <summary>

/// 내보내기 옵션 시트 헤더 커스텀 설정하기

/// </summary>

/// <param name="e">이벤트 인자</param>

private void exportOptionsEx_CustomizeSheetHeader(ContextEventArgs e)

{

XlFormattingObject formattingObject1 = GetFormattingObject(true, 24);

XlFormattingObject formattingObject2 = GetFormattingObject(true, 18);

for(int i = 0; i < 15; i++)

{

AddCellDelegate addCellDelegate;

if(addCellDelegateDictionary.TryGetValue(i, out addCellDelegate))

{

addCellDelegate(e, formattingObject1, formattingObject2);

}

else

{

e.ExportContext.AddRow();

}

MergeCells(e);

Stream stream = Assembly.GetExecutingAssembly().GetManifestResourceStream("TestProject.RESOURCE.1.jpg");

if(stream != null)

{

Bitmap bitmap = new Bitmap(Image.FromStream(stream));

XlCellRange cellRange = new XlCellRange

(

new XlCellPosition(0, 0),

new XlCellPosition(5, 7)

);

e.ExportContext.MergeCells(cellRange);

e.ExportContext.InsertImage(bitmap, cellRange);

}

e.ExportContext.MergeCells

(

new XlCellRange

(

new XlCellPosition(0, 8),

new XlCellPosition(5, 8)

)

);

}

#endregion

#region 내보내기 옵션 셀 커스텀 설정하기 - exportOptionsEx_CustomizeCell(e)

/// <summary>

/// 내보내기 옵션 셀 커스텀 설정하기

/// </summary>

/// <param name="e">이벤트 인자</param>

private void exportOptionsEx_CustomizeCell(CustomizeCellEventArgs e)

{

if(e.ColumnFieldName == "Discontinued")

{

if(e.Value is bool)

{

e.Handled = true;

e.Formatting.Alignment = this.discontinuedCellAlignment;

e.Value = ((bool)e.Value) ? "☑" : "☐";

}

#endregion

#region 내보내기 옵션 시트 FOOTER 커스텀 설정하기 - exportOptionsEx_CustomizeSheetFooter(e)

/// <summary>

/// 내보내기 옵션 시트 FOOTER 커스텀 설정하기

/// </summary>

/// <param name="e">이벤트 인자</param>

private void exportOptionsEx_CustomizeSheetFooter(ContextEventArgs e)

{

e.ExportContext.AddRow();

XlFormattingObject rowFormattingObject = GetFormattingObject(true, 18);

rowFormattingObject.Alignment.HorizontalAlignment = XlHorizontalAlignment.Left;

CellObject firstCellObject = new CellObject();

firstCellObject.Value = "The report is generated from the NorthWind database.";

firstCellObject.Formatting = rowFormattingObject;

e.ExportContext.AddRow(new[]{ firstCellObject });

CellObject secondCellObject = new CellObject();

secondCellObject.Value = "The addresses and phone numbers are fictitious.";

rowFormattingObject.Font.Size = 14;

rowFormattingObject.Font.Bold = false;

rowFormattingObject.Font.Italic = true;

secondCellObject.Formatting = rowFormattingObject;

e.ExportContext.AddRow(new[]{ secondCellObject });

}

#endregion

#region 내보내기 옵션 행 추가 후 처리하기 - exportOptionsEx_AfterAddRow(e)

/// <summary>

/// 내보내기 옵션 행 추가 후 처리하기

/// </summary>

/// <param name="e">이벤트 인자</param>

private void exportOptionsEx_AfterAddRow(AfterAddRowEventArgs e)

{

if(e.DataSourceRowIndex < 0)

{

e.ExportContext.MergeCells

(

new XlCellRange

(

new XlCellPosition(0, e.DocumentRow - 1),

new XlCellPosition(5, e.DocumentRow - 1)

)

);

}

#endregion

#region 엑셀 XLSX 포맷 내보내기 버튼 클릭시 처리하기 - exportButton_Click(sender, e)

/// <summary>

/// 엑셀 XLSX 포맷 내보내기 버튼 클릭시 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void exportButton_Click(object sender, EventArgs e)

{

ExportSettings.DefaultExportType = ExportType.DataAware;

XlsxExportOptionsEx exportOptionsEx = new XlsxExportOptionsEx();

exportOptionsEx.SheetName = "DevAV price";

exportOptionsEx.CustomizeSheetSettings += exportOptionsEx_CustomizeSheetSettings;

exportOptionsEx.CustomizeSheetHeader += exportOptionsEx_CustomizeSheetHeader;

exportOptionsEx.CustomizeCell += exportOptionsEx_CustomizeCell;

exportOptionsEx.CustomizeSheetFooter += exportOptionsEx_CustomizeSheetFooter;

exportOptionsEx.AfterAddRow += exportOptionsEx_AfterAddRow;

this.gridControl.ExportToXlsx("grid-export.xlsx", exportOptionsEx);

Process.Start("grid-export.xlsx");

}

#endregion

#region 그리드 뷰 언바운드 컬럼 데이터 커스텀 처리하기 - gridView_CustomUnboundColumnData(sender, e)

/// <summary>

/// 그리드 뷰 언바운드 컬럼 데이터 커스텀 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void gridView_CustomUnboundColumnData(object sender, CustomColumnDataEventArgs e)

{

if(e.Column == this.categoryNameColumn)

{

if(e.IsGetData)

{

e.Value = nwindDataSet.Categories.FindByCategoryID

(

(int)(gridView.GetRowCellValue(gridView.GetRowHandle(e.ListSourceRowIndex), categoryIDColumn))

).CategoryName;

}

#endregion

//////////////////////////////////////////////////////////////////////////////// Event

#region 셀 객체 구하기 - GetCellObject(value, formattingObject)

/// <summary>

/// 셀 객체 구하기

/// </summary>

/// <param name="value">값</param>

/// <param name="formattingObject">포맷 객체</param>

/// <returns>셀 객체</returns>

private CellObject GetCellObject(object value, XlFormattingObject formattingObject)

{

return new CellObject{ Value = value, Formatting = formattingObject };

}

#endregion

#region 주소 행 추가하기 1 - AddAddressRow1(e, formattingObjec1, formattingObjec2)

/// <summary>

/// 주소 행 추가하기 1

/// </summary>

/// <param name="e">이벤트 인자</param>

/// <param name="formattingObjec1">포맷 객체 1</param>

/// <param name="formattingObjec2">포맷 객체 2</param>

private void AddAddressRow1(ContextEventArgs e, XlFormattingObject formattingObjec1, XlFormattingObject formattingObjec2)

{

CellObject labelCellObject = GetCellObject("Address : " , formattingObjec1);

CellObject valueCellObject = GetCellObject("807 West Paseo Del Mar", formattingObjec2);

e.ExportContext.AddRow(new[]{ labelCellObject, null, valueCellObject });

}

#endregion

#region 주소 행 추가하기 2 - AddAddressRow2(e, formattingObject1, formattingObject2)

/// <summary>

/// 주소 행 추가하기 2

/// </summary>

/// <param name="e">이벤트 인자</param>

/// <param name="formattingObject1">포맷 객체 1</param>

/// <param name="formattingObject2">포맷 객체 2</param>

private void AddAddressRow2(ContextEventArgs e, XlFormattingObject formattingObject1, XlFormattingObject formattingObject2)

{

CellObject valueCellObject = GetCellObject("Los Angeles CA 90731 USA", formattingObject2);

e.ExportContext.AddRow(new[]{ null, null, valueCellObject });

}

#endregion

#region 전화 행 추가하기 - AddPhoneRow(e, formattingObject1, formattingObject2)

/// <summary>

/// 전화 행 추가하기

/// </summary>

/// <param name="e">이벤트 인자</param>

/// <param name="formattingObject1">포맷 객체 1</param>

/// <param name="formattingObject2">포맷 객체 2</param>

private void AddPhoneRow(ContextEventArgs e, XlFormattingObject formattingObject1, XlFormattingObject formattingObject2)

{

CellObject labelCellObject = GetCellObject("Phone :" , formattingObject1);

CellObject valueCellObject = GetCellObject("+ 1 (213) 555-2828", formattingObject2);

e.ExportContext.AddRow(new[]{ labelCellObject, null, valueCellObject });

}

#endregion

#region 팩스 행 추가하기 - AddFAXRow(e, formattingObject1, formattingObject2)

/// <summary>

/// 팩스 행 추가하기

/// </summary>

/// <param name="e">이벤트 인자</param>

/// <param name="formattingObject1">포맷 객체 1</param>

/// <param name="formattingObject2">포맷 객체 2</param>

private void AddFAXRow(ContextEventArgs e, XlFormattingObject formattingObject1, XlFormattingObject formattingObject2)

{

CellObject labelCellObject = GetCellObject("Fax :" , formattingObject1);

CellObject valueCellObject = GetCellObject("+ 1 (213) 555-1824", formattingObject2);

e.ExportContext.AddRow(new[]{ labelCellObject, null, valueCellObject });

}

#endregion

#region 이메일 행 추가하기 - AddEMailRow(e, formattingObject1, formattingObject2)

/// <summary>

/// 이메일 행 추가하기

/// </summary>

/// <param name="e">이벤트 인자</param>

/// <param name="formattingObject1">포맷 객체 1</param>

/// <param name="formattingObject2">포맷 객체 2</param>

private void AddEMailRow(ContextEventArgs e, XlFormattingObject formattingObject1, XlFormattingObject formattingObject2)

{

CellObject labelCellObject = GetCellObject("Email :" , formattingObject1);

CellObject valueCellObject = GetCellObject("corpsales@devav.com", formattingObject2);

valueCellObject.Hyperlink = "corpsales@devav.com";

e.ExportContext.AddRow(new[]{ labelCellObject, null, valueCellObject });

}

#endregion

#region 셀 추가 대리자 딕셔너리 구하기 - GetAddCellDelegateDictionary()

/// <summary>

/// 셀 추가 대리자 딕셔너리 구하기

/// </summary>

/// <returns>셀 추가 대리자 딕셔너리</returns>

private Dictionary<int, AddCellDelegate> GetAddCellDelegateDictionary()

{

Dictionary<int, AddCellDelegate> dictionary = new Dictionary<int, AddCellDelegate>();

dictionary.Add(9 , AddAddressRow1);

dictionary.Add(10, AddAddressRow2);

dictionary.Add(11, AddPhoneRow );

dictionary.Add(12, AddFAXRow );

dictionary.Add(13, AddEMailRow );

return dictionary;

}

#endregion

#region 포맷 객체 구하기 - GetFormattingObject(bold, size)

/// <summary>

/// 포맷 객체 구하기

/// </summary>

/// <param name="bold">볼드체 여부</param>

/// <param name="size">크기</param>

/// <returns>포맷 객체</returns>

private XlFormattingObject GetFormattingObject(bool bold, double size)

{

XlFormattingObject formattingObject = new XlFormattingObject

{

Font = new XlCellFont

{

Bold = bold,

Size = size

Alignment = new XlCellAlignment

{

RelativeIndent = 10,

HorizontalAlignment = XlHorizontalAlignment.Center,

VerticalAlignment = XlVerticalAlignment.Center

}

};

return formattingObject;

}

#endregion

#region 셀 병합하기 - MergeCells(e, left, top, right, bottom)

/// <summary>

/// 셀 병합하기

/// </summary>

/// <param name="e">이벤트 인자</param>

/// <param name="left">왼쪽</param>

/// <param name="top">위쪽</param>

/// <param name="right">오른쪽</param>

/// <param name="bottom">아래쪽</param>

private void MergeCells(ContextEventArgs e, int left, int top, int right, int bottom)

{

e.ExportContext.MergeCells

(

new XlCellRange

(

new XlCellPosition(left , top ),

new XlCellPosition(right, bottom)

)

);

}

#endregion

#region 셀 병합하기 - MergeCells(e)

/// <summary>

/// 셀 병합하기

/// </summary>

/// <param name="e">이벤트 인자</param>

private void MergeCells(ContextEventArgs e)

{

MergeCells(e, 2, 9 , 5, 9 );

MergeCells(e, 0, 9 , 1, 10);

MergeCells(e, 2, 10, 5, 10);

MergeCells(e, 0, 11, 1, 11);

MergeCells(e, 2, 11, 5, 11);

MergeCells(e, 0, 12, 1, 12);

MergeCells(e, 2, 12, 5, 12);

MergeCells(e, 0, 13, 1, 13);

MergeCells(e, 2, 13, 5, 13);

MergeCells(e, 0, 14, 5, 14);

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] GridView 클래스 : PrintInitialize 이벤트를 사용해 인쇄 설정 커스텀 처리하기

■ GridView 클래스의 PrintInitialize 이벤트를 사용해 인쇄 설정을 커스텀 처리하는 방법을 보여준다. ▶ MainForm.cs


using System;
using System.Collections.Generic;
using System.Data.OleDb;

using DevExpress.Utils;
using DevExpress.XtraEditors;
using DevExpress.XtraGrid.Views.Base;
using DevExpress.XtraGrid.Views.Grid;
using DevExpress.XtraPrinting;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Field
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region Field

        /// <summary>
        /// 연결
        /// </summary>
        private OleDbConnection connection;

        /// <summary>
        /// 소스 리스트
        /// </summary>
        private List<OrderDetail> sourceList;

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            this.connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb");

            this.gridView.InitializeView
            (
                true,                           // Multi Select
                GridMultiSelectMode.CellSelect, // Grid Multi Select Mode
                DrawFocusRectStyle.CellFocus,   // Draw Focus Rect Style
                true,                           // Show Indicator
                true,                           // Show Column Headers
                true,                           // Allow Column Moving
                true,                           // Allow Column Resizing
                true,                           // Allow Filter
                true,                           // Allow Sort
                false,                          // Allow Cell Merge
                EditorShowMode.Default,         // Editor Show Mode
                false                           // Editable
            );

            this.gridView.OptionsBehavior.AutoPopulateColumns = true;

            this.sourceList = OrderDetail.GetOrderDetailList(this.connection);

            this.gridControl.DataSource = this.sourceList;

            this.gridView.BestFitColumns();

            this.gridView.PrintInitialize += gridView_PrintInitialize;
            this.previewButton.Click      += previewButton_Click;
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region 그리드 뷰 인쇄 초기화하기 - gridView_PrintInitialize(sender, e)

        /// <summary>
        /// 그리드 뷰 인쇄 초기화하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void gridView_PrintInitialize(object sender, PrintInitializeEventArgs e)
        {
            PrintingSystemBase printingSystemBase = e.PrintingSystem as PrintingSystemBase;

            printingSystemBase.PageSettings.Landscape = true;
        }

        #endregion
        #region 인쇄 미리보기 버튼 클릭시 처리하기 - previewButton_Click(sender, e)

        /// <summary>
        /// 인쇄 미리보기 버튼 클릭시 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void previewButton_Click(object sender, EventArgs e)
        {
            this.gridView.ShowPrintPreview();
        }

        #endregion
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

using System;

using System.Collections.Generic;

using System.Data.OleDb;

using DevExpress.Utils;

using DevExpress.XtraEditors;

using DevExpress.XtraGrid.Views.Base;

using DevExpress.XtraGrid.Views.Grid;

using DevExpress.XtraPrinting;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Field

////////////////////////////////////////////////////////////////////////////////////////// Private

#region Field

/// <summary>

/// 연결

/// </summary>

private OleDbConnection connection;

/// <summary>

/// 소스 리스트

/// </summary>

private List<OrderDetail> sourceList;

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

this.connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb");

this.gridView.InitializeView

(

true, // Multi Select

GridMultiSelectMode.CellSelect, // Grid Multi Select Mode

DrawFocusRectStyle.CellFocus, // Draw Focus Rect Style

true, // Show Indicator

true, // Show Column Headers

true, // Allow Column Moving

true, // Allow Column Resizing

true, // Allow Filter

true, // Allow Sort

false, // Allow Cell Merge

EditorShowMode.Default, // Editor Show Mode

false // Editable

);

this.gridView.OptionsBehavior.AutoPopulateColumns = true;

this.sourceList = OrderDetail.GetOrderDetailList(this.connection);

this.gridControl.DataSource = this.sourceList;

this.gridView.BestFitColumns();

this.gridView.PrintInitialize += gridView_PrintInitialize;

this.previewButton.Click += previewButton_Click;

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Private

#region 그리드 뷰 인쇄 초기화하기 - gridView_PrintInitialize(sender, e)

/// <summary>

/// 그리드 뷰 인쇄 초기화하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void gridView_PrintInitialize(object sender, PrintInitializeEventArgs e)

{

PrintingSystemBase printingSystemBase = e.PrintingSystem as PrintingSystemBase;

printingSystemBase.PageSettings.Landscape = true;

}

#endregion

#region 인쇄 미리보기 버튼 클릭시 처리하기 - previewButton_Click(sender, e)

/// <summary>

/// 인쇄 미리보기 버튼 클릭시 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void previewButton_Click(object sender, EventArgs e)

{

this.gridView.ShowPrintPreview();

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] GridSplitContainer 클래스 사용하기

■ GridSplitContainer 클래스를 사용하는 방법을 보여준다. ▶ MainForm.cs


using System;
using System.Collections.Generic;
using System.Windows.Forms;

using DevExpress.XtraEditors;
using DevExpress.XtraGrid;
using DevExpress.XtraGrid.Views.Grid;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            List<Record> recordList = Record.GetRecordList();

            GridSplitContainer gridSplitContainer = new GridSplitContainer();

            gridSplitContainer.Parent   = this;
            gridSplitContainer.Dock     = DockStyle.Fill;

            gridSplitContainer.Initialize();

            gridSplitContainer.SplitViewCreated += gridSplitContainer_SplitViewCreated;


            GridControl gridControl1 = gridSplitContainer.Grid;

            gridControl1.DataSource = recordList;

            GridView gridView1 = gridControl1.MainView as GridView;

            gridView1.BestFitColumns();

            gridView1.FocusedRowHandle = gridView1.LocateByValue("Country", "UK");


            gridSplitContainer.ShowSplitView();


            GridControl gridControl2 = gridSplitContainer.SplitChildGrid;

            GridView gridView2 = gridControl2.MainView as GridView;

            gridView2.FocusedRowHandle = gridView2.LocateByValue("Country", "Sweden");
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region 그리드 분리 컨테이너 분리 뷰 생성시 처리하기 - gridSplitContainer_SplitViewCreated(sender, e)

        /// <summary>
        /// 그리드 분리 컨테이너 분리 뷰 생성시 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void gridSplitContainer_SplitViewCreated(object sender, EventArgs e)
        {
            GridSplitContainer gridSplitContainer = sender as GridSplitContainer;

            if(!gridSplitContainer.Horizontal)
            {
                gridSplitContainer.SplitChildGrid.UseEmbeddedNavigator = true;
            }
        }

        #endregion
    }
}

using System;

using System.Collections.Generic;

using System.Windows.Forms;

using DevExpress.XtraEditors;

using DevExpress.XtraGrid;

using DevExpress.XtraGrid.Views.Grid;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

List<Record> recordList = Record.GetRecordList();

GridSplitContainer gridSplitContainer = new GridSplitContainer();

gridSplitContainer.Parent = this;

gridSplitContainer.Dock = DockStyle.Fill;

gridSplitContainer.Initialize();

gridSplitContainer.SplitViewCreated += gridSplitContainer_SplitViewCreated;

GridControl gridControl1 = gridSplitContainer.Grid;

gridControl1.DataSource = recordList;

GridView gridView1 = gridControl1.MainView as GridView;

gridView1.BestFitColumns();

gridView1.FocusedRowHandle = gridView1.LocateByValue("Country", "UK");

gridSplitContainer.ShowSplitView();

GridControl gridControl2 = gridSplitContainer.SplitChildGrid;

GridView gridView2 = gridControl2.MainView as GridView;

gridView2.FocusedRowHandle = gridView2.LocateByValue("Country", "Sweden");

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Private

#region 그리드 분리 컨테이너 분리 뷰 생성시 처리하기 - gridSplitContainer_SplitViewCreated(sender, e)

/// <summary>

/// 그리드 분리 컨테이너 분리 뷰 생성시 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void gridSplitContainer_SplitViewCreated(object sender, EventArgs e)

{

GridSplitContainer gridSplitContainer = sender as GridSplitContainer;

if(!gridSplitContainer.Horizontal)

{

gridSplitContainer.SplitChildGrid.UseEmbeddedNavigator = true;

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] GridView 클래스 : ValidateRow 이벤트를 사용해 행 검증하기

■ GridView 클래스의 ValidateRow 이벤트를 사용해 행을 검증하는 방법을 보여준다. ▶ MainForm.cs


using System.Data.OleDb;

using DevExpress.Utils;
using DevExpress.XtraEditors;
using DevExpress.XtraEditors.Controls;
using DevExpress.XtraGrid.Columns;
using DevExpress.XtraGrid.Views.Base;
using DevExpress.XtraGrid.Views.Grid;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Field
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region Field

        /// <summary>
        /// 연결
        /// </summary>
        private OleDbConnection connection;

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            this.connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb");

            this.gridView.InitializeView
            (
                true,                           // Multi Select
                GridMultiSelectMode.CellSelect, // Grid Multi Select Mode
                DrawFocusRectStyle.CellFocus,   // Draw Focus Rect Style
                true,                           // Show Indicator
                true,                           // Show Column Headers
                true,                           // Allow Column Moving
                true,                           // Allow Column Resizing
                true,                           // Allow Filter
                true,                           // Allow Sort
                false,                          // Allow Cell Merge
                EditorShowMode.Default,         // Editor Show Mode
                true                            // Editable
            );

            this.gridView.OptionsBehavior.AutoPopulateColumns = true;

            this.gridControl.DataSource = Product.GetProductList(this.connection);

            this.gridView.BestFitColumns();

            this.gridView.ValidateRow         += gridView_ValidateRow;
            this.gridView.InvalidRowException += gridView_InvalidRowException;
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region 그리드 뷰 행 검증하기 - gridView_ValidateRow(sender, e)

        /// <summary>
        /// 그리드 뷰 행 검증하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void gridView_ValidateRow(object sender, ValidateRowEventArgs e)
        {
            GridView gridView = sender as GridView;

            GridColumn unitsOnOrderColumn = gridView.Columns["UnitsOnOrder"];
            GridColumn unitsInStockColumn = gridView.Columns["UnitsInStock"];

            decimal unitsOnOrder = (decimal)gridView.GetRowCellValue(e.RowHandle, unitsOnOrderColumn);
            decimal unitsInStock = (decimal)gridView.GetRowCellValue(e.RowHandle, unitsInStockColumn);

            if(unitsOnOrder > unitsInStock)
            {
                e.Valid = false;

                gridView.SetColumnError(unitsInStockColumn, "주문 단위보다 큽니다."  );
                gridView.SetColumnError(unitsOnOrderColumn, "재고 단위보다 작습니다.");
            }
        }

        #endregion
        #region 그리드 뷰 무효 행 예외 처리하기 - gridView_InvalidRowException(sender, e)

        /// <summary>
        /// 그리드 뷰 무효 행 예외 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void gridView_InvalidRowException(object sender, InvalidRowExceptionEventArgs e)
        {
            e.ExceptionMode = ExceptionMode.DisplayError;
        }

        #endregion
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

using System.Data.OleDb;

using DevExpress.Utils;

using DevExpress.XtraEditors;

using DevExpress.XtraEditors.Controls;

using DevExpress.XtraGrid.Columns;

using DevExpress.XtraGrid.Views.Base;

using DevExpress.XtraGrid.Views.Grid;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Field

////////////////////////////////////////////////////////////////////////////////////////// Private

#region Field

/// <summary>

/// 연결

/// </summary>

private OleDbConnection connection;

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

this.connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb");

this.gridView.InitializeView

(

true, // Multi Select

GridMultiSelectMode.CellSelect, // Grid Multi Select Mode

DrawFocusRectStyle.CellFocus, // Draw Focus Rect Style

true, // Show Indicator

true, // Show Column Headers

true, // Allow Column Moving

true, // Allow Column Resizing

true, // Allow Filter

true, // Allow Sort

false, // Allow Cell Merge

EditorShowMode.Default, // Editor Show Mode

true // Editable

);

this.gridView.OptionsBehavior.AutoPopulateColumns = true;

this.gridControl.DataSource = Product.GetProductList(this.connection);

this.gridView.BestFitColumns();

this.gridView.ValidateRow += gridView_ValidateRow;

this.gridView.InvalidRowException += gridView_InvalidRowException;

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Private

#region 그리드 뷰 행 검증하기 - gridView_ValidateRow(sender, e)

/// <summary>

/// 그리드 뷰 행 검증하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void gridView_ValidateRow(object sender, ValidateRowEventArgs e)

{

GridView gridView = sender as GridView;

GridColumn unitsOnOrderColumn = gridView.Columns["UnitsOnOrder"];

GridColumn unitsInStockColumn = gridView.Columns["UnitsInStock"];

decimal unitsOnOrder = (decimal)gridView.GetRowCellValue(e.RowHandle, unitsOnOrderColumn);

decimal unitsInStock = (decimal)gridView.GetRowCellValue(e.RowHandle, unitsInStockColumn);

if(unitsOnOrder > unitsInStock)

{

e.Valid = false;

gridView.SetColumnError(unitsInStockColumn, "주문 단위보다 큽니다." );

gridView.SetColumnError(unitsOnOrderColumn, "재고 단위보다 작습니다.");

}

#endregion

#region 그리드 뷰 무효 행 예외 처리하기 - gridView_InvalidRowException(sender, e)

/// <summary>

/// 그리드 뷰 무효 행 예외 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void gridView_InvalidRowException(object sender, InvalidRowExceptionEventArgs e)

{

e.ExceptionMode = ExceptionMode.DisplayError;

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] GridView 클래스 : ValidatingEditor 이벤트를 사용해 에디터 값 검증하기

■ GridView 클래스의 ValidatingEditor 이벤트를 사용해 에디터 값을 검증하는 방법을 보여준다. ▶ MainForm.cs


using System;
using System.Data.OleDb;

using DevExpress.Utils;
using DevExpress.XtraEditors;
using DevExpress.XtraEditors.Controls;
using DevExpress.XtraGrid.Columns;
using DevExpress.XtraGrid.Views.Grid;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Field
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region Field

        /// <summary>
        /// 연결
        /// </summary>
        private OleDbConnection connection;

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            this.connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb");

            this.gridView.InitializeView
            (
                true,                           // Multi Select
                GridMultiSelectMode.CellSelect, // Grid Multi Select Mode
                DrawFocusRectStyle.CellFocus,   // Draw Focus Rect Style
                true,                           // Show Indicator
                true,                           // Show Column Headers
                true,                           // Allow Column Moving
                true,                           // Allow Column Resizing
                true,                           // Allow Filter
                true,                           // Allow Sort
                false,                          // Allow Cell Merge
                EditorShowMode.Default,         // Editor Show Mode
                true                            // Editable
            );

            this.gridView.OptionsBehavior.AutoPopulateColumns = true;

            this.gridControl.DataSource = Product.GetProductList(this.connection);

            this.gridView.BestFitColumns();

            this.gridView.ValidatingEditor      += gridView_ValidatingEditor;
            this.gridView.InvalidValueException += gridView_InvalidValueException;
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region 그리드 뷰 에디터 값 검증하기 - gridView_ValidatingEditor(sender, e)

        /// <summary>
        /// 그리드 뷰 에디터 값 검증하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void gridView_ValidatingEditor(object sender, BaseContainerValidateEditorEventArgs e)
        {
            GridView view = sender as GridView;

            GridColumn column = (e as EditFormValidateEditorEventArgs)?.Column ?? view.FocusedColumn;

            if(column.FieldName != "UnitPrice")
            {
                return;
            }

            if((Convert.ToInt32(e.Value) < 0) || (Convert.ToInt32(e.Value) > 1000))
            {
                e.Valid = false;
            }
        }

        #endregion
        #region 그리드 뷰 무효 값 예외 처리하기 - gridView_InvalidValueException(sender, e)

        /// <summary>
        /// 그리드 뷰 무효 값 예외 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void gridView_InvalidValueException(object sender, InvalidValueExceptionEventArgs e)
        {
            GridView gridView = sender as GridView;

            e.ExceptionMode = ExceptionMode.DisplayError;
            e.WindowCaption = "입력 에러";
            e.ErrorText     = "값은 0 이상 1000 이하여야 합니다.";

            gridView.HideEditor();
        }

        #endregion
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

using System;

using System.Data.OleDb;

using DevExpress.Utils;

using DevExpress.XtraEditors;

using DevExpress.XtraEditors.Controls;

using DevExpress.XtraGrid.Columns;

using DevExpress.XtraGrid.Views.Grid;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Field

////////////////////////////////////////////////////////////////////////////////////////// Private

#region Field

/// <summary>

/// 연결

/// </summary>

private OleDbConnection connection;

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

this.connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb");

this.gridView.InitializeView

(

true, // Multi Select

GridMultiSelectMode.CellSelect, // Grid Multi Select Mode

DrawFocusRectStyle.CellFocus, // Draw Focus Rect Style

true, // Show Indicator

true, // Show Column Headers

true, // Allow Column Moving

true, // Allow Column Resizing

true, // Allow Filter

true, // Allow Sort

false, // Allow Cell Merge

EditorShowMode.Default, // Editor Show Mode

true // Editable

);

this.gridView.OptionsBehavior.AutoPopulateColumns = true;

this.gridControl.DataSource = Product.GetProductList(this.connection);

this.gridView.BestFitColumns();

this.gridView.ValidatingEditor += gridView_ValidatingEditor;

this.gridView.InvalidValueException += gridView_InvalidValueException;

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Private

#region 그리드 뷰 에디터 값 검증하기 - gridView_ValidatingEditor(sender, e)

/// <summary>

/// 그리드 뷰 에디터 값 검증하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void gridView_ValidatingEditor(object sender, BaseContainerValidateEditorEventArgs e)

{

GridView view = sender as GridView;

GridColumn column = (e as EditFormValidateEditorEventArgs)?.Column ?? view.FocusedColumn;

if(column.FieldName != "UnitPrice")

{

return;

}

if((Convert.ToInt32(e.Value) < 0) || (Convert.ToInt32(e.Value) > 1000))

{

e.Valid = false;

}

#endregion

#region 그리드 뷰 무효 값 예외 처리하기 - gridView_InvalidValueException(sender, e)

/// <summary>

/// 그리드 뷰 무효 값 예외 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void gridView_InvalidValueException(object sender, InvalidValueExceptionEventArgs e)

{

GridView gridView = sender as GridView;

e.ExceptionMode = ExceptionMode.DisplayError;

e.WindowCaption = "입력 에러";

e.ErrorText = "값은 0 이상 1000 이하여야 합니다.";

gridView.HideEditor();

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] GridView 클래스 : KeyPress 이벤트를 사용해 컬럼 내에서 입력되는 특정 문자 방지하기

■ GridView 클래스의 KeyPress 이벤트를 사용해 컬럼 내에서 입력되는 특정 문자를 방지하는 방법을 보여준다. ▶ MainForm.cs


using System.Data.OleDb;
using System.Windows.Forms;

using DevExpress.Utils;
using DevExpress.XtraEditors;
using DevExpress.XtraGrid;
using DevExpress.XtraGrid.Views.Grid;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Field
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region Field

        /// <summary>
        /// 연결
        /// </summary>
        private OleDbConnection connection;

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            this.connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb");

            this.gridView.InitializeView
            (
                true,                           // Multi Select
                GridMultiSelectMode.CellSelect, // Grid Multi Select Mode
                DrawFocusRectStyle.CellFocus,   // Draw Focus Rect Style
                true,                           // Show Indicator
                true,                           // Show Column Headers
                true,                           // Allow Column Moving
                true,                           // Allow Column Resizing
                true,                           // Allow Filter
                true,                           // Allow Sort
                false,                          // Allow Cell Merge
                EditorShowMode.Default,         // Editor Show Mode
                true                            // Editable
            );

            this.gridView.OptionsBehavior.AutoPopulateColumns = true;

            this.gridControl.DataSource = Customer.GetCustomerList(this.connection);

            this.gridView.BestFitColumns();

            this.gridControl.EditorKeyPress += gridControl_EditorKeyPress;
            this.gridView.KeyPress          += gridView_KeyPress;
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region 그리드 컨트롤 에디터 키 PRESS 처리하기 - gridControl_EditorKeyPress(sender, e)

        /// <summary>
        /// 그리드 컨트롤 에디터 키 PRESS 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void gridControl_EditorKeyPress(object sender, KeyPressEventArgs e)
        {
            GridControl gridControl = sender as GridControl;

            gridView_KeyPress(gridControl.FocusedView, e);
        }

        #endregion
        #region 그리드 뷰 키 PRESS 처리하기 - gridView_KeyPress(sender, e)

        /// <summary>
        /// 그리드 뷰 키 PRESS 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void gridView_KeyPress(object sender, KeyPressEventArgs e)
        {
            GridView gridView = sender as GridView;

            string s = "0123456789";

            if(gridView.FocusedColumn.FieldName == "CustomerID" && s.IndexOf(e.KeyChar) >= 0)
            {
                e.Handled = true;
            }
        }

        #endregion
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

using System.Data.OleDb;

using System.Windows.Forms;

using DevExpress.Utils;

using DevExpress.XtraEditors;

using DevExpress.XtraGrid;

using DevExpress.XtraGrid.Views.Grid;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Field

////////////////////////////////////////////////////////////////////////////////////////// Private

#region Field

/// <summary>

/// 연결

/// </summary>

private OleDbConnection connection;

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

this.connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb");

this.gridView.InitializeView

(

true, // Multi Select

GridMultiSelectMode.CellSelect, // Grid Multi Select Mode

DrawFocusRectStyle.CellFocus, // Draw Focus Rect Style

true, // Show Indicator

true, // Show Column Headers

true, // Allow Column Moving

true, // Allow Column Resizing

true, // Allow Filter

true, // Allow Sort

false, // Allow Cell Merge

EditorShowMode.Default, // Editor Show Mode

true // Editable

);

this.gridView.OptionsBehavior.AutoPopulateColumns = true;

this.gridControl.DataSource = Customer.GetCustomerList(this.connection);

this.gridView.BestFitColumns();

this.gridControl.EditorKeyPress += gridControl_EditorKeyPress;

this.gridView.KeyPress += gridView_KeyPress;

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Private

#region 그리드 컨트롤 에디터 키 PRESS 처리하기 - gridControl_EditorKeyPress(sender, e)

/// <summary>

/// 그리드 컨트롤 에디터 키 PRESS 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void gridControl_EditorKeyPress(object sender, KeyPressEventArgs e)

{

GridControl gridControl = sender as GridControl;

gridView_KeyPress(gridControl.FocusedView, e);

}

#endregion

#region 그리드 뷰 키 PRESS 처리하기 - gridView_KeyPress(sender, e)

/// <summary>

/// 그리드 뷰 키 PRESS 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void gridView_KeyPress(object sender, KeyPressEventArgs e)

{

GridView gridView = sender as GridView;

string s = "0123456789";

if(gridView.FocusedColumn.FieldName == "CustomerID" && s.IndexOf(e.KeyChar) >= 0)

{

e.Handled = true;

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] GridView 클래스 : EditingValue 속성을 사용해 현재 편집 값 구하기

■ GridView 클래스의 EditingValue 속성을 사용해 현재 편집 값을 구하는 방법을 보여준다. ▶ 예제 코드 (C#)


using DevExpress.XtraGrid;
using DevExpress.XtraGrid.Views.Grid;

...

private GridControl gridControl;

...

GridView gridView = this.gridControl.FocusedView as GridView;

string editingValue = null;

if(gridView.IsEditing)
{
    editingValue = gridView.EditingValue.ToString();
}

using DevExpress.XtraGrid;

using DevExpress.XtraGrid.Views.Grid;

...

private GridControl gridControl;

...

GridView gridView = this.gridControl.FocusedView as GridView;

string editingValue = null;

if(gridView.IsEditing)

{

editingValue = gridView.EditingValue.ToString();

}