Web service xml currency

Question

0.00/5 (No votes)

See more:

I need a c# metod that returns the rate based on the desc as an input parameter from this XML file, http://www.nationalbanken.dk/dndk/valuta.nsf/valuta.xml[^]
i am new to XML, and i have looked at several exampels, but no luck.

Please help

This is what my method looks like so far, dosent work..

C#

[WebMethod]
        public string test2(string test)
        {

         XmlTextReader reader = new XmlTextReader("http://www.nationalbanken.dk/dndk/valuta.nsf/valuta.xml");
         
      while(reader.Read())
      {
          if (reader.NodeType == XmlNodeType.Element)
          {
              if (reader.Name == "dailyrates")
              {
                  return reader.GetAttribute(test);
                 
              }
          }
      }

Posted 13-Dec-12 2:50am

Jesper Schlütter

Updated 13-Dec-12 3:00am

Krunal Rohit

v2

Add a Solution

Comments

Richard MacCutchan 13-Dec-12 9:02am

dosent work.
Which is not a very good description. Please edit your post and explain exactly what results you expect and what you get.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Fredrik Bornander · Accepted Answer · 2012-12-13T05:57:00

XPath is your friend, here's a small app that fetches the rate from that source;

C#

using System;
using System.Globalization;
using System.Xml;
using System.Xml.XPath;

namespace XmlTest
{
    class Program
    {
        static decimal GetRate(string code)
        {
            XPathDocument document = new XPathDocument("http://www.nationalbanken.dk/dndk/valuta.nsf/valuta.xml");
            XPathNavigator navigator = document.CreateNavigator();

            XmlNamespaceManager manager = new XmlNamespaceManager(navigator.NameTable);
            manager.AddNamespace("xsi", "http://www.w3.org/2001/XMLSchema-instance");

            XPathNavigator node = navigator.SelectSingleNode(String.Format("/exchangerates/dailyrates/currency[@code='{0}']/@rate", code), manager);
            return Decimal.Parse(node.Value, NumberStyles.AllowDecimalPoint, CultureInfo.GetCultureInfoByIetfLanguageTag("da-DK"));
        }

        static void Main(string[] args)
        {
            decimal rate = GetRate("EUR");
            Console.WriteLine("Rate=" + rate);
        }
    }
}

Hope this helps,
Fredrik Bornander