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:\ms secure.xml")
Dim sReader As New StringReader(do c.InnerXml)
ds.ReadXml(sRea der)

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

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:\ms secure.xml")
Dim sReader As New StringReader(do c.InnerXml)
ds.ReadXml(sRea der)

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, downloadlocatio n 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 :

<ProductFamilie s>
<ProductFamil y ProductFamilyID ="1" Name="Windows NT"
RecentProductVe rsionID=""/>
<ProductFamil y ProductFamilyID ="2" Name="Windows 2000"
RecentProductVe rsionID=""/>
<ProductFamil y ProductFamilyID ="3" Name="Windows 9x"
RecentProductVe rsionID=""/>
<ProductFamil y ProductFamilyID ="4" Name="Windows XP"
RecentProductVe rsionID=""/>
...
...
...
</ProductFamilies >

thanks

Christoph

[Stuart Celarier]

"Christoph Duesmann" <c.********@web .de> wrote in message
news:uh******** ********@TK2MSF TNGP15.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 :

<ProductFamilie s>
...
</ProductFamilies >

One way you can remove the <ProductFamilie s> element programmaticall y is to
use an XSLT transform like this:

<xsl:transfor m 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="ProductF amilies"/>

</xsl:transform>

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

Cheers,
Stuart Celarier, Fern Creek