[C#/WINFORM/DEVEXPRESS] GridView 클래스 : PopupMenuShowing 이벤트를 사용해 컬럼 메뉴 항목 설정하기

■ GridView 클래스의 PopupMenuShowing 이벤트를 사용해 컬럼 메뉴 항목을 설정하는 방법을 보여준다.

▶ MainForm.cs


using System;
using System.Data.OleDb;

using DevExpress.Utils;
using DevExpress.Utils.Menu;
using DevExpress.XtraEditors;
using DevExpress.XtraGrid.Localization;
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.gridView.OptionsMenu.EnableColumnMenu = true;

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

            this.gridView.BestFitColumns();

            this.gridView.PopupMenuShowing += gridView_PopupMenuShowing;
        }

        #endregion

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

        #region 그리드 뷰 팝업 메뉴 표시시 처리하기 - gridView_PopupMenuShowing(sender, e)

        /// <summary>
        /// 그리드 뷰 팝업 메뉴 표시시 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void gridView_PopupMenuShowing(object sender, PopupMenuShowingEventArgs e)
        {
            if(e.MenuType == GridMenuType.Column)
            {
                string sortAscendingString  = "A to Z";
                string sortDescendingString = "Z to A";

                if(e.HitInfo.Column.ColumnType == typeof(DateTime))
                {
                    sortAscendingString  = "Old to New";
                    sortDescendingString = "New to Old";
                }

                DXMenuItem sortAscendingMenuItem = e.Menu.Find(GridStringId.MenuColumnSortAscending); // "Sort Ascending"

                if(sortAscendingMenuItem != null)
                {
                    sortAscendingMenuItem.Caption = sortAscendingString;
                }

                DXMenuItem sortDescendingMenuItem = e.Menu.Find(GridStringId.MenuColumnSortDescending); // "Sort Descending"

                if(sortDescendingMenuItem != null)
                {
                    sortDescendingMenuItem.Caption = sortDescendingString;
                }

                e.Menu.Hide(GridStringId.MenuFooterHide             ); // "Hide Footer"
                e.Menu.Hide(GridStringId.MenuColumnFilterEditor     ); // "Filter Editor..."
                e.Menu.Hide(GridStringId.MenuColumnFindFilterShow   ); // "Show Find Panel"
                e.Menu.Hide(GridStringId.MenuColumnFindFilterHide   ); // "Hide Find Panel"
                e.Menu.Hide(GridStringId.MenuColumnAutoFilterRowHide); // "Hide Auto Filter Row"
                e.Menu.Hide(GridStringId.MenuColumnAutoFilterRowShow); // "Show Auto Filter Row"

                DXMenuItem bestFitMenuItem = e.Menu.Find(GridStringId.MenuColumnBestFit); // "Best Fit"

                if(bestFitMenuItem != null)
                {
                    bestFitMenuItem.Enabled = false;
                }

                DXMenuItem bestFitAllColumnsMenuItem = e.Menu.Find(GridStringId.MenuColumnBestFitAllColumns); // "Best Fit All Columns"

                if(bestFitAllColumnsMenuItem != null)
                {
                    bestFitAllColumnsMenuItem.Enabled = false;
                }
            }
        }

        #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

using System;

using System.Data.OleDb;

using DevExpress.Utils;

using DevExpress.Utils.Menu;

using DevExpress.XtraEditors;

using DevExpress.XtraGrid.Localization;

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.gridView.OptionsMenu.EnableColumnMenu = true;

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

this.gridView.BestFitColumns();

this.gridView.PopupMenuShowing += gridView_PopupMenuShowing;

}

#endregion

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

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

#region 그리드 뷰 팝업 메뉴 표시시 처리하기 - gridView_PopupMenuShowing(sender, e)

/// <summary>

/// 그리드 뷰 팝업 메뉴 표시시 처리하기

/// </summary>

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

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

private void gridView_PopupMenuShowing(object sender, PopupMenuShowingEventArgs e)

{

if(e.MenuType == GridMenuType.Column)

{

string sortAscendingString = "A to Z";

string sortDescendingString = "Z to A";

if(e.HitInfo.Column.ColumnType == typeof(DateTime))

{

sortAscendingString = "Old to New";

sortDescendingString = "New to Old";

}

DXMenuItem sortAscendingMenuItem = e.Menu.Find(GridStringId.MenuColumnSortAscending); // "Sort Ascending"

if(sortAscendingMenuItem != null)

{

sortAscendingMenuItem.Caption = sortAscendingString;

}

DXMenuItem sortDescendingMenuItem = e.Menu.Find(GridStringId.MenuColumnSortDescending); // "Sort Descending"

if(sortDescendingMenuItem != null)

{

sortDescendingMenuItem.Caption = sortDescendingString;

}

e.Menu.Hide(GridStringId.MenuFooterHide ); // "Hide Footer"

e.Menu.Hide(GridStringId.MenuColumnFilterEditor ); // "Filter Editor..."

e.Menu.Hide(GridStringId.MenuColumnFindFilterShow ); // "Show Find Panel"

e.Menu.Hide(GridStringId.MenuColumnFindFilterHide ); // "Hide Find Panel"

e.Menu.Hide(GridStringId.MenuColumnAutoFilterRowHide); // "Hide Auto Filter Row"

e.Menu.Hide(GridStringId.MenuColumnAutoFilterRowShow); // "Show Auto Filter Row"

DXMenuItem bestFitMenuItem = e.Menu.Find(GridStringId.MenuColumnBestFit); // "Best Fit"

if(bestFitMenuItem != null)

{

bestFitMenuItem.Enabled = false;

}

DXMenuItem bestFitAllColumnsMenuItem = e.Menu.Find(GridStringId.MenuColumnBestFitAllColumns); // "Best Fit All Columns"

if(bestFitAllColumnsMenuItem != null)

{

bestFitAllColumnsMenuItem.Enabled = false;

}

#endregion

}

TestProject.zip