I have a datagridview which displays data through a dataview (DV_weld), which in turn is populated by a dataset (DS_weld1). The dataset gets it's data from SQL Server table through a SQLDataAdapter.
I would like the SQL table to be updated everytime a user edits some data in the datagridview. I have tried using:
Private Sub DGV_weld_CellValueChanged(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DGV_weld.CellValueChanged
If DS_weld1.HasChanges Then
But it will not recognise changes until the user moves off the row and edits some more data. How can I get this to work so that changes are dynamically updated in the table (instead of having to create a button for updating) everytime the user makes a change. I will also need to do this on text boxes.