---
title: "How to retrieve certain data from Access Database and display them in a combobox"  
description: "How to retrieve certain data from Access Database and display them in a combobox"  
author: "Anonymous User"  
published: 2013-12-12  
updated: 2013-12-12  
canonical: https://www.mindstick.com/forum/1764/how-to-retrieve-certain-data-from-access-database-and-display-them-in-a-combobox  
category: "c#"  
tags: ["c#"]  
reading_time: 1 minute  

---

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

The current [code](https://yourviews.mindstick.com/view/85458/alan-turing-the-mastermind-behind-cracking-the-enigma-code-during-world-war-ii) i am using to try and get this [data](https://www.mindstick.com/articles/13050/salesforce-aiming-to-dominate-predictive-analytics-with-data-science) 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.

## Replies

### Reply by Pravesh Singh

Hi Goti,\
\

```
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";}
```


---

Original Source: https://www.mindstick.com/forum/1764/how-to-retrieve-certain-data-from-access-database-and-display-them-in-a-combobox

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.