Question How to get specific data from XML?

[raysefo]

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.

 

[cjard]

To make it easier to deal with:

Use the WebClient to download the XML
Use DataSet's ReadXml() method to read the xml into a dataset/table

You can then put a breakpoint in your code, and when the code stops, point to the dataset variable. When the tooltip appears, cick the magnifying glass it contains.. That opens the dataset visualizer and you can see how the data is shaped, and access it with e.g.:

myDataset.Tables("Currency").Select("[Kod] = 'USD'")

Or something...