How to easily set the selected index or value for DevExpress lookupedit

DevExpress lookupedit works similar to the .NET combobox but when you want to set the desire item within the lookupedit it is a bit different to the combox. In this example you learn how to set the selected index for the lookupedit. Pay attention to the highlighted line.
private void PopulatePlants()
{
    DataTable dtPlants = new DataTable();
 
    DbHelper db = new DbHelper();
    db.StoredProcedure = "dbo.prPlantsSelect";
    dtPlants = db.GetDataTable();
    db.Close();
    cbPlant.Properties.DisplayMember = "Description";
    cbPlant.Properties.ValueMember = "ID";
    cbPlant.Properties.DataSource = dtPlants;
 
    //Set the desire index after the lookup has been populated.
    cbPlant.EditValue = cbPlant.Properties.GetKeyValueByDisplayText("TheSelectedIndexYouWant");
}
 

Comments (6)

|78.38.191.xxx |2010-08-04 17:53:11 shahab - help

hi, it doesn't work!!!!!!
personLookUpEdit.EditValue = personLookUpEdit.Properties.GetDataSourceRowByKeyValue(2);
-------------
private void PersonLookUpEditBoxBind()
{
try
{
BindingSource _BindingSource;
DataSet _DataSet = new DataSet();
DataTable _DataTable = new PersonBLL().SelectLookUpEdit();
_DataTable.TableName = "PERSON";
_DataSet.Tables.Add(_DataTable);
_BindingSource = new BindingSource(_DataSet, "PERSON");
personLookUpEdit.DataBindings.Add("EditValue", _BindingSource, "PERSONID");

personLookUpEdit.Properties.DataSource = _BindingSource;
personLookUpEdit.Properties.DisplayMember = "FULLNAME";
personLookUpEdit.Properties.ValueMember = "PERSONID";
LookUpColumnInfoCollection _LookUpColumnInfoCollection = personLookUpEdit.Pr...

|210.8.191.xxx |2010-08-06 02:33:48 admin

Have you check to make sure that it returns the correct data? because it works for me.

|125.17.228.xxx |2011-02-14 06:20:54 jayaram - set selected item lookupedit

you should be passing in the text as it appears in the drop down instead of the index to GetKeyValueByDisplayText function

|117.201.0.xxx |2011-07-22 04:42:46 Ganesh

hi

thanks dude it works fine...

am looking for this code for long time.

nice work...

|190.4.63.xxx |2011-08-24 16:38:40 Nelson - Another way

If want to set according to da value member

cbPlant.ItemIndex = cbPlant.Properties.GetDataSourceRowIndex("FIELD_ID", vFieldId);

|27.33.185.xxx |2011-12-02 22:16:04 Nahum Reyes

This is the code that i was looking for!!!
It´s Great!!

You´re the Maximus brother !!! :0

< Prev		Next >