OK i have implemented the derived class and created a combobox at runtime.
I am getting the same results. the selected value reverts back to original on loss of focus.
On the new control i bound it to the new values:
//ProducerTypeIdCombo.DataBindings.Add("Value", Producer, "ProducerTypeId");
Combo1.DataBindings.Add("IntegerValue", Producer, "ProducerTypeId");
If i go back and change the column type in SQL to a nvarchar it will work as expected. But I need valid columns types.
Any ideas?