Set datagridview column to combobox.

Question

I am working on a C# application that opens a table in a datagridview when a specific string is passed. I am trying to set certain columns' styles as comboboxes (Ex, datagridview.Columns[3] = ComboBox). I can not figure out the code to do this.

theLizard · Answer

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!)

Vulpes · Answer

Well to the best of my knowledege there's no way to convert a textbox column into a combobox column as they're different classes. All you can do is to insert one and remove the other after copying over any content you want to keep.

Andrew Fannin · Answer

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).

Suthish Nair · Answer

thread resolved?

Vulpes · Answer

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.

Andrew Fannin · Answer

I am loading database tables into the datagridview dynamically so I cannot modify these settings in the designer since it does not have one bound source.

Vulpes · Answer

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.