var dbPath = Application.StartupPath + @"\Kantar.mdb";
var con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + dbPath);
// Create a data adapter.
var da = new OleDbDataAdapter("SELECT Id,Yer,Km FROM TestFirmaYer where FirmaId=" + p, con);
// Create and fill a dataset.
var ds = new DataSet();
da.Fill(ds, "TestFirmaYer");
lookUpEditGidecegiYer.Properties.DataSource = ds.Tables[0]; //q.ToList();
lookUpEditGidecegiYer.Properties.ValueMember = "Id";
lookUpEditGidecegiYer.Properties.DisplayMember = "Yer";
lookUpEditGidecegiYer.Properties.NullText = @"<Lütfen Yer Seçiniz>";
lookUpEditGidecegiYer.Properties.BestFitMode = BestFitMode.BestFitResizePopup;
lookUpEditGidecegiYer.Properties.SearchMode = SearchMode.AutoComplete;
lookUpEditGidecegiYer.Properties.AutoSearchColumnIndex = 1;