This seems like this is the best forum for VS2005B2 DataGridView(DGV) control questions. Problem appears to be that few posters have knowledge of how to use the DGV in a late bound fashion. Samples and posts push the designer solutions which are not useful in late-bound situations. My questions are control specific and the underlying DB and its access methods are moot.
For example I have a task to create simple maintenance forms for 30-40 lookup tables. There is little/no business logic attached to each table but in many cases foreign key data is stored that would be best to populate using a combobox. I'd like to create a form with DGV control that is late bound to one of the 30-40 tables as needed.
Is the easiest way to do this to late-bind the DGV, then add an unbound column that is of type combobox, and then use the CellEndEdit event to move the selected data to the cooresponding bound column? (not sure the terminology is correct) Would that even work - mixing bound and unbound columns?
Best would be to convert a late-bound text column to the combobox type but that doesn't seem like it can be done.
I am fine with adding the combo box Items without binding to a table, but a late-bound items list would be good too.
See
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=71917 for other details/trials/tribulations.
Ideas?