VB10 Code is a problem- used for updating (4) tables made in VB10 using database

See more:

VB

VB10

Gentlemen,

Need some help with a college project which is not working as i am naive to it, perhaps my coding done is incorrect which as given below.
Request your expert help if someone knows the subject.

Thankyou in anticipation.
Kind Regards


I have (4) tables made under a single (customer.mdf) file running in VB10 under SQL Server Database file. (Table1,Table2,Table3,Table4)
If we run the project it does not update and save records.

However only The first two tables get updated and saved after using the following code.

Public Class Form1
  Private Sub Table1BindingNavigatorSaveItem_Click(ByVal  sender.........
  Me.Validate()
  Me.Table1BindingSource.EndEdit()
  Me.TableAdaptorManager.UpdateAll(Me.CustomerDataSet)

  Me.Table2BindingSource.EndEdit()
  Me.Table2TableAdaptor.Update(Me.CustomerDataSet)

End Sub

But if we use the following code to include (4) tables as below it does not work and gives error.

Me.Validate()
  Me.Table1BindingSource.EndEdit()
  Me.TableAdaptorManager.updateAll(Me.CustomerDataSet)

  Me.Table2BindingSource.EndEdit()
  Me.Table2TableAdaptor.update(Me.CustomerDataSet)

  Me.Table3BindingSource.EndEdit()
  Me.Table3TableAdaptor.update(Me.CustomerDataSet)

  Me.Table4BindingSource.EndEdit()
  Me.Table4TableAdaptor.update(Me.CustomerDataSet)

End Sub