Your Try...Catch Block is wrong (see
MSDN[
^]). You should write something similar to:
Private Sub Table1BindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Table1BindingNavigatorSaveItem.Click
Me.Validate()
Try
Me.Table1BindingSource.EndEdit()
Me.TableAdapterManager.UpdateAll(Me.Database1DataSet)
Me.Table2BindingSource.EndEdit()
Me.Table2TableAdapter.Update(Me.Database1DataSet)
Me.Table3BindingSource.EndEdit()
Me.Table3TableAdapter.Update(Me.Database1DataSet)
Me.Table4BindingSource.EndEdit()
Me.Table4TableAdapter.Update(Me.Database1DataSet)
Me.Table5BindingSource.EndEdit()
Me.Table5TableAdapter.Update(Me.Database1DataSet)
Catch ex As Exception
MsgBox("An exception occurred while updating the database: " & ex.Message)
End Try
End Sub