update database from bound datagrid on cell value changed

I have been searching on this for quite some time and have been coming up empty.  I apologize for the wordy question, but I figured it's better to lay everything out and what I've done, so no open ended statements exist on my part.  I need to update my database immediately on data change.  But I need to give the user the option to reverse their changes.  This is the best I've come up with thus far.

I have a datagrid that I populate with an SQL dataset on form load.  I then hide a few columns and open 1 column for data changing.

' FULL CASES
Dim sAdapterFC As SqlDataAdapter
Dim sDsFC As New DataSet()
' POPULATE FULL CASES
        Dim sqlFC As String = "SELECT ID, PART_NUM, PART_NAME....."
        Dim sCommandFC As New SqlCommand(sqlFC, connection)
        sAdapterFC = New SqlDataAdapter(sCommandFC)
        Dim sBuilderFC As New SqlCommandBuilder(sAdapterFC)
        Dim sTableFC As DataTable = sDsFC.Tables("tblManuProdPART")
        sAdapterFC.Fill(sDsFC, "tblManuProdPART")
        sCommandFC = Nothing
        DataGridView1.DataSource = sDsFC.Tables("tblManuProdPART")
        If DataGridView1.Columns.Count > 0 Then
            For i = 0 To DataGridView1.Columns.Count - 1
                DataGridView1.Columns(i).AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells
                DataGridView1.Columns(i).SortMode = DataGridViewColumnSortMode.NotSortable
                DataGridView1.Columns(i).ReadOnly = True
            Next
        End If
        DataGridView1.Columns(0).Visible = False
        DataGridView1.Columns(1).Visible = False
        DataGridView1.Columns(3).Visible = False
        DataGridView1.Columns(6).Visible = False
        DataGridView1.Columns(4).ReadOnly = False

Select allOpen in new window

I then need to handle the edits to the grid, as they will affect other calculations on the form.  The biggest issue is I want to preserve the initial value, to give the user a chance to cancel out of the edit and recalculate the form if they change their mind or make a mistake.  To do this, I'm using the BeginEdit, CellValidating (to ensure the value entered is numeric for calculation purposes), CellValueChanged as such:

Private Sub DataGridView1_CellBeginEdit(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellCancelEventArgs) Handles DataGridView1.CellBeginEdit

        If txtControl.Text = "VIEW" Then
            If (e.ColumnIndex = 4) Then
' CAPTURE ORIGINAL VALUES BEFORE THE EDIT TO ALLOW FOR ROLLBACK / RECALCULATION
                ORIGPARTValue1 = DataGridView1.Rows(e.RowIndex).Cells("PART_USED").Value.ToString
                ORIGentered1 = DataGridView1.Rows(e.RowIndex).Cells("PART_CASES_USED").Value.ToString
            End If
        End If

    End Sub

    Private Sub DataGridView1_CellValidating(ByVal sender As Object, ByVal e As DataGridViewCellValidatingEventArgs) Handles DataGridView1.CellValidating

' CHECK FOR NULLS
        If (String.IsNullOrEmpty(e.FormattedValue.ToString())) Then
            MsgBox("All cells must have a value.  Please try again!", vbOKOnly, "Missing Data!")
            e.Cancel = True
        Else
' VERIFY IF IN COLUMN 4 THE ENTERED VALUE IS NUMERIC.  
' I specify this because another column is calculated based on the value entered in column 4.  If I do not specify the column, the validating hits on the calculated column and then crashes the program, like I'm stuck in a loop.
            If (e.ColumnIndex = 4) Then
                If Not IsNumeric(e.FormattedValue) Then
                    MsgBox("Please enter a numeric value.", vbOKOnly, "Non-Number Error")
                    e.Cancel = True
                    Exit Sub
                Else
                    If DataGridView1.Visible = True Then
                        DataGridView1.CommitEdit(Nothing)
                    End If
                End If
            End If
        End If

    End Sub

    Private Sub DataGridView1_CellValueChanged(ByVal sender As Object, ByVal e As DataGridViewCellEventArgs) Handles DataGridView1.CellValueChanged

        If (e.ColumnIndex = 4) Then
' This recalculates the data in the gridview to compare against reports
            CalcProdFCPART()
            If txtControl.Text = "VIEW" Then

' This checks if the value entered isn't the same as the original.  If not, it kicks off the update process.
                If DataGridView1.Rows(e.RowIndex).Cells("PART_CASES_USED").Value <> ORIGentered1 Then
                    Dim tmpresponse As MsgBoxResult = MsgBox("You are about to adjust the component inventory for the following item:" & vbCrLf & vbCrLf & DataGridView1.Rows(e.RowIndex).Cells("COMP_NAME").Value & vbCrLf & vbCrLf & "These changes CANNOT be undone and will be applied immediately, without saving.  Are you sure you want to commit this change?", vbYesNo, "Inventory Update")
                    If tmpresponse = MsgBoxResult.Yes Then

                        Try
                            
' UPDATE THE ACTUAL DATABASE!!!!
                            Dim cmdFC As New SqlCommandBuilder(sAdapterFC)
        Dim iFC As Integer
        Try
            iFC = sAdapterFC.Update(sDsFC, "tblManuProdPART")
        Catch ex As Exception
            MsgBox(ex.Message, vbOKOnly, "Error Applying FULL CASES")
            Exit Sub
        End Try

                        Catch ex As Exception
                            MsgBox(ex.Message, vbOKOnly, "Error Applying FULL CASES")
                            Exit Sub
                        End Try
                        
                        'MsgBox("Component Inventory updated successfully.", vbOKOnly, "Saved")

                    Else
' ALLOWS THE ORIGINAL VALUE TO REPOPULATE IF THE USER CHOOSES TO CANCEL
                        MsgBox("Changes NOT saved.", vbOKOnly, "Change Failed")
                        DataGridView1.Rows(e.RowIndex).Cells("PART_CASES_USED").Value = ORIGentered1
                        DataGridView1.Refresh()
                    End If
                End If
            End If
        End If

    End Sub

Select allOpen in new window

The thing that blows my mind is if I take that same update logic and put it in a button, it works perfectly fine.  I have no idea why it won't update directly, without the use of the button.  I've tried Accepting the changes.  I've tried Committing the changes.  Nothing seems to make it work, without the use of the button.  But I really need them to be able to update immediately, after acknowledging the prompt, as there are other inventory processes I need to update as a result of this change.  But again, if they accidentally changed the wrong value, I need them to be able to back out the change, which would cancel all subsequent inventory changes as a result of the misentry.  I'm literally out of ideas and need the help of the experts.