How to convert the XML File in to the Dataset

[5555]

Hello i need urgent help

when i had convert the xml file to dataset like i used the
dtsXml.ReadXml("d:\\dog.xml") But it i had the problem

here the sample dog.xml file the problem i faced was only the <show> node has convert to the dataset but other nodes were leave it.

In the dataset 2 columns are created and only one row is added

Id Name
1 O'Reilly Invitational


I need all the rows are loaded in to the dataset using to below the xml file formot. But don't know the what are the nodes in the xml file, the nodes are going.............


<?xml version="1.0" standalone="yes"?>
<DogShow>
<Show>
<Id>1</Id>
<Name>O'Reilly Invitational</Name>
</Show>

<Breed>
<Id>1</Id>
<Name>English Springer Spaniel</Name>
</Breed>
<Dog>
<Id>1</Id>
<Name>Wil-Orion's Angus Highlander</Name>
<BreedId>1</BreedId>
</Dog>
<Dog>
<Id>2</Id>
<Name>Len-Lear's Webmaster</Name>
<BreedId>1</BreedId>
</Dog>
<Dog>
<Id>3</Id>
<Name>Ch. Sallylyn's Condor</Name>
<BreedId>1</BreedId>
</Dog>
<Judge>
<Id>1</Id>
<FirstName>John</FirstName>
<LastName>Smith</LastName>
</Judge>
<ShowRing>
<Id>1</Id>
<Name>Ring 1</Name>
</ShowRing>
<Judging>
<ShowTime>2002-10-20T14:00:00.0000000-04:00</ShowTime>
<BreedId>1</BreedId>
<JudgeId>1</JudgeId>
<ShowRingId>1</ShowRingId>
<ShowId>1</ShowId>
</Judging>
</DogShow>

[vijaydiwakar]

Hello i need urgent help

when i had convert the xml file to dataset like i used the
dtsXml.ReadXml("d:\\dog.xml") But it i had the problem

here the sample dog.xml file the problem i faced was only the <show> node has convert to the dataset but other nodes were leave it.

In the dataset 2 columns are created and only one row is added

Id Name
1 O'Reilly Invitational


I need all the rows are loaded in to the dataset using to below the xml file formot. But don't know the what are the nodes in the xml file, the nodes are going.............


<?xml version="1.0" standalone="yes"?>
<DogShow>
<Show>
<Id>1</Id>
<Name>O'Reilly Invitational</Name>
</Show>

<Breed>
<Id>1</Id>
<Name>English Springer Spaniel</Name>
</Breed>
<Dog>
<Id>1</Id>
<Name>Wil-Orion's Angus Highlander</Name>
<BreedId>1</BreedId>
</Dog>
<Dog>
<Id>2</Id>
<Name>Len-Lear's Webmaster</Name>
<BreedId>1</BreedId>
</Dog>
<Dog>
<Id>3</Id>
<Name>Ch. Sallylyn's Condor</Name>
<BreedId>1</BreedId>
</Dog>
<Judge>
<Id>1</Id>
<FirstName>John</FirstName>
<LastName>Smith</LastName>
</Judge>
<ShowRing>
<Id>1</Id>
<Name>Ring 1</Name>
</ShowRing>
<Judging>
<ShowTime>2002-10-20T14:00:00.0000000-04:00</ShowTime>
<BreedId>1</BreedId>
<JudgeId>1</JudgeId>
<ShowRingId>1</ShowRingId>
<ShowId>1</ShowId>
</Judging>
</DogShow>

budy the problem is that with the new tag every time the new table is created u've to change the structure of thy xml file
with the above structure show becomes one tbl,brid become another tbl

so just change the structure and u will get the desired o/p