forum

Home / DeveloperSection / Forums / How to retrieve certain data from Access Database and display them in a combobox

How to retrieve certain data from Access Database and display them in a combobox

Anonymous User 2086 12-Dec-2013

The current code i am using to try and get this data is

private void LoadDataToCbo()
    {
        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";
    }
Any help will be appreciated.

c# c# 
Updated on 12-Dec-2013
I am a content writter !

Can you answer this question?


Answer

1 Answers

Liked By