How to refresh datagridview in vb.net

See more:

VB

DataGridView

forms

Hello I seem to be having an issue. I have a datagridview bound to a dataset in my windows forms application. I'm hoping to find a way to refresh my datagridview after making a change to a cell. Let me go through the steps I've taken to try and accomplish this. I've added an isdirty boolean flag to the EndEdit event if the user makes any change to the datagridview. So I created a method that if the the isdirty flag is true then the changes will be written to the datasource, the program is then saved and I re-retrieve the datasource. When I try and use the refresh button the program loads for a minute and then reverts back to its original state. I can't figure out why this approach isn't working for me. I saw online something about re-binding datasources for a refresh to work, but I didn't quite understand it. If anyone has any suggestions or answers for this I would greatly appreciate any help. If this question is not clear enough please tell me how I can make it make more sense to you.

'    This is how I retrieve my datasource
 Sub retrieveDGV()

   MyCommand = New OleDbDataAdapter("select * from [ExcelWorksheet$A4:I150]", MyConnection)

    DataSource = New System.Data.DataSet()
    MyCommand.Fill(DataSource)

  DGV.DataSource = DataSource.Tables(0).DefaultView



  Private Sub btnrefreshDGV_Click(sender As Object, e As EventArgs) Handles    btnrefreshDGB.Click
   refreshDGV()

   End Sub

' This is how I use the isdirty flag
  Private Sub DGV_CellEndEdit(sender As Object, e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DGV.CellEndEdit

    DGVisdirty = True
End Sub
Sub refreshDGV()
    If DGBisdirty Then
        write2DGV()
        objworkbook.Save()
        retrievedDGV()

    End If
End Sub