Wrox Home  
Search P2P Archive for: Go

  Return to Index  

aspx thread: Inserting rows in a dataset with multiple related tables ?


Message #1 by "Rohit Arora" <rohit_arora@i...> on Sat, 1 Feb 2003 12:55:37 +0530
Hi Group,

	I have a typed dataset and now if I have to insert a row in a dataset
tables. How to achieve it ?

For eg.
I have two table Alert and Business Entity name in dataset with structures.

Alert--
AlertID(pk), AlertFromBusinessEntityID

Rel_AlertfromBusinessEntityID_to_AlertTobusinessEntityID ----
AlertFromBusinessEntityID(pk) and a foreign key in Alert table.
AlertToBusinessEntityID

Now how can I just update this in a single go by passing values like

AlertID- 5 AlertFromBusinessEntityID -- 12 AlertToBusinessEntityID -- 15

Alert and Rel_AlertfromBusinessEntityID_to_AlertTobusinessEntityID table
have one to many relation but right now as a simple exercise i hv made one
to one mapping

Now how I am going to insert record in Alert table like --

AlertID- 5 AlertFromBusinessEntityID -- 12 and at the same time insert a
record in Rel_AlertfromBusinessEntityID_to_AlertTobusinessEntityID table
like AlertFromBusinessEntityID -- 12 AlertToBusinessEntityID -- 15

I am using a XmlDataDocument synchronized with dataset. So, I ll be using
xmlDataDocument to update dataset. But I ll appreciate any solution using
either relational way or a heiarchial way. Just needed to get started n will
try to port this in heiarchial manner.

Regards
Rohit Arora
Intersolutions (P) Ltd
B - 21, Sector 58,
Noida - 201301
Tel : 91-2585703/04/05 Extn: 229


  Return to Index