How do I load a combo box with data from one column in an access database?

See more:

C#

MS-Access

combobox

database

, +

<c#>
I have very little experience with programming but I have to create a windows form application with multiple forms. On one of the forms I need to make use of information from an access database. I have an access database with two tables. One table is called Student.

The student table has four columns:
student number
student name
student email
student address

I need to make use of the student name column. It has ten records. I need to load the ten names into a combo box. Once the user selects a name from the combo box, the other details from the table will be displayed in various textboxes on the form. I'm having trouble loading the names into the combo box. The names need to be loaded into the combo box at the start of the program. If I'm going to use the names to load other information do I load the dataset into an array or do I load them directly into the combo box?

Any help or ideas will be very appreciated.

What I have tried:

I have tried to create a student class and then use it like this:

Student aStudent = new Student //the new Student part threw out an error
(dbReader["StudentName"].ToString());
this.cmbStudents.Items.Add(aStudent);