>When attempting to execute the Update command on an SQLAdapter object, I get the following error:
>
>
> 'Variable Values at Time of Execution:
> 'Me.Parent.Parent = DataSet Object
> 'Me.TableName = "tblUsers"
> 'Me.Parent.Parent.Tables.Contains("tblUsers") = True
> objAdapter.Update(Me.Parent.Parent, Me.TableName)
>
>
>
>System.InvalidOperationException: Update unable to find TableMapping['tblUsers'] or DataTable 'tblUsers'.
>
>
>I am at a complete loss as to why I am getting this error. I would not be surprised if it's something simple that I overlooked, but darned if I can't seem to track this down. Any help would be appreciated...
Ben,
You have probably forgotten to set the table mappings for the DataAdapter to 'tblUsers'.
Before the update:
objAdapter.TableMappings.Add("Table1", "tblUsers")