hierachical related client side data duplication

microsoft.public.dotnet.framework.adonet

1 May 2006 8:01 AM

Jon Vaughan

I have a hierachical dataset brought back from a sql server stored procedure
with a design as follows :

StaffID
<Staff Columns>

AddressID
<Address Columns>
StaffID_FK

PhoneID
<Phone Columns>
AddressID_FK

Im using a disconnected architecture, so when I recieve the dataset , I
remap the the relationship (is there no way to get this relationship from
sql server - see's silly remapping). What im now looking to do is to
duplicate a staff members data , if I copied a row from the Staff table will
all the related data also be duplicated ? and if it wont whats the best way
to achieve this result ?

Jon

1 May 2006 9:36 AM

Cor Ligthert [MVP]

Jon,

First of all if you use a newsreader as Outlook Express, do us than a favor
and don't multipost. Crossposting is appriciated in these dotnet newsgroup.
Sending one message to more newsgroups at once.

I have given an answer in an other newsgroup you have multiposted to.

Cor