renata fidelia

renata fidelia

  • NA
  • 1
  • 772

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)