Set datagridview column to combobox.

If you are loading dynamically, you should be able to do it here (I think you will get a value change when you assign a field value to the cell)



  private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e)
  {
  if (e.RowIndex == -1)
  return;

  string s = "SELECT field FROM table WHERE field = '" + dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString() + ""';

//this is where you would load your combo box from another table

  DataGridViewComboBoxCell newCb = new DataGridViewComboBoxCell();
  //do your load loop here  

  // newCb.Items.Add(s);

  dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex] = newCb;


  }

I have tested it manually, it replaces the current cell with a combo box cell and has the value of the original cell text in the items list.

There is always a way of doing things...

Edit: You could also do this when you load the grid from your database in your loop when adding rows (I assume you are doing this!)

This does create comboboxes, however it clears out the previous data for that column.  The reason I am wanting to do this is so that I can specify a value member and display member (ex, when a value in this column is 8, I do not want it to show 8, but get the meaning of that value from a different table and display text for it).

To do this from code, you'd need to do something like this:


int index = 3; // or whatever


// create new combobox column
DataGridViewComboBoxColumn newCol = new DataGridViewComboBoxColumn();


dataGridView1.Columns.Insert(index, newCol); // insert at the appropriate place


// copy over any properties from existing column now at index + 1
dataGridView1.Columns[index].HeaderText = dataGridView1.Columns[index + 1].HeaderText;
// copy other relevant properties


// remove existing column
dataGridView1.Columns.RemoveAt(index + 1);




You can't set dataGridView1.Columns[3] directly because it's read only.

It's best to do this from the VS designer.

Check out this link (http://msdn.microsoft.com/en-us/library/053656ss.aspx) for instructions on how to do it.