Binding a combobox to a dataset and value changes appropriately for current record selected?
I have a dataset in a vb.net form that is linked successfully to a sql server table with fields from the table being displayed on the form appropriately. I have created a combobox and populated it with a collection of items the user can select from. I am attempting to bind that combobox to a field in the linked table, so that as the user navigates thru the records in the dataset the appropriate value is displayed in the combobox and if a user selects a value from within the combobox that value is automatically updated/replaced/changed in the appropriately bound field. I am wrestling with this one - any help would be greatly appreciated. Thanks!
I have a dataset in a vb.net form that is linked successfully to a sql server table with fields from the table being displayed on the form appropriately. I have created a combobox and populated it with a collection of items the user can select from. I am attempting to bind that combobox to a field in the linked table, so that as the user navigates thru the records in the dataset the appropriate value is displayed in the combobox and if a user selects a value from within the combobox that value is automatically updated/replaced/changed in the appropriately bound field. I am wrestling with this one - any help would be greatly appreciated. Thanks!