Hi,
I've been looking at this for a while now and I have tried 4 or 5
different options and I can't quite get this to work.
Requirements
I have a DataGridView setup in virtual mode and I want a Combobox
column in DropDownCombo style (i.e so you can type a new value in that
doesn't exist in the dropdown).
If the user types something into the editable portion that doesn't
exist in the dropdown I need to perform a search that may find a
matching item that I want added to the dropdown, this value should
then be selected and pushed back to the datastore.
Ideally I'd like to implement an iTunes style fuzzy matching algo as
well (perhaps filter the contents of the dropdown but I'd like to get
the simple option working first
Problem
I'm hitting issues with the validation, I've tried several points to
hook into the chain of events but none seem early enough to prevent a
DataError being thrown because the value I entered isn't in the
dropdown
Any thoughts on the best way to approach this problem?
Thanks in advance for your thoughts
David Hayes