How to refresh/update datagridview windows form

See more:

VB

WinForms

MS-Excel

DataGridView

, +

I'm having trouble finding a solution for refreshing my datagridview. My goal is to have a refresh button that will automatically update the database(excel worksheet) after making a change and pressing the refresh button. The way my program responds: I make a change to the datagridview and press my refresh button, the program loads and then reverts back to the original data. Here is how my code looks so far.

MyCommand1 = New OleDbDataAdapter("select * from [MyExcel$A13:x150]", MyConnection)

       DataSet1 = New System.Data.DataSet()
       MyCommand1.Fill(DataSet)


       'This displays the data to the GUI but does not save it to the DB table that we ultimately want it saved to
       DataGridView1.DataSource = DataSet1.Tables(0).DefaultView

 Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
            Try
                oledbCmdBuilder = New OleDbCommandBuilder(oledbAdapter)
                changes = DataSet1.GetChanges()
                If changes IsNot Nothing Then
                oledbAdapter.Update(DataSet1.Tables(0))
            End If
            DataSet.AcceptChanges()
            MsgBox("Save changes")
        Catch ex As Exception
            MsgBox(ex.ToString)
        End Try
    End Sub
End Class