Hi Brian,
Thank you for your prompt response.
I have peformed a test on this, and when the program is run, I get an error
saying that 'DataGridViewComboBoxCell value is not valid'. So I don't think
it's a good practice to bind a property of a complex type to a
DataGridViewComboBoxColumn.
I suggest that you don't bind the QuantityUom property to the
DataGridViewComboBoxColumn. Instead, you could paint the value in the
corresponding cells by yourself, which would be more flexible and easy.
In detail, you may handle the CellPainting event of the DataGridView to set
the value of the cell (e.g. the value of 10). To save the updated value to
the data source, you should also handle the CellValidated event of the
DataGridView to set the new object to the data source.
The following is a sample, which assumes that you add a DataGridView on a
form and add two columns into the DataGridView. The first column is of type
DataGridViewTextBoxColumn and the second column is of type
DataGridViewComboBoxColumn.
public partial class Form2 : Form
{
MyList addresses = new MyList();
List<Personpersons = new List<Person>();
public Form1()
{
InitializeComponent();
this.dataGridView1.CellPainting += new
DataGridViewCellPaintingEventHandler(dataGridView1 _CellPainting);
this.dataGridView1.CellValidated += new
DataGridViewCellEventHandler(dataGridView1_CellVal idated);
}
void dataGridView1_CellValidated(object sender,
DataGridViewCellEventArgs e)
{
// the cells under the column of index 1 are going to display
the property of a complex type
if (e.ColumnIndex == 1 && e.RowIndex -1)
{
if
(this.dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value != null)
{
string val =
this.dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString();
persons[e.RowIndex].Addr =
this.addresses.GetAddress(val);
}
}
}
void dataGridView1_CellPainting(object sender,
DataGridViewCellPaintingEventArgs e)
{
if (e.ColumnIndex == 1 && e.RowIndex -1)
{
this.dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value =
persons[e.RowIndex].Addr.ID;
}
}
private void Form1_Load(object sender, EventArgs e)
{
Address addr = new Address("1", "cityA");
addresses.Add(addr);
addr = new Address("2", "CityB");
addresses.Add(addr);
addr = new Address("3", "CityC");
addresses.Add(addr);
Person per = new Person("1", addresses[0]);
persons.Add(per);
per = new Person("2", addresses[1]);
persons.Add(per);
per = new Person("3", addresses[2]);
persons.Add(per);
this.dataGridView1.AutoGenerateColumns = false;
this.dataGridView1.DataSource = persons;
this.dataGridView1.Columns[0].DataPropertyName = "ID";
(this.dataGridView1.Columns[1] as
DataGridViewComboBoxColumn).DataSource = addresses;
(this.dataGridView1.Columns[1] as
DataGridViewComboBoxColumn).DisplayMember = "City";
(this.dataGridView1.Columns[1] as
DataGridViewComboBoxColumn).ValueMember = "ID";
}
public class Person
{
private string id;
public string ID
{
get { return id; }
set { id = value; }
}
private Address addr;
public Address Addr
{
get { return addr; }
set { addr = value; }
}
public Person(string id, Address addr)
{
this.id = id;
this.addr = addr;
}
}
public class Address
{
private string id;
public string ID
{
get { return id; }
set { id = value; }
}
private string city;
public string City
{
get { return city; }
set { city = value; }
}
public Address(string id, string city)
{
this.id = id;
this.city = city;
}
}
public class MyList:List<Address>
{
public Address GetAddress(string id)
{
Address addr = null;
for (int i = 0; i < this.Count; i++)
{
if (this[i].ID == id)
{
addr = this[i];
break;
}
}
return addr;
}
}
}
Hope this helps.
If you have any questions, please feel free to let me know.
Sincerely,
Linda Liu
Microsoft Online Community Support
