Problem displaying XML API in asp.net

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

City: <%#Container.DataItem("name")%>
Below is the extract of the XML from the API URL
...
...
Pisa Holidays
Pisa Holidays
http://me.jpg
Please help me to solve this problem
1 Reply
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Sign in Create an account
Dipankar Biswas11y ago
hi
check this links. to help...https://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.xmldatasource(v=vs.110).aspx

http://www.aspsnippets.com/Articles/How-to-use-XmlDataSource-Control-in-ASPNet-Example.aspx

http://www.codeproject.com/Articles/4902/Reading-an-XML-file-using-NET
name