Выпадающий список в ячейках DataGridView

 
        MySqlConnection myConnection = new MySqlConnection();
        MySqlDataAdapter DateAdapter;
        DataSet myDataSet = new DataSet();
 
public void UpdateTable()
        {
           
            myConnection.ConnectionString = "Database=test;Data Source=localhost;User Id=root;Password=123";
            myConnection.Open();
            DateAdapter = new MySqlDataAdapter("SELECT journal.Id,journal.Date,journal.defect,subdivision.name,journal.mark,journal.iduser "+
                                                                        "FROM journal LEFT OUTER JOIN subdivision ON journal.idsubdivision = subdivision.Id", myConnection);
            DateAdapter.Fill(myDataSet);
            if (myDataSet.Tables.Count > 0)
             dataGridView1.DataSource = myDataSet.Tables[0];
             DataGridViewComboBoxColumn comboboxColumn;
             DataGridViewComboBoxColumn column = new DataGridViewComboBoxColumn();
             comboboxColumn = column;
             SetAlternateChoicesUsingDataSource(comboboxColumn);
             dataGridView1.Columns.Insert(3, comboboxColumn);
      myConnection.Close();
 
private void SetAlternateChoicesUsingDataSource(DataGridViewComboBoxColumn comboboxColumn)
        {
            {
                comboboxColumn.DataSource = RetrieveAlternativeTitles();
                comboboxColumn.ValueMember = ColumnName.Subdivision.ToString();
                comboboxColumn.DisplayMember = comboboxColumn.ValueMember;
            }
        }
 
        private DataTable RetrieveAlternativeTitles()
        {
            return Subdivision("SELECT subdivision.name FROM subdivision");
        }
 
        private DataTable Subdivision(string sqlCommand)
        {
 
            MySqlCommand command = new MySqlCommand(sqlCommand, myConnection);
            MySqlDataAdapter adapter = new MySqlDataAdapter();
            adapter.SelectCommand = command;
 
            DataTable table = new DataTable();
            table.Locale = System.Globalization.CultureInfo.InvariantCulture;
            adapter.Fill(table);
 
            return table;
        }