Error loading XML into DataSet

[Kathryn]

Hello,

When I try to load this xml file (see below) into an asp.net dataset
using the following code:

ds.ReadXml("xmlfilepath\xmlfile.xml", XmlReadMode.Auto)

I get the following error:

"The same table (description) cannot be the child table in two nested
relations. "

If I take out the anchor tag in the description it works fine,
however, I need the anchor tag in there. Does
anyone have any suggestions?

<?xml version="1.0" ?>
<rss version="2.0">
<channel>
<title>Liftoff News</title>
<link>http://liftoff.msfc.nasa.gov/</link>
<description>Liftoff to Space Exploration.</description>
<language>en-us</language>
<pubDate>Tue, 10 Jun 2003 04:00:00 GMT</pubDate>
<lastBuildDate>Tue, 10 Jun 2003 09:41:01 GMT</lastBuildDate>
<docs>http://blogs.law.harvard.edu/tech/rss</docs>
<generator>Weblog Editor 2.0</generator>
<managingEditor>ed****@example.com</managingEditor>
<webMaster>we*******@example.com</webMaster>
<item>
<title>Star City</title>
<link>http://liftoff.msfc.nasa.gov/news/2003/news-starcity.asp</link>
<description>How do Americans get ready to work with Russians aboard
the International Space Station? They take a crash course in culture,
language and protocol at Russia's <a
href="http://howe.iki.rssi.ru/GCTC/gctc_e.htm">Star
City</a>.</description>
<pubDate>Tue, 03 Jun 2003 09:39:21 GMT</pubDate>
<guid>http://liftoff.msfc.nasa.gov/2003/06/03.html#item573</guid>
</item>
</channel>
</rss>

Thanks in advance.

[Christoph Schittko [MVP]]

Do you really have to read your XML document into a DataSet? What are you
trying to do with the DataSet after you loaded the XML?

--
HTH
Christoph Schittko [MVP]
Software Architect, .NET Mentor

"Kathryn" <kb********@yahoo.com> wrote in message
news:5d*************************@posting.google.co m...

Hello,

When I try to load this xml file (see below) into an asp.net dataset
using the following code:

ds.ReadXml("xmlfilepath\xmlfile.xml", XmlReadMode.Auto)

I get the following error:

"The same table (description) cannot be the child table in two nested
relations. "

If I take out the anchor tag in the description it works fine,
however, I need the anchor tag in there. Does
anyone have any suggestions?

<?xml version="1.0" ?>
<rss version="2.0">
<channel>
<title>Liftoff News</title>
<link>http://liftoff.msfc.nasa.gov/</link>
<description>Liftoff to Space Exploration.</description>
<language>en-us</language>
<pubDate>Tue, 10 Jun 2003 04:00:00 GMT</pubDate>
<lastBuildDate>Tue, 10 Jun 2003 09:41:01 GMT</lastBuildDate>
<docs>http://blogs.law.harvard.edu/tech/rss</docs>
<generator>Weblog Editor 2.0</generator>
<managingEditor>ed****@example.com</managingEditor>
<webMaster>we*******@example.com</webMaster>
<item>
<title>Star City</title>
<link>http://liftoff.msfc.nasa.gov/news/2003/news-starcity.asp</link>
<description>How do Americans get ready to work with Russians aboard
the International Space Station? They take a crash course in culture,
language and protocol at Russia's <a
href="http://howe.iki.rssi.ru/GCTC/gctc_e.htm">Star
City</a>.</description>
<pubDate>Tue, 03 Jun 2003 09:39:21 GMT</pubDate>
<guid>http://liftoff.msfc.nasa.gov/2003/06/03.html#item573</guid>
</item>
</channel>
</rss>

Thanks in advance.

[Christoph Schittko [MVP]]

Do you really have to read your XML document into a DataSet? What are you
trying to do with the DataSet after you loaded the XML?

--
HTH
Christoph Schittko [MVP]
Software Architect, .NET Mentor

"Kathryn" <kb********@yahoo.com> wrote in message
news:5d*************************@posting.google.co m...

Hello,

When I try to load this xml file (see below) into an asp.net dataset
using the following code:

ds.ReadXml("xmlfilepath\xmlfile.xml", XmlReadMode.Auto)

I get the following error:

"The same table (description) cannot be the child table in two nested
relations. "

If I take out the anchor tag in the description it works fine,
however, I need the anchor tag in there. Does
anyone have any suggestions?

<?xml version="1.0" ?>
<rss version="2.0">
<channel>
<title>Liftoff News</title>
<link>http://liftoff.msfc.nasa.gov/</link>
<description>Liftoff to Space Exploration.</description>
<language>en-us</language>
<pubDate>Tue, 10 Jun 2003 04:00:00 GMT</pubDate>
<lastBuildDate>Tue, 10 Jun 2003 09:41:01 GMT</lastBuildDate>
<docs>http://blogs.law.harvard.edu/tech/rss</docs>
<generator>Weblog Editor 2.0</generator>
<managingEditor>ed****@example.com</managingEditor>
<webMaster>we*******@example.com</webMaster>
<item>
<title>Star City</title>
<link>http://liftoff.msfc.nasa.gov/news/2003/news-starcity.asp</link>
<description>How do Americans get ready to work with Russians aboard
the International Space Station? They take a crash course in culture,
language and protocol at Russia's <a
href="http://howe.iki.rssi.ru/GCTC/gctc_e.htm">Star
City</a>.</description>
<pubDate>Tue, 03 Jun 2003 09:39:21 GMT</pubDate>
<guid>http://liftoff.msfc.nasa.gov/2003/06/03.html#item573</guid>
</item>
</channel>
</rss>

Thanks in advance.

[Scott Wade]

I'm trying to accomplish the same task and I'm receiving the same error.
I'm new to VB.Net programming and I'm trying to learn the best practices
for parsing out XML files. By reading the XML file into a DataSet, I
figured it would be easy to process tables inside a DataSet since I'm
familar with processing DataSets.

My final result is populating some tables in our database based on the
data in the XML file. Please offer some other suggestions (& reasons)
for accomplishing this task.

Thanks in advance.


*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

[Scott Wade]

I'm trying to accomplish the same task and I'm receiving the same error.
I'm new to VB.Net programming and I'm trying to learn the best practices
for parsing out XML files. By reading the XML file into a DataSet, I
figured it would be easy to process tables inside a DataSet since I'm
familar with processing DataSets.

My final result is populating some tables in our database based on the
data in the XML file. Please offer some other suggestions (& reasons)
for accomplishing this task.

Thanks in advance.


*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!