howto update dataset in this scenerio?

Discussion in 'Web Design & Coding' started by anupam_sam, Jul 22, 2006.

  1. anupam_sam

    anupam_sam OSNN One Post Wonder

    Messages:
    3
    i have a dataset with 2 tables "Dept" and "Emp". they have a datarelation and emp has a foreign key deptno of dept.
    i proceed with following transactions.

    1) delete 3 records from child table "Emp"
    2) add 1 record to master table "Dept"
    3) delete 1 record of master table "Dept" related to those deleted records of "Emp"
    4) add 2 corresponding records to "Emp" of that currently added records.

    now i want to update these transactions to database.which table i will update first or how this transaction cud be updated?:speechless: