End Edit of a DataGrid so that it updates it’s DataSource

[gtyler]

When you make changes to a DataGrid a picture of a Pencil appears on the right hand side. As I understand it, the DataSource is not updated until you move off that row and the Pencil disappears.

If one of my users were to close the form without remembering to press the “Update Database” button then the changes would be lost. So I wrote a procedure for the On Closing Event that checks for Modified rows, and if there are it prompts the user to “Update the Database”:

    Private Sub frmSiteInfo_Closing(ByVal sender As Object, ByVal e As System.ComponentModel.CancelEventArgs) Handles MyBase.Closing
        'Problem the Is that I can't force an end to the Edit of the Datagrid. So Changes are not apparent in the table
  dtgComment.EndEdit(dtgComment.TableStyles("tblComment").GridColumnStyles(dtgComment.CurrentCell.ColumnNumber), dtgComment.CurrentCell.RowNumber, False)
 
        'This checks whether there are changes to be made to the Database
        Dim dvChangedRecord As New DataView(dtblComment, "", "", DataViewRowState.ModifiedCurrent)
        If dvChangedRecord.Count > 0 Then
            Dim intMsgBoxResult As Integer
            intMsgBoxResult = MsgBox("Do you wish to save your changes to Comments?", MsgBoxStyle.YesNo, "You have not saved your changes to Comments")
            If intMsgBoxResult = vbYes Then
                UpdateCommentsTable()
            Else
                dtblComment.RejectChanges()
            End If
        End If
    End Sub
 

(You might notice that I used EndEdit, but it does not seem to have the effect I required)

This won’t work if the user fails to move off the edited record before pressing the Close button “X” at the top of the window because the changes to the DataGrid are not write to the DataGrid’s Data Source (in this case dtblComment)

I would really appreciate any suggestions!!