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