Updating a dataset with both inserted and deleted records

  • Thread starter Thread starter ST
  • Start date Start date
S

ST

Is there a way to update a typed dataset with both inserted and deleted
records back to datasource in a persistent way?

Let's use the purchase order as example. If my typed dataset is built from
joining PO table and Item table with parent and child relationship. When I
inserting a new PO I'll have to insert the PO record first; while when I
deleting a PO I'll have to delete the Item record first because the parent
child constrain. In which case my update function will have to identify the
insert and delete records and update accordingly. Is there an easier
approach to handle this?

Thanks.
 
This works. Thanks.

Do you happen to know will MS add intelligent SqlCommandBuilder that is
similar to PowerBuilder datawindow so ADO developer will not need to add
complex data update logic. I know it is considerably more advanced than
previous version but it would be nice if it can be one step forward.

Thanks.

Sean Tsai
 
Sean,

We are looking at ways to simplify submitting hierarchical
changes in future versions of ADO.NET. Thank you for the
feedback.

David Sceppa
Microsoft
This posting is provided "AS IS" with no warranties,
and confers no rights. You assume all risk for your use.
© 2003 Microsoft Corporation. All rights reserved.
 
Back
Top