Hi,
I use VS2005 create a project – “Slemail”. In DataSet1 there’s a table of
customer email address data - “slemail”.
I drag “slemail” table to the form. It displays the data by DataGridView
control and creates “SlemailBindingSource”, “SlemailTableAdapter” and
“SlemailBindingNavigator”. It generates the following code of a function:

Private Sub bindingNavigatorSaveItem_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles bindingNavigatorSaveItem.Click
       If Me.Validate Then
           Me.SlemailBindingSource.EndEdit()
           Me.SlemailTableAdapter.Update(Me.DataSet1.slemail)
       Else
           System.Windows.Forms.MessageBox.Show(Me, "Validation errors
occurred.", "Save", System.Windows.Forms.MessageBoxButtons.OK,
System.Windows.Forms.MessageBoxIcon.Warning)
       End If
End Sub

When I start debugging and click the “save” button on the bindingNavigator
there’s an error message. The error detail is as the following:
------------------------------------------------
System.InvalidOperationException was unhandled
 Message="Update requires a valid UpdateCommand when passed DataRow
collection with modified rows."
 Source="System.Data"
 StackTrace:
      at
System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors(RowUpdatedEventArgs
rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)
      at
System.Data.Common.DbDataAdapter.UpdatedRowStatus(RowUpdatedEventArgs
rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)
      at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows,
DataTableMapping tableMapping)
      at System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable
dataTable, DataTableMapping tableMapping)
      at System.Data.Common.DbDataAdapter.Update(DataTable dataTable)
      at
SLEmail.DataSet1TableAdapters.slemailTableAdapter.Update(slemailDataTable
dataTable) in D:\Projects\VB\SLEmail\DataSet1.Designer.vb:line 1051
      at SLEmail.email.bindingNavigatorSaveItem_Click(Object sender,
EventArgs e) in D:\Projects\VB\SLEmail\email.vb:line 6
      at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key,
EventArgs e)
      at System.Windows.Forms.ToolStripButton.OnClick(EventArgs e)
      at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
      at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
      at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs
e, ToolStripItemEventType met)
      at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e,
ToolStripItemEventType met)
      at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
      at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons
button, Int32 clicks)
      at System.Windows.Forms.Control.WndProc(Message& m)
      at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
      at System.Windows.Forms.ToolStrip.WndProc(Message& m)
      at
System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
      at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
      at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd,
Int32 msg, IntPtr wparam, IntPtr lparam)
      at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
      at
System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32
dwComponentID, Int32 reason, Int32 pvLoopData)
      at
System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32
reason, ApplicationContext context)
      at
System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason,
ApplicationContext context)
      at System.Windows.Forms.Application.Run(ApplicationContext context)
      at
Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.OnRun()
      at
Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.DoApplicationModel()
      at
Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.Run(String[] commandLine)
      at SLEmail.My.MyApplication.Main(String[] Args) in
17d14f5c-a337-4978-8281-53493378c1071.vb:line 76
      at System.AppDomain.nExecuteAssembly(Assembly assembly, String[] args)
      at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence
assemblySecurity, String[] args)
      at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
      at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
      at System.Threading.ExecutionContext.Run(ExecutionContext
executionContext, ContextCallback callback, Object state)
      at System.Threading.ThreadHelper.ThreadStart()
---------------------------------------------------------------
What that means? What can I do about it?
I think it’d be something to do with the selection in TableAdapter
Configuration Wizard.
Should choose the option “Generate Insert, Update and Delete statements” in
Advanced Options? Should choose the option “Return a DataTable” and “Create
methods to send updates directly to the database”?
I cannot find clue in online help and samples.
Thanks.
ybc