How to change list of items inside DataGridViewComboBoxCell

Hello,
I am writing simple application that uses DataGridView control with ComboBoxColumn.

I have used this method to change list of items inside one cell of ComboBoxColumn :

void Fill_Location()
{
DataGridViewComboBoxCell Location =
(DataGridViewComboBoxCell) DGV.Rows[0].Cells[1];
Location.Items.Clear();
string a ="hello";
Location.Items.Add(a);
}

When executed this method raises DataGridView Default Error Dialog with message:

The following exception occurred in the DataGridView
System.ArgumentException : DataGridViewComboBoxCell value is not valid.
To replace this default dialog please handle the DataError event.

So I have assigned to DGV this DataError event handler :

void DGV_DataError(object sender, DataGridViewDataErrorEventArgs e)
{
MessageBox.Show(e.Context.ToString());
}

After that when executed method raises DataGridView DataError event handler with following message : Formatting, PreferredSize.

Since that I do not know how to resolve above error,
I have changed code for DataError event handler to :

void DGV_DataError(object sender, DataGridViewDataErrorEventArgs e)
{
if(e.Context== DataGridViewDataErrorContexts.Formatting)
e.ThrowException = false;
}

Now when executing method Fill_Location() list of items inside ComboBoxCell is changed as expected, and there is no any error message.

Is this correct use of DataError event handler for resolving this kind of problem,
or there can be some other hidden problems that currently are not evident ?

Program is written for .Net 4.0

All the best,
Željko Peric

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Gajendra Jangid7y ago
Accepted answer
1. DataGridViewComboBoxColumn colType = new DataGridViewComboBoxColumn();
2. colType.HeaderText = "Type";
3. colType.DropDownWidth = 90;
4. colType.Width = 90;
5. colType.MaxDropDownItems = 5;
6. this.dataGridView1.Columns.Insert(7, colType);
7. colType.Items.AddRange("A", "N", "P", "S", "Z");
8. this.dataGridView1.Columns[7].DataPropertyName = "trans_type";