
private void Form1_Load(object sender, System.EventArgs e)
{
propertyGrid1.SelectedObject = lookUpEdit1.Properties;
pnlHint.Caption = "This demo demonstrates how to use a DataView as a data source for a Lookup editor.";
DevExpress.Utils.LookAndFeelMenu menu = new DevExpress.Utils.LookAndFeelMenu(this, defaultLookAndFeel1, "XtraEditors: LookUp Edit (Data Binding) by Developer Express inc.");
InitData();
InitLookUp();
}
DataView dvMain, dvProducts;

private void InitData()
{
string DBFileName = DevExpress.Utils.FilesHelper.FindingFileName(Application.StartupPath, "Data\\nwind.mdb");

if(DBFileName != "")
{
DataSet ds = new DataSet();
string con = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + DBFileName;
System.Data.OleDb.OleDbDataAdapter dbAdapter = new System.Data.OleDb.OleDbDataAdapter("SELECT * FROM [Order Details]", con);
dbAdapter.Fill(ds, "Order Details");
dbAdapter = new System.Data.OleDb.OleDbDataAdapter("SELECT * FROM Products", con);
dbAdapter.Fill(ds, "Products");
DataViewManager dvm = new DataViewManager(ds);
dvMain = dvm.CreateDataView(ds.Tables["Order Details"]);
dvProducts = dvm.CreateDataView(ds.Tables["Products"]);
}
}

private void InitLookUp()
{
lookUpEdit1.DataBindings.Add("EditValue", dvMain, "ProductID");
lookUpEdit1.Properties.DataSource = dvProducts;
dataNavigator1.DataSource = dvMain;
}
}