Okay, I have a DataGridView in my winform app, and it loads the schema and data as follows:

Code:
DataSet dsClasses;
SqlDataAdapter daClasses;

// Load the Classes table in the adapter
dsClasses = new DataSet("Classes");
daClasses = new SqlDataAdapter("Select ClassID, StudentID From Classes ", Connection);
daClasses.FillSchema(dsClasses, SchemaType.Source, "Classes");
daClasses.Fill(dsClasses, "Classes");

dgvMain.DataSource = dsClasses.Tables["Classes"];
This sets up the DataGridView perfectly, except that the class and student display and have to be entered by number, i.e. their respective ID values. (It's just a basic intersection table, showing which students are enrolled in which courses.) What I WANT are combobox controls that bind to the ID fields in the Classes table, but DISPLAY the corresponding names from the student and course tables. Haven't yet determined how to do that, and would appreciate any help.

I use VS 2010 with .NET 4 under Windows 7. Thanks in advance for any help.