I am trying to use the BindingNavigator (using VB 2005) to update five
tables (one at a time) depicted in five DataGridViews (one table on
each TabPage). Each table loads into its DataGridView properly. The
"MyEray" table will update but all others receive this message when
trying to save:

InvalidOperationException was unhandled
Update requires a valid UpdateCommand when passed DataRow collection
with modified rows.

Please help. This is my code:

Option Explicit On
Option Strict On
Public Class Form1

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
Me.EAdataDataSet.EnforceConstraints = False
Me.MyArayTableAdapter.Fill(Me.EAdataDataSet.MyAray)
Me.MyBrayTableAdapter.Fill(Me.EAdataDataSet.MyBray)
Me.MyCrayTableAdapter.Fill(Me.EAdataDataSet.MyCray)
Me.MyDrayTableAdapter.Fill(Me.EAdataDataSet.MyDray)
Me.MyErayTableAdapter.Fill(Me.EAdataDataSet.MyEray)
Me.MyFrayTableAdapter.Fill(Me.EAdataDataSet.MyFray)
End Sub

Private Sub MyErayBindingNavigatorSaveItem_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
MyErayBindingNavigatorSaveItem.Click
Me.Validate()
Select Case TabControl1.SelectedIndex
Case 0
Me.MyErayBindingSource.EndEdit()
Me.MyErayTableAdapter.Update(Me.EAdataDataSet.MyEray)
Case 1
Me.MyBrayBindingSource.EndEdit()
Me.MyBrayTableAdapter.Update(Me.EAdataDataSet.MyBray)
Case 2
Me.MyCrayBindingSource.EndEdit()
Me.MyCrayTableAdapter.Update(Me.EAdataDataSet.MyCray)
Case 3
Me.MyArayBindingSource.EndEdit()
Me.MyArayTableAdapter.Update(Me.EAdataDataSet.MyAray)
Case 4
Me.MyDrayBindingSource.EndEdit()
Me.MyDrayTableAdapter.Update(Me.EAdataDataSet.MyDray)
Case 5
Me.MyFrayBindingSource.EndEdit()
Me.MyFrayTableAdapter.Update(Me.EAdataDataSet.MyFray)
End Select
End Sub

Archived from group: microsoft>public>vb>syntax