The Add customer button launches new form that allows the user to enter a new customer name and click save. hope this helps anybody else who has stumbled upon the same issue. There is a difference between a dataset and the database. If you update the data in the Database's datatable you have to reload the data into the dataset datatable. A Data Set has a Tables property, which is a collection of Data Tables, and a Relations property, which is a collection of Data Relations.When the user hits save and form B closes and the focus goes back to form A and they drop down the combobox, the newly added customer does not show up, yet when checking the table, it is there. Also, if you update the data in a dataset, you have to save it using the update method. When you call Fill on a Data Adapter or Table Adapter you are populating a Data Table.The Display Member is the name of the member of the bound objects to display in the control.The Value Member is the name of the member of the bound objects whose value should be returned by the control's Selected Value property.You can either assign the Data Table to the Binding Source's Data Source property or else assign a Data Set to the Data Source and then the name of the Data Table to the Data Member. A Data Set is essentially an in-memory representation of a database.The Binding Source then gets assigned to the Combo Box's Data Source. A Data Table is basically an in-memory representation of a database table.
Now, reading your posts a bit more carefully, there's no reason that calling Update on a Table Adapter should cause the selection in the Combo Box to change. Machines) 'Returning From a dialog Dim Result As Dialog Result Result = dlg New Machine. A Data Set has a Tables property, which is a collection of Data Tables, and a Relations property, which is a collection of Data Relations.
A common scenario is binding a Data Table via the Data Source and setting the Display Member and Value Member to "Name" and "ID" respectively.
That way the user sees a list of names they can choose and you can get the ID that corresponds to the selected name from the Selected Value property.
That's for bind specific properties of the Combo Box to values from a list or an object.
That is used more in situations like binding the Text property of a Text Box.