I want to import data from a xml file into a datasetthis is my xml file
<?xml version="1.0" encoding="UTF-8" standalone="no"?><Persons> <Person Personid="10"> <firstname>Hi</firstname> <lastname>bye</lastname> <Birthday>1360 </Birthday> <Phones> <Fax>04</Fax> <Other>05</Other> <Home>01</Home> </Phones> <Emails> <Email>[email protected]</Email> </Emails> <Webs> <Web>web.com</Web> </Webs> </Person> </Persons>
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<Persons>
<Person Personid="10">
<firstname>Hi</firstname>
<lastname>bye</lastname>
<Birthday>1360 </Birthday>
<Phones>
<Fax>04</Fax>
<Other>05</Other>
<Home>01</Home>
</Phones>
<Emails>
<Email>[email protected]</Email>
</Emails>
<Webs>
<Web>web.com</Web>
</Webs>
</Person>
</Persons>
when I use this code dataset1.readxml(FilePath); I have these tables in my datasetPerson,Phones,Emails,WebsBut I want to have FIVE (more) tables for Fax,Mobile,House,Email,Webthat ARE connected to "Person" table (Fax,Mobile,House are connected to Phones , Email to Emails AND Web to Webs)
when the xml file is like below it has these tables:
Person,Phones,Emails,Webs,Fax,Mobile,House,Email,Web{ Emails connects to Email},{ Webs connects to Web } AND { Phones connects to fax,house and mobile }
<?xml version="1.0" encoding="UTF-8" standalone="no"?><Persons> <Person Personid="10"> <firstname>hi</firstname> <lastname>bye</lastname> <Birthday>1980 </Birthday> <Phones> <Fax>044</Fax> <Mobile>055</Mobile> <House>011</House> <Fax>04</Fax> <Mobile>05</Mobile> <House>01</House> </Phones> <Emails> <Email>[email protected]</Email> <Email>[email protected]</Email> </Emails> <Webs> <Web>web1.com</Web> <Web>web2.com</Web> </Webs> </Person></Persons>
<firstname>hi</firstname>
<Birthday>1980 </Birthday>
<Fax>044</Fax>
<Mobile>055</Mobile>
<House>011</House>
<Mobile>05</Mobile>
<House>01</House>
<Web>web1.com</Web>
<Web>web2.com</Web>
I want to always have these tablesis there any way?