Problem displaying XML API in asp.net

May 13 2015 4:09 AM

Hello sir,

I host in asphostportal.com

I have access to an XML API in the form of a URL link, so I am trying to display the data on the browser,

to start with, so to make sure the data is returned, but I keep getting the following error:

(name is neither a DataColumn nor a DataRelation for table result.).

It seems there is a problem with the node structure? Below is the ASP.NET page and also the xml file

sub Page_Load

if Not Page.IsPostBack then

dim myproducts=New DataSet

myproducts.ReadXml("http://api.example.c....0/products.xml")

products.DataSource=myproducts

products.DataBind()

end if

end sub

</script>

<html>

<body>

<form runat="server">

<asp:Repeater id="products" runat="server">

<HeaderTemplate>

<table border="1" width="100%">

<tr>

<th>name</th>

</tr>

</HeaderTemplate>

<ItemTemplate>

<tr>

<div>City: <%#Container.DataItem("name")%></div>

</ItemTemplate>

Below is the extract of the XML from the API URL

<result xmlns="urn:com:example:pf:model:xml:output" xmlns:ns2="urn:com:tradedoubler:pf:model:xml:common" version="3.0">

<productHeader>...</productHeader>

<products>

<product language="en">...</product>

<product language="en">

<ns2:name>Pisa Holidays</ns2:name>

<ns2:description>Pisa Holidays</ns2:description>

<ns2:productImage>

http://me.jpg

</ns2:productImage>

<ns2:categories>

Please help me to solve this problem

Answers (1)