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("xml filepath\xmlfil e.xml", XmlReadMode.Aut o)

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>Liftof f News</title>
<link>http://liftoff.msfc.na sa.gov/</link>
<description>Li ftoff 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.harva rd.edu/tech/rss</docs>
<generator>Webl og Editor 2.0</generator>
<managingEditor >ed****@example .com</managingEditor>
<webMaster>we** *****@example.c om</webMaster>
<item>
<title>Star City</title>
<link>http://liftoff.msfc.na sa.gov/news/2003/news-starcity.asp</link>
<description>Ho w 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.r u/GCTC/gctc_e.htm">Sta r
City</a>.</description>
<pubDate>Tue, 03 Jun 2003 09:39:21 GMT</pubDate>
<guid>http://liftoff.msfc.na sa.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********@yah oo.com> wrote in message
news:5d******** *************** **@posting.goog le.com...

Hello,

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

ds.ReadXml("xml filepath\xmlfil e.xml", XmlReadMode.Aut o)

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>Liftof f News</title>
<link>http://liftoff.msfc.na sa.gov/</link>
<description>Li ftoff 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.harva rd.edu/tech/rss</docs>
<generator>Webl og Editor 2.0</generator>
<managingEditor >ed****@example .com</managingEditor>
<webMaster>we** *****@example.c om</webMaster>
<item>
<title>Star City</title>
<link>http://liftoff.msfc.na sa.gov/news/2003/news-starcity.asp</link>
<description>Ho w 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.r u/GCTC/gctc_e.htm">Sta r
City</a>.</description>
<pubDate>Tue, 03 Jun 2003 09:39:21 GMT</pubDate>
<guid>http://liftoff.msfc.na sa.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********@yah oo.com> wrote in message
news:5d******** *************** **@posting.goog le.com...

Hello,

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

ds.ReadXml("xml filepath\xmlfil e.xml", XmlReadMode.Aut o)

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>Liftof f News</title>
<link>http://liftoff.msfc.na sa.gov/</link>
<description>Li ftoff 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.harva rd.edu/tech/rss</docs>
<generator>Webl og Editor 2.0</generator>
<managingEditor >ed****@example .com</managingEditor>
<webMaster>we** *****@example.c om</webMaster>
<item>
<title>Star City</title>
<link>http://liftoff.msfc.na sa.gov/news/2003/news-starcity.asp</link>
<description>Ho w 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.r u/GCTC/gctc_e.htm">Sta r
City</a>.</description>
<pubDate>Tue, 03 Jun 2003 09:39:21 GMT</pubDate>
<guid>http://liftoff.msfc.na sa.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!