public static void SetFillCode(DevExpress.XtraEditors.LookUpEdit lookup, System.Data.DataTable dtSource, string DisplayMember, string ValueMember, CaptoinStyle style, int AutoSearchColumnIndex) { try { DataTable dt = dtSource.Clone(); DataRow r = dt.NewRow(); if (style == CaptoinStyle.NullString) { r[ValueMember] = ""; r[DisplayMember] = ""; dt.Rows.Add(r); } else if (style == CaptoinStyle.SelectText) { r[ValueMember] = ""; r[DisplayMember] = "선택하세요"; dt.Rows.Add(r); } dt.Load(dtSource.CreateDataReader()); lookup.Properties.SearchMode = DevExpress.XtraEditors.Controls.SearchMode.AutoComplete; lookup.Properties.DataSource = dt; lookup.Properties.DisplayMember = DisplayMember; lookup.Properties.ValueMember = ValueMember; lookup.Properties.AutoSearchColumnIndex = AutoSearchColumnIndex; if (dt.Rows.Count > 0) { lookup.EditValue = dt.Rows[0][ValueMember].ToString(); } } catch (Exception ex) { throw ex; } }
/// <summary> /// 룩업컨트롤에 기초 데이터를 바인딩 합니다. /// </summary> /// <param name="lookup">룩업컨트롤.</param> /// <param name="dtSource">데이터 테이블</param> /// <param name="DisplayMember">룩업에 출력될 문자열 값 입니다.</param> /// <param name="ValueMember">룩업에 바인되는 값 입니다.</param> /// <param name="style">컨트롤 초기텍스트 스타일 입니다..</param> /// <example> /// <code> /// LookUp.SetFillCode(this.lupCustType, /// ds.Tables[0], /// "CUST_TYPE_NAME", /// "CUST_TYPE_CODE", /// LookUp.CaptoinStyle.SelectText /// ); /// </code>^ /// </example> public static void SetFillCode(DevExpress.XtraEditors.LookUpEdit lookup, System.Data.DataTable dtSource, string DisplayMember, string ValueMember, CaptoinStyle style) { try { System.Data.DataTable dt = new System.Data.DataTable(); dt.Columns.Add("코드"); dt.Columns.Add("코드명"); if (style == CaptoinStyle.NullString) { dt.Rows.Add(new object[] { "", "" }); } else if (style == CaptoinStyle.SelectText) { dt.Rows.Add(new object[] { "", "선택하세요" }); } foreach (System.Data.DataRow r in dtSource.Rows) { dt.Rows.Add(new object[] { r[ValueMember].ToString().Trim(), r[DisplayMember].ToString().Trim() }); } lookup.Properties.SearchMode = DevExpress.XtraEditors.Controls.SearchMode.AutoComplete; lookup.Properties.DataSource = dt; lookup.Properties.DisplayMember = "코드명"; lookup.Properties.ValueMember = "코드"; lookup.Properties.AutoSearchColumnIndex = 0; lookup.EditValue = ""; } catch (Exception ex) { throw ex; } }