I am relatively new to programming so this may seem like a trivial question, but here goes. On my form I have a datagridview which is bound to a 'Supplier' table in Access 2003. Once I click on a record on the DataGridView, textboxes below which are also bound to the same source are automatically populated with the relevant data. What I want is when I click update, that the records in the database are updated as well as the dataset but what happens is that the dataset is updated, I invoke the tableadapater.update method but no permanent changes are made to the database.
Below is the code attached to the 'Edit Supplier' command button. Its pretty basic but any help would be greatly appreciated
Private Sub cmdEditSupplier_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdEditSupplier.Click Me.SupplierTableAdapter.Update(QuoteDataSet.Supplier) Me.SupplierTableAdapter.Fill(QuoteDataSet.Supplier) End Sub