G
Guest
Good morning all,
Heres what I have;
XML doc that had contacts setup inside it. Within each contact is a
lines group. Holds the phone lines for each contact.
I load up this xml into a dataset and what I end up with is;
Table 1 = My contacts, 2 of them for this test. Has all my columns
plus a new one the reader created, Contact_ID
Table 2 = A linkage table that the ReadXml cmd created when reading
in the data.
Has two fields: a] Contact_ID B] Phoneline_ID
Table 3 = Contacts PhoneLines, 3 rows for this test. Has all my
columns plus a new one the reader created, Phoneline_ID
Ok everything is fine here. Now what I want to do is somehow qurey this
dataset to return a dataview with a few fields from Table 1 and the
Line # field in Table 2.
How would I go about this? This is my first time playing with datasets. I
usually just use dataview objects that I populate thru SQL queries.
Thanks for the help
Deasun
Heres what I have;
XML doc that had contacts setup inside it. Within each contact is a
lines group. Holds the phone lines for each contact.
I load up this xml into a dataset and what I end up with is;
Table 1 = My contacts, 2 of them for this test. Has all my columns
plus a new one the reader created, Contact_ID
Table 2 = A linkage table that the ReadXml cmd created when reading
in the data.
Has two fields: a] Contact_ID B] Phoneline_ID
Table 3 = Contacts PhoneLines, 3 rows for this test. Has all my
columns plus a new one the reader created, Phoneline_ID
Ok everything is fine here. Now what I want to do is somehow qurey this
dataset to return a dataview with a few fields from Table 1 and the
Line # field in Table 2.
How would I go about this? This is my first time playing with datasets. I
usually just use dataview objects that I populate thru SQL queries.
Thanks for the help
Deasun