The current code i am using to try and get this data is
private void LoadDataToCbo()Any help will be appreciated.
{
string connString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=EmployeeInformation.accdb";
// string query = @"SELECT FirstName from Employees";
string query =
@"SELECT EmpID, LastName + ', ' + FirstName + ' (' + EmployeePosition + ')' as Name FROM Employees";
OleDbDataAdapter dAdapter = new OleDbDataAdapter(query, connString);
DataTable source = new DataTable();
dAdapter.Fill(source);
cboSelectEmp.DataSource = source;
//cboSelectEmp.ValueMember = "FirstName";
//cboSelectEmp.DisplayMember = "FirstName";
cboSelectEmp.DisplayMember = "Name";
cboSelectEmp.ValueMember = "EmpID";
}
Pravesh Singh
12-Dec-2013