Need help with XML format in vb.net

Originally Posted by

>I have the following code:
>
Dim ds As New Data.DataSet("inventory")
Dim dt As New Data.DataTable("desk")
>
'dt.TableName = "desk"
With dt
.Columns.Add("item")
.Columns.Add("qty")
End With
dt.Rows.Add(New Object() {"Paper Clip", 100})
dt.Rows.Add(New Object() {"Stapler", 1})
dt.Rows.Add(New Object() {"Tape", 2})
ds.Tables.Add(dt)
>
>
At this point, ds.GetXml will produces the following XML:
>
<inventory>
<desk>
<item>Paper Clip</item>
<qty>100</qty>
</desk>
<desk>
<item>Stapler</item>
<qty>1</qty>
</desk>
<desk>
<item>Tape</item>
<qty>2</qty>
</desk>
</inventory>
>
What is the best way with VB.net to make the XML look like this
instead:
>
<inventory>
<desk>
<item qty='100'>Paper Clip</item>
<item qty='1'>Stapler</item>
<item qty='2'>Tape</item>
</desk>
</inventory>
>

Originally Posted by

1. *Don't use a dataset. *Its element based. *Use XmlDocument instead (or
XmlWriter or other)
2. *Transform it.http://sholliday.spaces.live.com/Blog/cns!A68482B9628A842A!148.entry
>
<abaker.j...@gmail.comwrote in message
>
news:f6c69e12-b2ab-4360-8726-9d18c49d1ca2@a70g2000hsh.googlegroups.com...
>
>
>
>
>
>
>
>
>
>
- Show quoted text -

Originally Posted by

On Aug 21, 3:33*pm, "sloan" <sl...@ipass.netwrote:
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
Can someone give me an xslt file that I can use to convert the first
example to the second example?- Hide quoted text -
>
- Show quoted text -