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