C#/DotNet equivalent of DED
I'm trying to make a hierarchical recordset (like I can do in VB6 using the Data Environment Designer -- DED). However, everytime I try to configure a DataSet the thing throws up on me. I have two tables that have compound primary keys. The first table is the master parent table and has keys A & B of which A is the foreign key into the second table, the child table, that has keys A, C & D. So I'm trying to create a relationship between the two tables using key A. Apparently, C#'s (DotNet's) DataSet does not like this at all. How do you create a parent and child command in this language/environment similar to what we did in VB6 with the DED? I know there must be a simple solution -- I'm just not getting it. Thanks in advance for any and all assistance.
Greg
|