HowTo Delete related rows

[sjoshi]

Hello All

I have a DataSet with tables Customers, Orders related by CustomerID
coln. Now Orders has a field "FixIt", if this is set to true, I need to
delete that row.

The possible scenarios are:

1. Customer_1
Order_1 false
Order_2 true

2.Customer_1
Order_1 true
Order_2 true

So when it's case 1, I need to just delete the Order_2 from Orders.
However when its case 2, I need to delete all from Orders and
Customer_1.

What would be the best way to do this ?

thanks
Sunit

 

[Earl]

Very straightforward, you have to delete from the child table before
deleting from the parent table, i.e., delete your orders, then delete your
customers.

 

[Cor Ligthert [MVP]]

Sjoshi,

In addition to Earl,

The trigger for this is the DataTable.GetChanges(datarowstate.XXX)

http://msdn2.microsoft.com/en-us/library/5dxfaha8.aspx

To make Earls message complete after the handling of the Parent rows you can
do the handling of the new and added childrows.

I hope this helps,

Cor