hi

i would like to do deletion from multiple tables..for example i hv a table 1 where the primary key acct id is stored..now i hv two other tables(table 2 and table 3) in which the acct id is assigned the foreign key..i do know that the deletion must be done from the lowest level but how do i do it in C#..

i hv some psuedocode below...if its possible pls do tell...or else pls suggest me a way...


delete from table 3 where acct id = "textbox.text";

execute using dataAdapater;

delete from table 2 where acct id = "textbox.text";

execute using dataAdapter;

delete from table 1 where acct id = "textbox.text";

execute using DataAdapter;

is this possible....also how do i set up the dataset to have all these table in it...how do i fill it and clear it...im not so clear about the DATASET part...pls help