I created a Windows Forms app (running on .NET framework). Connect to my table in SQL. I’m able to add new record in table. However I can not update any current records. Not sure how to correct it.

This is the code I have:

Private Sub Table1BindingNavigatorSaveItem_Click(sender As Object, e As EventArgs) Handles Table1BindingNavigatorSaveItem.Click
     Me.Validate()
     Me.Table1BindingSource.EndEdit()
     Me.TableAdapterManager.UpdateAll(Me.TempDataSet)

End Sub

The error points at throw x at the update code:

    '---- Commit updates -----------
    '
    workTransaction.Commit
    If (0 < allAddedRows.Count) Then
        Dim rows((allAddedRows.Count) - 1) As Global.System.Data.DataRow
        allAddedRows.CopyTo(rows)
        Dim i As Integer = 0
        Do While (i < rows.Length)
            Dim row As Global.System.Data.DataRow = rows(i)
            row.AcceptChanges
            i = (i + 1)
        Loop
    End If
    If (0 < allChangedRows.Count) Then
        Dim rows((allChangedRows.Count) - 1) As Global.System.Data.DataRow
        allChangedRows.CopyTo(rows)
        Dim i As Integer = 0
        Do While (i < rows.Length)
            Dim row As Global.System.Data.DataRow = rows(i)
            row.AcceptChanges
            i = (i + 1)
        Loop
    End If
Catch ex As Global.System.Exception
    workTransaction.Rollback
    '---- Restore the dataset -----------
    If Me.BackupDataSetBeforeUpdate Then
        Global.System.Diagnostics.Debug.Assert((Not (backupDataSet) Is Nothing))
        dataSet.Clear
        dataSet.Merge(backupDataSet)
    Else
        If (0 < allAddedRows.Count) Then
            Dim rows((allAddedRows.Count) - 1) As Global.System.Data.DataRow
            allAddedRows.CopyTo(rows)
            Dim i As Integer = 0
            Do While (i < rows.Length)
                Dim row As Global.System.Data.DataRow = rows(i)
                row.AcceptChanges
                row.SetAdded
                i = (i + 1)
            Loop
        End If
    End If
    Throw ex