Comments by hm9 (Top 18 by date)

below is the code just give you context. The url is correcct but It doesnt appear to be getting the values from the xml but I am sure it worked before...

<%@ Page Language="VB" ContentType="text/html" ResponseEncoding="iso-8859-1" Debug="true" %>

<%@ import Namespace="System.Data" %>
<%@ import Namespace="System" %>
<%@ import Namespace="System.IO" %>
<%@ import Namespace="System.Web.UI.WebControls" %>
<%@ import Namespace="System.Xml" %>
<%@ import Namespace="System.Net.HttpWebResponse" %>
<%@ import Namespace="System.Linq" %>
<%@ import Namespace="System.Configuration"%>
<%@ Import Namespace="System.Xml.XLinq"%>
<%@ Import Namespace="System.Xml.Linq"%>
<%@ Import Namespace="System.Xml.XPath"%>


Sub Button_Click( s As Object, e As EventArgs )
if IsValid then

response.redirect("redirecting2.aspx")
end if
end sub








sub Page_Load
if Not Page.IsPostBack then




Dim doc As New XmlDocument()
doc.Load("https://api.tradedoubler.com/1.0/products.xml;q=hotels?token=A87185243749DAC9685310F6FEEB7F9038DD7F88")
Dim nsManager As New XmlNamespaceManager(doc.NameTable)
nsManager.AddNamespace("ns1", "urn:com:tradedoubler:pf:model:xml:output")
nsManager.AddNamespace("ns2", "urn:com:tradedoubler:pf:model:xml:common")
Dim nodes As XmlNodeList = doc.SelectNodes("//ns1:products/ns1:product", nsManager)

Dim dataSource As IEnumerable
dataSource = From node As XmlNode in nodes
Select Name = node.SelectSingleNode("ns2:name", nsManager).InnerText, _
Description = node.SelectSingleNode("ns2:description", nsManager).InnerText, _
Image = node.SelectSingleNode("ns2:productImage", nsManager).InnerText, _
Price = node.SelectSingleNode("ns1:offers/ns1:offer/ns1:priceHistory/ns2:price", nsManager).InnerText, _
ProductUrl = node.SelectSingleNode("ns1:offers/ns1:offer/ns2:productUrl", nsManager).InnerText, _
Logo = node.SelectSingleNode("ns1:offers/ns1:offer/ns2:programLogo", nsManager).InnerText
rpMyRepeater.DataSource = dataSource
rpMyRepeater.DataBind()
doc.RemoveAll()
Dispose()

End if
end sub


<asp:repeater id="rpMyRepeater" onitemcommand="Button_Click" runat="Server">

<headertemplate>



<itemtemplate>








<footertemplate>

Image

Name

Description

Price

Provider

Link

<asp:image runat="server" width="100" height="100"
="" imageurl="<%# Eval("Image") %>">
<%# Eval("Name") %>



<%#Eval("Description").ToString().PadLeft(140).Substring(0,140).TrimEnd()%>....

£<%# Eval("Price") %> <asp:image runat="server" width="130" onclick="Button_Click" imageurl="<%# Eval("logo")%>">
" target="_blank" ">Go To Website

Everything works in the code apart from the url i posted. It doesnt like the url for some reason even though it works on the browser!

The xml file is in this link:

http://api.tradedoubler.com/1.0/products.xml?token=96CC0E0A10851500F10431D64EC5585BFC8597DF"

Hi Richard, Just realised I also want to retrieve the values of price, productUrl but these are under offers/offer namespace. how do I achieve this? I tried adding it to the XmlNodeList but then i will miss the other elements directly under product. Thanks

You are right it wasn't using 3.5. Changed it and it worked. Thanks again

Ok I tried that but still the same error. One thing may be is the ns1 namespace. This isn't on the xml ? but as you stated, it works on your environment

3.5 I am using it on a local server. Does it work on yours?

Its just I get the error: Name 'From' is not declared.

Thanks Richard. I assume there is a typo in the line below?:

dataSource = From node As XmlNode in nodes

Would it be possible to adapt my code to work with xmlnamespaceManager. I don't know c# only VB.net.

Its in the URL link

http://api.tradedoubler.com/1.0/products.xml?token=96CC0E0A10851500F10431D64EC5585BFC8597DF

Ok I corrected the syntax now. Regarding the xml, below is an extract of the xml file, I am trying to access. The nodes I am trying to get to is products/product and the value of ns2:description is what i want to output. but it doesnt show anything on the page. I did change the 'description' for 'ns2:description' but it didnt make a difference

<result xmlns="urn:com:trade:pf:model:xml:output" xmlns:ns2="urn:com:trade:pf:model:xml:common" version="3.0">
<productHeader>
<totalhits>591727
</productHeader>
<products>
<product language="en">
<ns2:name>La Roche Posay
<ns2:description>
La Roche Posay - Effaclar H etc

Ok thanks I corrected the code as you suggested and the error is cleared but it is complaining about this line:

<![CDATA[<%# ((System.Xml.XmlNode)Container.DataItem).Attributes["description"].Value %>]]>

The error:
'XmlNode' is a type in 'Xml' and cannot be used as an expression.

any ideas? is it syntax issue?