Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

RSS feeds:A column named 'link' already belongs to this DataTable: cannot set a nested table name to the same name.

Posted on 2011-05-01
2
Medium Priority
?
2,228 Views
Last Modified: 2012-06-27
Hi,

I am trying to consume RSS feeds from different sites.
With the same code some are working and others are failing.
Error:
A column named 'link' already belongs to this DataTable: cannot set a nested table name to the same name.

How to fix this issue?

Thanks
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

        gdv_RSS.DataSource = GetRSsFeeds()
        gdv_RSS.DataBind()
        'GetRSsFeeds()

    End Sub



    Private Function GetRSsFeeds() As DataTable

        Dim xmlRead As New XmlTextReader(myurl)
        Dim ds As New DataSet
        ds.ReadXml(xmlRead)
        Return ds.Tables(3)

    End Function

Open in new window

0
Comment
Question by:rowternet
2 Comments
 
LVL 42

Accepted Solution

by:
dqmq earned 1000 total points
ID: 35501023
The problem occurs when the XML feed contains a structure that is incompatible with a datatables.  For example:


<document>
  <link>                   <--an ordinary column
  </link>
  <namelist>                    
      <link>     <--an embedded table
         <name1>
          </name1>
          <name2>
          </name2>
       </link>
      <link>     <--an embedded table
         <name1>
          </name1>
          <name2>
          </name2>
       </link>


     (/namelist>

</document>

Unfortunately, I don't know a workaround.  I checked the web and you may get better results with net 1.0
0
 

Author Closing Comment

by:rowternet
ID: 35828169
Thanks
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes relatively difficult and non-obvious issues that are likely to arise when creating COM class in Visual Studio and deploying it by professional MSI-authoring tools. It is assumed that the reader is already familiar with the cla…
For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses
Course of the Month20 days, 15 hours left to enroll

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question