How to get specific data from XML?

Question

Hi,

I want to get specific data from an xml source on the web. (http://www.tcmb.gov.tr/kurlar/today.xml) What i would like to get is, exactly USD forexselling and EUR forexselling values then insert into a table in db. I would be glad if anyone can help.

Thanks in advance.

Best Regards.

Here is my code;
<

static void Main(string[] args)
        {
            XmlTextReader rdr = new XmlTextReader(" http://www.tcmb.gov.tr/kurlar/today.xml");

 
            while (rdr.Read())
            {
                if (rdr.NodeType.Equals(XmlNodeType.XmlDeclaration))
                {
                    rdr.Skip();
                }
                else
                {
                    switch (rdr.Name)
                    {
                        case "Isim": Console.WriteLine(rdr.Name);
 
                            Console.WriteLine(rdr.Value);
                            break;
                        case "ForexSelling": Console.WriteLine(rdr.Name);
                            Console.WriteLine(rdr.Value);
                            break;
 
                        case "Döviz Satis": Console.WriteLine("Döviz Satis");
                            if (rdr.HasAttributes)    // This fails every time
                                Console.WriteLine("Attribute @type: " + rdr.GetAttribute("Type"));
                            break;
                    }
                }
            }
        }