Transforming XML and display as a label in ASPX page

[Guest]

Hi all,

Can I get XML data from an external XML file loaded in an ASPX page to be
displayed as a "Label"?
I don't want to use the XML control <asp:xml>, but a label in order to
display the source.

Here comes the example XML file:
http://webservices.amazon.de/onca/x...kup&ItemId=B0001BXYQ0&ResponseGroup=SalesRank

I want to put the SalesRank value into my label.

Great thanks,
Uwe

 

[Martin Honnen]

Can I get XML data from an external XML file loaded in an ASPX page to be
displayed as a "Label"?
I don't want to use the XML control <asp:xml>, but a label in order to
display the source.

Here comes the example XML file:
http://webservices.amazon.de/onca/x...kup&ItemId=B0001BXYQ0&ResponseGroup=SalesRank

I want to put the SalesRank value into my label.

Here is an example using XPathDocument to read out the SalesRank:

<%@ Page Language="C#" Debug="True" %>
<%@ Import Namespace="System.Xml" %>
<%@ Import Namespace="System.Xml.XPath" %>
<script runat="server">
void Page_Load () {
XPathDocument amazonResult = new
XPathDocument(@"http://webservices.amazon.de/onca/x...kup&ItemId=B0001BXYQ0&ResponseGroup=SalesRank");
XPathNavigator xpathNavigator = amazonResult.CreateNavigator();
XPathExpression xpathExpression =
xpathNavigator.Compile(@"/am:ItemLookupResponse/am:Items/am:Item/am:SalesRank/text()");
XmlNamespaceManager namespaceManager = new
XmlNamespaceManager(xpathNavigator.NameTable);
namespaceManager.AddNamespace("am",
"http://xml.amazon.com/AWSECommerceService/2004-08-01");
xpathExpression.SetContext(namespaceManager);
XPathNodeIterator nodeIterator = xpathNavigator.Select(xpathExpression);
if (nodeIterator.MoveNext()) {
Label1.Text = nodeIterator.Current.Value;
}
}
</script>
<form runat="server">
<asp:Label runat="server" id="Label1" />
</form>