databinding drop downs

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


Answer this question

databinding drop downs

  • databinding drop downs