G
Greg
We manually assign tablenames to our Datatables. We do not use
TableMappings.
When calling DataAdapter.Update like this:
dim i as integer = 0
i = da.Update(dsChanges.Tables("myTable"))
and setting the InsertCommand to a insert sproc that returns the inserted
record with a Select after the insert, do we need to have TableMappings?
The insert sprocs returns the inserted row when I run it in Query Analyzer.
It does not when calling Update on DataAdapter.
i = 1 in the above example, the record is inserted into the sql table. The
client never gets the record back though so we still have the 'old' DataRow,
which is not marked 'Unchanged' (was 'Added').
I tried adding TableMappings right before the call to Update, same results.
TableMappings.
When calling DataAdapter.Update like this:
dim i as integer = 0
i = da.Update(dsChanges.Tables("myTable"))
and setting the InsertCommand to a insert sproc that returns the inserted
record with a Select after the insert, do we need to have TableMappings?
The insert sprocs returns the inserted row when I run it in Query Analyzer.
It does not when calling Update on DataAdapter.
i = 1 in the above example, the record is inserted into the sql table. The
client never gets the record back though so we still have the 'old' DataRow,
which is not marked 'Unchanged' (was 'Added').
I tried adding TableMappings right before the call to Update, same results.