Parent/Child Table and dataset.update: Parent updates-Child won't

Parent/Child Table and dataset.update: Parent updates-Child won't

Post by QkdW » Fri, 12 May 2006 01:54:01


This, to me, seems like something that is so often repeated in developer
circles on a daily basis that it should have it's own mini-wizard.
Unfortunately it seems to be one of those "try this and SEE if it works"
problems because nobody seems to have a succinct checklist of what needs to
be in place for this to work. Surely this must be a process that has
repeatable steps. I am running out of alternatives for answers so I will give
it one last shot:

To distill to its essence- 1 Parent Table and 1 Child Table with 1 linked
field (Primary key of Parent). Want to add new record to Parent and Child
linked by this field. Using wizard-generated Dataset containing both
tables,data adapter for each table. I do not want to add details because at
this point I am looking for the absolute most basic checklist of what it
takes to get the Child table to update when linked to Parent. That's it.
 
 
 

Parent/Child Table and dataset.update: Parent updates-Child won't

Post by Bob Butle » Fri, 12 May 2006 02:05:46


XXXX@XXXXX.COM
<cut>

sounds like dotnet, not VB. If so, try asking in a group with "dotnet" in
the name. This group is for VB 6.0 and earlier and VB.Net is NOT.VB

--
Reply to the group so all can participate
VB.Net: "Fool me once..."

 
 
 

Parent/Child Table and dataset.update: Parent updates-Child won't

Post by jmbledso » Sat, 27 May 2006 23:53:21

I don't want to sound like a marketing guy this is the exact same
problem that I had. It was such a pain that I built a tool to do this
for me, and now my company is selling it (free to try, and under $100
to buy). It's called the DataSet Toolkit, and it has a class called
the MultiTableDataAdapter which does exactly the thing you want. Let
me know what you think.

http://www.yqcomputer.com/


John B.
http://www.yqcomputer.com/