I have multiple dropdowns with either "yes", "no", or "n/a" as list items. In the database I stored these as integers, 0 = no, 1 = yes, 2 = n/a. Anyway, I am trying to bind dropdowns on my form to these values. What I did so I could have display and value members was create a table with two columns:
list_value int
list_text varchar(50)
I populated the table with:
list_value list_text
0 No
1 yes
2 Not Applicable
anyway, I added a binding source to the form and set all the dropdowns to use that bindingsource. when I run my form, even though the selectedValue property on all are set to thier appropriate fields, they all have the same value. Do I have to create a separate bindingsource/tableAdapter for each dropdown

databinding drop downs