Hi all,I have filled a dataset using sqlDataAdapter. This SqlDataAdapter fetching the rows from two tables using Inner join. After I displayed the rows in DataGrid, I need to update if the user modify the any one or more than one row in DataGrid. I used "Update method of SqlDataAdapter". But, I could not update. The update should be happend when the user click the button.

Private Sub buttonUpdateTheChangesOnGridView_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles buttonUpdateTheChangesOnGridView.Click If MessageBox.Show("Update?", "Update Confirmation", MessageBoxButtons.YesNo) = Windows.Forms.DialogResult.Yes Then Dim ds1 As DataSet = ds.GetChanges() If Not ds1 Is Nothing Then da1.Update(ds.Tables(0)) End If End If End Sub