1-) C# DEVEXPRESS RMOS - lookUpEdit1 sinifi

NOT LOOKUPEDİT YERİNE SEARCHLOOKUPEDİT KULLANİRSAN AUTOFİLTER İ CONTAİNS YANİ İÇİNDE ARAMA YAPABİLİRSİN.

lookUpEdit1 -> DESİGNERDAN COLUMN EKLE

lookUpEdit1.Properties.DataSource = RHVeritabani.MyGetDataTable("select id,ad from u_arizaistekcinsleri");

lookUpEdit1.Properties.DisplayMember = "ad";

lookUpEdit1.Properties.ValueMember = "id";

seçmek için

 lookArizaCinsi.EditValue = 3; // dikkat veritabanında ne ise öyle seç ValueMember int ise int ata string ise string

                    lookAlanAdi.EditValue = Convert.ToInt32(gridView2.GetRowCellValue(gridView2.FocusedRowHandle, gridView2.Columns["uAlanTan_id"]).ToString());

DİSPLAYMEMBER DAN SEÇMEK İÇİN ARKA PLANI SARI YAPMAZ

 lookAnaAlanAdi.EditValue = lookAnaAlanAdi.Properties.GetKeyValueByDisplayValue(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, gridView1.Columns["uTeknikArizalar_anaAlan"]).ToString());

AŞAĞISINI BOŞVER

1-) LookUpEdit lookupedit sinifi kullanımı

MyLibrary.MyAddLookUpEdit("id","ad", "select id,ad from u_arizaistekcinsleri", ref lookUpEdit1);

MessageBox.Show(lookUpEdit1.EditValue.ToString()); // id sini döner

2-) aşağıda sinif

using DevExpress.XtraEditors;

using System.Collections.Generic;

using System.Windows.Forms;

using System.Data;

namespace OrderTakerUltimate

{

    class MyLibrary

    {

        public static Dictionary<string, string> test;

        /// <summary>

        /// sorguda sadece id,ad içersin

        /// </summary>

        /// <param name="pSQLSorgu"></param>

        /// <param name="pComboboxEdit"></param>

        public static void MyAddLookUpEdit(string Id, string Ad, string pSQLSorgu, ref LookUpEdit pLookUpEdit)

        {

            pLookUpEdit.Properties.Columns.Clear();

            test = new Dictionary<string, string>();

            pLookUpEdit.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("Key"));

            pLookUpEdit.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("Value"));

            DataTable dt = RHVeritabani.MyGetDataTable(pSQLSorgu);

            if (dt != null)

            {

                foreach (DataRow item in dt.Rows)

                {

                    test.Add(item[Id].ToString(), item[Ad].ToString());

                }

                pLookUpEdit.Properties.DataSource = new BindingSource(test, null);

                pLookUpEdit.Properties.DisplayMember = "Value";

                pLookUpEdit.Properties.ValueMember = "Key";

                pLookUpEdit.Properties.Columns[pLookUpEdit.Properties.ValueMember].Visible = false;

                pLookUpEdit.Properties.Columns[pLookUpEdit.Properties.DisplayMember].Caption = "Ad";

                pLookUpEdit.ItemIndex = 0;

            }

            else

            {

                pLookUpEdit.EditValue = "";

                pLookUpEdit.Text = "";

                pLookUpEdit.Properties.NullText = "";

            }

        }

    }

}