LoadXML 2nd try

[Hannes [MVP]]

Problem with reading a RSS

Dim reader As XmlTextReader = New
XmlTextReader(http://weblogs.asp.net/hpreishuber/Rss.aspx")

ds1.ReadXml(reader)


Error

A column named 'comments' already belongs to this DataTable.

this is cause on field comments is with namespace
any workaorund/solution??

--
Gruss Hannes
www.asp-konferenz.de - das Event für den MS Webentwickler
www.aspnet-professional.de - das Magazin
www.devtrain.de ASP und .NET Community Site
www.vbmoves.de VB bewegt sich doch
www.ppedv.de Company Site

 

[Miha Markic]

Hi Hannes,

A really simple solution would be to do search and replace of one comment
variation to some other name (i.e. wfw: comment -> wfwcomment) before
loading data.
Maybe there is another better solution, I don't know.

 

[Guest]

Hi,

First things first.

Make sure that the XML is valid. You can't do anything
with the XML file unless it's valid XML. You can check
this by loading the XML file into VStudio and clicking the
Data tab at the bottom of the screen.

 

[Hannes [MVP]]

yes i know that xml mus be valid (to be xml)
as everyone can see the result of the web page is a valid xml
the problem is the used namespace


--
Gruss Hannes
www.asp-konferenz.de - das Event für den MS Webentwickler
www.aspnet-professional.de - das Magazin
www.devtrain.de ASP und .NET Community Site
www.vbmoves.de VB bewegt sich doch
www.ppedv.de Company Site
Hi,

First things first.

Make sure that the XML is valid. You can't do anything
with the XML file unless it's valid XML. You can check
this by loading the XML file into VStudio and clicking the
Data tab at the bottom of the screen.