I have an EntityCollection that I am binding to a DataGridView. This collection is a three-table relation: Employee, EmployeeDepartment, Department (the tables are setup that way because it is actually possible in our organization for an employee to fall under mulitiple departments due to budget splits).
The EntityCollection contains all of the data just fine (using Adapter and a PrefetchPath). I setup a pair of DataGridViews in a Master-Detail scenario to ensure the related Department collections were being included ok.
However, I really don't want this in a Master-Detail scenario. What I really want to do is have the Employee data bound to a DataGridView and have the Department names bound to a ComboBox contained within the DataGridView. Now, supposedly .NET 2.0 supports this. And indeed, I can set a column in my DataGridView to be a ComboBox column.
But I cannot for the life of my figure out how to display anything in the combo box, let alone how to bind the Department results to it.
I can't even get a simple default string list to work. In Visual Studio 2005 you can Edit the columns of a DataGridView and set the Items collection to a list of strings, but even those are not displaying in my Grid when the app runs.
Does anyone have any idea what is going on, or how to properly bind this? This is driving me nuts. I've killed a whole day trying to debug this and from what I can tell the ComboBox is just freaking broken.
It's absurd.