ReadXml to read recurring occurences of same tag?

[Vinit]

Hello,

I have an xml file with the following snippet:

....... some tags
<ListItems>
<item> 1 </item>
<item> 2 </item>
<item> 3 </item>
</ListItems>

I need to populate a dataset containing a table with one column "Item"
with rows containining data from the item tag....i.e. 1,2,3.

if i Create a DataTable named "ListItems" and a column element in it
named "item" then only the first value is read.

if i Create a DataTable named "item" then no values are read but
exactly the same no. of rows are created in the grid having this
dataset as the source..... this is definitely a good sign as now I need
to get the data somehow.... but HOW?
Please help!

Thanks,
Vinit

[JuanDG]

Are you using DatSet.ReadXml() ?????

--

Juan David Gómez Arenas.
Ingeniero de Desarrollo
InterGrupo S.A. - Medellín
Visite nuestro sitio: www.intergrupo.com
"Vinit" <vi********@gmail.com> wrote in message
news:11*********************@g44g2000cwa.googlegro ups.com...

Hello,

I have an xml file with the following snippet:

...... some tags
<ListItems>
<item> 1 </item>
<item> 2 </item>
<item> 3 </item>
</ListItems>

I need to populate a dataset containing a table with one column "Item"
with rows containining data from the item tag....i.e. 1,2,3.

if i Create a DataTable named "ListItems" and a column element in it
named "item" then only the first value is read.

if i Create a DataTable named "item" then no values are read but
exactly the same no. of rows are created in the grid having this
dataset as the source..... this is definitely a good sign as now I need
to get the data somehow.... but HOW?
Please help!

Thanks,
Vinit

[Vinit]

Yes i am using dataset.readxml.

[Cerebrus99]

Hi Vinit,

If you are using DataSet.ReadXml, then there should be no problem.
This solution does not use a DataTable.
-----------------------------------------------------
Dim ds As DataSet = New DataSet()
ds.ReadXml("Temp.xml")

'Display the resulting Dataset into a Datagrid called dg
dg.DataSource = ds
dg.DataMember = "item"
------------------------------------------------------

Regards,

Cerebrus

[Vinit]

Well I figured it out ....I was using ReadXml with the default
ReadSchema mode.....i used the InferSchema as the XmlReadMode and it
worked fine.....

Thanks 2 all who replied!