Converting XML > Dataset

[Christoph Duesmann]

Hi !

Here's my problem in english :-)

I want to convert the mssecure.xml file from Microsoft into an dataset to
store it in an SQL-Database.
My code in VB looks like this :

Dim ds As New DataSet
Dim doc As New Xml.XmlDocument
doc.Load("D:\mssecure.xml")
Dim sReader As New StringReader(doc.InnerXml)
ds.ReadXml(sReader)

The problem is : At the ds.readxml(sreader) command i get an error which
told me, that there is an problem whith a relationship in "ProductFamilies"

I hope my english is good enough to explain...

Please help !

Thanks !!!

Christoph Duesmann

[Oleg Tkachenko [MVP]]

Christoph Duesmann wrote:

Dim ds As New DataSet
Dim doc As New Xml.XmlDocument
doc.Load("D:\mssecure.xml")
Dim sReader As New StringReader(doc.InnerXml)
ds.ReadXml(sReader)

That's weird. You load XML into XmlDocument, then serialize back to
string and read that string to DataSet? Why not just

ds.ReadXml("D:\mssecure.xml")

--
Oleg Tkachenko [XML MVP]
http://blog.tkachenko.com

[Christoph Duesmann]

Hi Oleg !

That's weird. You load XML into XmlDocument, then serialize back to string
and read that string to DataSet? Why not just

ds.ReadXml("D:\mssecure.xml")

I tried it but i get the same Error-Message during debugging.
Try it yourself, to bind the mssecure.xml into an Dataset

Thank for your next answer :-)

christoph

[Oleg Tkachenko [MVP]]

Christoph Duesmann wrote:

That's weird. You load XML into XmlDocument, then serialize back to string
and read that string to DataSet? Why not just

ds.ReadXml("D:\mssecure.xml")

I tried it but i get the same Error-Message during debugging.
Try it yourself, to bind the mssecure.xml into an Dataset

Oh, you mean the mssecure.xml? :)

I believe you can't load it to DataSet. Its schema is a recursive one
and DataSet can only handle relational schemas. But I may be wrong.

--
Oleg Tkachenko [XML MVP]
http://blog.tkachenko.com

[Christoph Duesmann]

Hi Oleg !

I believe you can't load it to DataSet. Its schema is a recursive one and
DataSet can only handle relational schemas. But I may be wrong.

If a dataset doesn't work : What would you do store the xml-Data (like
Patchname, downloadlocation etc) in an Database ?

Thanks !

Christoph

[Christoph Duesmann]

Idea : If i remove the ProductFamilies Section from the xml document then
databinding functions correct !!!
Now tell me how to remove this section programmaticly...

This is the section :

<ProductFamilies>
<ProductFamily ProductFamilyID="1" Name="Windows NT"
RecentProductVersionID=""/>
<ProductFamily ProductFamilyID="2" Name="Windows 2000"
RecentProductVersionID=""/>
<ProductFamily ProductFamilyID="3" Name="Windows 9x"
RecentProductVersionID=""/>
<ProductFamily ProductFamilyID="4" Name="Windows XP"
RecentProductVersionID=""/>
...
...
...
</ProductFamilies>

thanks

Christoph

[Stuart Celarier]

"Christoph Duesmann" <c.********@web.de> wrote in message
news:uh****************@TK2MSFTNGP15.phx.gbl...

Idea : If i remove the ProductFamilies Section from the xml document then
databinding functions correct !!!
Now tell me how to remove this section programmaticly...

This is the section :

<ProductFamilies>
...
</ProductFamilies>

One way you can remove the <ProductFamilies> element programmatically is to
use an XSLT transform like this:

<xsl:transform xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<!-- the identity transform -->
<xsl:template match="node()|@*">
<xsl:copy>
<xsl:apply-templates select="node()|@*/>
</xsl:copy>
</xsl:template>

<!-- discard the ProductFamilies element and its children -->
<xsl:template match="ProductFamilies"/>

</xsl:transform>

Alternately, you could load the XML into an XmlDocument and remove the
offending element, or

Cheers,
Stuart Celarier, Fern Creek