I am facing the following scenario:
In my database I have a field which can have the values 0, 1 and 2. These values corresponds to statuses, Waiting, Running, Finished. I want a Combobox on my form, where I can select one of the 3 statuses and have it write the appropriate number back to the database.
I realise that I can do a Property in my Model class ie
Public Property StatusString as String
Select Case Me.Status
but the problem is that the application is supposed to be multilingual, and I don't really want the translation issues to go into the datamodel.
So, what I would prefer is a way to assign the valid values to the ComboBox on FormLoad and then bind the SelectedIndex of the ComboBox to the BindingSource using the ControlBindingManager. Is it possible to do something like that?
Any help appriciated.