Vista - Please help with getting the right structure from dataset usingGetXML()

Hi everyone,

I need your help getting my getXML method to function the way I need
it to. I have a stored procedure that returns data into a dataset (I
am using VB.NET). I use getXML with dataset and I get the following
result:

<NewDataSet>
<Table>
<StudentFirstName>John</StudentFirstName>
<StudentMiddleName>J</StudentMiddleName>
<StudentLastName>Smith</StudentLastName>
<StudentAddressType>Permanent</StudentAddressType>
<StudentAddressLine1>123 Some Rd</StudentAddressLine1>
<StudentAddressLine2 />
<StudentAddressLine3 />
<StudentAddressLine4 />
<StudentAddressCity>New Town</StudentAddressCity>
<StudentAddressState>NJ</StudentAddressState>
<StudentAddressPostalCode>12345</StudentAddressPostalCode>
<StudentAddressCounty />
<StudentAddressCountry>United States</StudentAddressCountry>
<StudentHomePhoneNumber>1234567890</StudentHomePhoneNumber>
<StudentCellPhoneNumber>1234567890</StudentCellPhoneNumber>
<Parent1FirstName>Jane</Parent1FirstName>
<Parent1MiddleName />
<Parent1LastName>Smith</Parent1LastName>
<Parent1HomePhoneNumber>1234567890</Parent1HomePhoneNumber>
<Parent1WorkPhoneNumber />
<Parent1EmailType>Personal</Parent1EmailType>
<Parent1EmailAddress>john@xxxxxx</Parent1EmailAddress>
<Parent2FirstName>John Sr</Parent2FirstName>
<Parent2MiddleName />
<Parent2LastName>Smith</Parent2LastName>
<Parent2HomePhoneNumber>1234567890</Parent2HomePhoneNumber>
<Parent2WorkPhoneNumber />
<Parent2EmailType>Personal</Parent2EmailType>
<Parent2EmailAddress>johnsr@xxxxxx</Parent2EmailAddress>
</Table>
</NewDataSet>

Which is all fine and good but what I really need to get is the
following:
<Data>
<StudentData>
<StudentFirstName>John</StudentFirstName>
<StudentMiddleName>J</StudentMiddleName>
<StudentLastName>Smith</StudentLastName>
<StudentAddressType>Permanent</StudentAddressType>
<StudentAddressLine1>123 Some Rd</StudentAddressLine1>
<StudentAddressLine2 />
<StudentAddressLine3 />
<StudentAddressLine4 />
<StudentAddressCity>New Town</StudentAddressCity>
<StudentAddressState>NJ</StudentAddressState>
<StudentAddressPostalCode>12345</StudentAddressPostalCode>
<StudentAddressCounty />
<StudentAddressCountry>United States</StudentAddressCountry>
<StudentHomePhoneNumber>1234567890</StudentHomePhoneNumber>
<StudentCellPhoneNumber>1234567890</StudentCellPhoneNumber>
</StudentData>
<ParentData>
<Parent>
<Parent1FirstName>Jane</Parent1FirstName>
<Parent1MiddleName />
<Parent1LastName>Smith</Parent1LastName>
<Parent1HomePhoneNumber>1234567890</
Parent1HomePhoneNumber>
<Parent1WorkPhoneNumber />
<Parent1EmailType>Personal</Parent1EmailType>
<Parent1EmailAddress>john@xxxxxx</
Parent1EmailAddress>
</Parent>
<Parent>
<Parent2FirstName>John Sr</Parent2FirstName>
<Parent2MiddleName />
<Parent2LastName>Smith</Parent2LastName>
<Parent2HomePhoneNumber>1234567890</
Parent2HomePhoneNumber>
<Parent2WorkPhoneNumber />
<Parent2EmailType>Personal</Parent2EmailType>
<Parent2EmailAddress>johnsr@xxxxxx</
Parent2EmailAddress>
</Parent>
</ParentData>
</Data>

Can someone please help me figure out how to impose this structure
upon the XML I get from the dataset returned by my stored procedure?
Thanks in advance for your anticipated assistance!

You need to either

1. Create a STRONG (or TYPED) dataset, and populate it.

Add new item / DataSet / "Data"<<this is the name of the dataset.

(although I wouldn't call it "Data", that's about the most ambiguous word on
the planet.

Add tables. StudentData and ParentData

2. Do an xml to xml transformation

http://sholliday.spaces.live.com/Blo...842A!148.entry






<emailhelen@xxxxxx> wrote in message
news:5e66c5cf-aa57-4603-86b5-a7db7a8209dc@xxxxxx