Home All Groups Group Topic Archive Search About

DataGridView Combobox column Error

Author
26 Jul 2006 10:30 AM
Greg
I've populated all the cells in a combo box column with values from 1 -
50 using the following code:

foreach (DataGridViewRow row in uxTabSummary.Rows)
{
      DataGridViewComboBoxCell cell = (DataGridViewComboBoxCell)
row.Cells["numRows"];
       for (int i = 1; i < 51; i++)
       {
            cell.Items.Add(i);
        }
  }

However, after the user changes a value in the drop down combo box, and
moves the focus to another cell, a "System.ArgumentException:
DataGridViewComboBoxCell value is not valid".

Googling shows an extensive number of people suffering the same, but
I'm none the wiser.

Is there a simple solution to this?

Greg.

Author
26 Jul 2006 12:20 PM
Brian Tkatch
Greg wrote:
Show quote
> I've populated all the cells in a combo box column with values from 1 -
> 50 using the following code:
>
>  foreach (DataGridViewRow row in uxTabSummary.Rows)
>  {
>       DataGridViewComboBoxCell cell = (DataGridViewComboBoxCell)
> row.Cells["numRows"];
>        for (int i = 1; i < 51; i++)
>        {
>             cell.Items.Add(i);
>         }
>   }
>
> However, after the user changes a value in the drop down combo box, and
> moves the focus to another cell, a "System.ArgumentException:
> DataGridViewComboBoxCell value is not valid".
>
> Googling shows an extensive number of people suffering the same, but
> I'm none the wiser.
>
> Is there a simple solution to this?
>
> Greg.

Perhaps you can try adding a DataTable to hold all those values for the
ComboBox, then setting the ComboBoxColumn.DataSource to the DataTable.
The ComboBoxColumn.ValueMember's data must be valid for the underlying
column in the DataGridView.

B.
Author
28 Jul 2006 8:51 AM
Greg
Great, thanks!

Brian Tkatch wrote:
Show quote
> Greg wrote:
> > I've populated all the cells in a combo box column with values from 1 -
> > 50 using the following code:
> >
> >  foreach (DataGridViewRow row in uxTabSummary.Rows)
> >  {
> >       DataGridViewComboBoxCell cell = (DataGridViewComboBoxCell)
> > row.Cells["numRows"];
> >        for (int i = 1; i < 51; i++)
> >        {
> >             cell.Items.Add(i);
> >         }
> >   }
> >
> > However, after the user changes a value in the drop down combo box, and
> > moves the focus to another cell, a "System.ArgumentException:
> > DataGridViewComboBoxCell value is not valid".
> >
> > Googling shows an extensive number of people suffering the same, but
> > I'm none the wiser.
> >
> > Is there a simple solution to this?
> >
> > Greg.
>
> Perhaps you can try adding a DataTable to hold all those values for the
> ComboBox, then setting the ComboBoxColumn.DataSource to the DataTable.
> The ComboBoxColumn.ValueMember's data must be valid for the underlying
> column in the DataGridView.
>
> B.

AddThis Social Bookmark Button