Adding databound ComboBox into cells of a DataGridView

[Dewald]

I have a DataGridView on a form which is populated through databinding from a table in my database. I've followed, more or less, the process outlined on this MSDN page[^] I've implemented the databinding both ways so that, by clicking on an "Update" button, the changes that have been made on the DataGridView is stored back into the DB. All works well, but... Imagine the table used for the databinding being something like this:

USERS

• UserID (INT)
• UserName (VARCHAR)
• UserType (INT)

And here's the problem, that UserType field references the identifier in a separate table like this one:

USERTYPES

• UserType (INT)
• UserTypeDescription (VARCHAR)

Currently, my databinding is done with a simple query like this:

SELECT * FROM USERS;

The problem is that the value displayed in the third column is an integer which means nothing to the end user. If I wasn't interested in two way databinding but only wanted to display the contents of the table in the DataGridView I could easily have overcome that problem by using the following query:

SELECT UserID, UserName, UserTypeDescription FROM USERS INNER JOIN USERTYPES ON USERS.UserType = USERTYPES.UserType;

Unfortunately I need for the end user to be able to change that value and I'd like to put a ComboBox in all the cells of that column which is populated from the USERTYPES table. Would really appreciate some advice. ***EDIT*** Maybe I should add that I have some experience with adding a ComboBox (rather a DataGridViewComboBoxCell) in a DataGridView but that has always been to DataGridViews that have not been databound to a table. Here's how I would've done that:

private void myDataGridView_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
for (int row = 0; row < (sender as DataGridView).Rows.Count; row++)
{
// Create a new DataGridViewComboBoxCell that will replace the existing UserType cell in the relevant column
DataGridViewComboBoxCell newCell = new DataGridViewComboBoxCell();

    // Populate the DataSource of the combo box
    using (SqlCommand sqlCommand = new SqlCommand("SELECT UserType, UserDescription FROM UserTypes", mySQLConnection))
    {
        using (SqlDataReader sqlData