[C#/WINFORM/DEVEXPRESS] GridLookUpEdit 클래스 : 실행시 생성하기

■ GridLookUpEdit 클래스에서 실행시 생성하는 방법을 보여준다.

▶ MainForm.cs


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

using DevExpress.XtraEditors;
using DevExpress.XtraGrid.Columns;

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

        #region Field

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

        /// <summary>
        /// 제품 뷰
        /// </summary>
        private DataView productView;

        /// <summary>
        /// 주문 상세 뷰
        /// </summary>
        private DataView orderDetailView;

        /// <summary>
        /// 그리드 룩업 에디트
        /// </summary>
        private GridLookUpEdit gridLookUpEdit;

        /// <summary>
        /// 데이터 네비게이터
        /// </summary>
        private DataNavigator dataNavigator;

        #endregion

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

        #region 생성자 - MainForm()

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

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

            #region 데이터를 설정한다.

            DataSet dataSet = new DataSet();

            OleDbDataAdapter adapter = new OleDbDataAdapter("SELECT * FROM Products", this.connection);

            adapter.Fill(dataSet, "Products");

            adapter = new OleDbDataAdapter("SELECT * FROM [Order Details]", this.connection);

            adapter.Fill(dataSet, "Order Details");

            DataViewManager dataViewManager = new DataViewManager(dataSet);

            this.productView     = dataViewManager.CreateDataView(dataSet.Tables["Products"     ]);
            this.orderDetailView = dataViewManager.CreateDataView(dataSet.Tables["Order Details"]);

            #endregion
            #region 데이터 네비게이터를 설정한다.

            this.dataNavigator = new DataNavigator();

            this.dataNavigator.Bounds = new Rectangle(50, 100, 300, 24);
            this.dataNavigator.Parent = this;

            this.dataNavigator.DataSource = orderDetailView;

            #endregion
            #region 그리드 룩업 에디터를 설정한다.

            this.gridLookUpEdit = new GridLookUpEdit();

            this.gridLookUpEdit.Bounds = new Rectangle(50, 150, 300, 22);
            this.gridLookUpEdit.Parent = this;

            this.gridLookUpEdit.Properties.PopupView.OptionsBehavior.AutoPopulateColumns = false;
            this.gridLookUpEdit.Properties.ValueMember                                   = "ProductID";
            this.gridLookUpEdit.Properties.DisplayMember                                 = "ProductName";
            this.gridLookUpEdit.Properties.DataSource                                    = productView;

            GridColumn productIDColumn = this.gridLookUpEdit.Properties.PopupView.Columns.AddField("ProductID");

            productIDColumn.VisibleIndex = 0;
            productIDColumn.Caption      = "Product ID";

            GridColumn productNameColumn = this.gridLookUpEdit.Properties.PopupView.Columns.AddField("ProductName");

            productNameColumn.VisibleIndex = 1;
            productNameColumn.Caption      = "Product Name";

            this.gridLookUpEdit.Properties.PopupFormWidth = 300;

            this.gridLookUpEdit.DataBindings.Add("EditValue", this.orderDetailView, "ProductID");

            #endregion
        }

        #endregion
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

using System.Data;

using System.Data.OleDb;

using System.Drawing;

using DevExpress.XtraEditors;

using DevExpress.XtraGrid.Columns;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

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

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

#region Field

/// <summary>

/// 연결

/// </summary>

private OleDbConnection connection;

/// <summary>

/// 제품 뷰

/// </summary>

private DataView productView;

/// <summary>

/// 주문 상세 뷰

/// </summary>

private DataView orderDetailView;

/// <summary>

/// 그리드 룩업 에디트

/// </summary>

private GridLookUpEdit gridLookUpEdit;

/// <summary>

/// 데이터 네비게이터

/// </summary>

private DataNavigator dataNavigator;

#endregion

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

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

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

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

#region 데이터를 설정한다.

DataSet dataSet = new DataSet();

OleDbDataAdapter adapter = new OleDbDataAdapter("SELECT * FROM Products", this.connection);

adapter.Fill(dataSet, "Products");

adapter = new OleDbDataAdapter("SELECT * FROM [Order Details]", this.connection);

adapter.Fill(dataSet, "Order Details");

DataViewManager dataViewManager = new DataViewManager(dataSet);

this.productView = dataViewManager.CreateDataView(dataSet.Tables["Products" ]);

this.orderDetailView = dataViewManager.CreateDataView(dataSet.Tables["Order Details"]);

#endregion

#region 데이터 네비게이터를 설정한다.

this.dataNavigator = new DataNavigator();

this.dataNavigator.Bounds = new Rectangle(50, 100, 300, 24);

this.dataNavigator.Parent = this;

this.dataNavigator.DataSource = orderDetailView;

#endregion

#region 그리드 룩업 에디터를 설정한다.

this.gridLookUpEdit = new GridLookUpEdit();

this.gridLookUpEdit.Bounds = new Rectangle(50, 150, 300, 22);

this.gridLookUpEdit.Parent = this;

this.gridLookUpEdit.Properties.PopupView.OptionsBehavior.AutoPopulateColumns = false;

this.gridLookUpEdit.Properties.ValueMember = "ProductID";

this.gridLookUpEdit.Properties.DisplayMember = "ProductName";

this.gridLookUpEdit.Properties.DataSource = productView;

GridColumn productIDColumn = this.gridLookUpEdit.Properties.PopupView.Columns.AddField("ProductID");

productIDColumn.VisibleIndex = 0;

productIDColumn.Caption = "Product ID";

GridColumn productNameColumn = this.gridLookUpEdit.Properties.PopupView.Columns.AddField("ProductName");

productNameColumn.VisibleIndex = 1;

productNameColumn.Caption = "Product Name";

this.gridLookUpEdit.Properties.PopupFormWidth = 300;

this.gridLookUpEdit.DataBindings.Add("EditValue", this.orderDetailView, "ProductID");

#endregion

}

#endregion

}

TestProject.zip