DataRelation - update parent and child at same time?

  • Thread starter Thread starter Mike Milner
  • Start date Start date
M

Mike Milner

Hello ADO.NET gurus :)

I am fairly new to database work and am hoping someone can help me
with a DataRelation question.

Anyway, I am working with an orders database. I have a DataTable of
orders, and another DataTable of order details, and need to get new
orders into my database.

I was able to set up a DataRelation between the two tables, however I
have an unfortunate limitation: I need to add the new orders and their
details in the same database transaction. (This is due to the
limitations of my database, which is proprietary and not relational.)
Therefore I can't follow David Sceppa's recommendation of first adding
the order and then updating the line items.

I think the best solution would be to pull in the details table when I
update the master (or vice versa), but I'm not sure if this is
possible. Is it? The other alternative I see is to maintain a cache,
have the details table update to this cache, and then pull in the
cache when you update the master table. However, I'd rather avoid this
for a variety of reasons.

Can anyone offer some suggestions?

Thank you!

Mike Milner
 
Hi Mike,

Add a rows to dataset tables, then call Update of orders adapapter and then
Update of details adapter.
When adapters are properly configured it should just work if you have only
new or updated rows.
However, when you have also deleted rows there are more steps.
 
Back
Top