Setting DataPropertyName in DataGridViewComboBoxColumn from BindingSource

Question

I have a problem with setting a correct data property for DataPropertyName of DataGridViewComboBoxColumn. I have a BindingSource and I set its DataSource to BindingList of custom objects. These objects have properties which I'd like to assign as columns in DataGridView (pluginsDataGrid):

var source = new BindingSource {DataSource = _plugins};
pluginsDataGrid.AutoGenerateColumns = false;
pluginsDataGrid.DataSource = source;

Everything's fine when I have a simple string as a property - it is Name:

 using (var nameCol = new DataGridViewTextBoxColumn())
 {
      nameCol.DataPropertyName = "Name";
      nameCol.Name = "Name";
      pluginsDataGrid.Columns.Add(nameCol);
 }

but I don't know how to set DataGridViewComboBoxColumn options. I gave it a try this way:

using (var depCol = new DataGridViewComboBoxColumn())
{
    depCol.DataPropertyName = "Dependencies";
    depCol.Name = "Dependencies";
    pluginsDataGrid.Columns.Add(depCol);
}

where Dependencies is a list of strings. But it is not working. What kind of property should be assign to it?

realnero realnero · Accepted Answer · 2014-01-12T13:31:17

You need to specify DataSource for the column, example:

        comboboxColumn.DataSource = collection;
        comboboxColumn.ValueMember = ColumnName;
        comboboxColumn.DisplayMember = ValueMember;

In your case use DataBindingComplete event to psecify collection:

void dataGridView1_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
    for (int i = 0; i < dataGridView1.Rows.Count; i++)
    {
        DataGridViewComboBoxCell comboCell = (DataGridViewComboBoxCell)dataGridView1.Rows[i].Cells["Dependencies"];
        [Plugin_Type] entry = dataGridView1.Rows[i].DataBoundItem as [Plugin_Type];

        comboCell.DataSource = entry.[YOUR_PROPERTY];
    }
}

Setting DataPropertyName in DataGridViewComboBoxColumn from BindingSource

1 Answers