Read from XML instead of JSON C# asp.net

Question

Hi,

Today I have a code that retrieves the JSON data from a URL. It works perfectly.

But now I want to do just the same, but I want to retrieve from an XML instead of JSON.

How do I do it the best way?

Thanks in advance,

Json URL: http://api.namnapi.se/v2/names.json?limit=3
XML URL: http://api.namnapi.se/v2/names.xml?limit=3

    public class Data
    {
        public List<Objects> names { get; set; }
    }

    public class Objects
    {
        public string firstname { get; set; }
        public string surname { get; set; }
    }

    protected void Page_Load(object sender, EventArgs e)
    {

        WebClient client = new WebClient();
        string json = client.DownloadString("http://api.namnapi.se/v2/names.json?limit=3");

        Data result = new System.Web.Script.Serialization.JavaScriptSerializer().Deserialize<Data>(json);

        foreach (var item in result.names)
        {
            Label.Text += (item.firstname + " " + item.surname + "<br />");
        }

    }

Use XmlSerializer Class https://msdn.microsoft.com/en-us/library/system.xml.serialization.xmlserializer(v=vs.110).aspx — Sybren, Oct 06 '15 at 11:21

score 1 · Answer 1 · edited May 23 '17 at 12:22

There are several ways to parse your XML in C#.

For example, you can use XmlDocument:

WebClient client = new WebClient();
string xml = client.DownloadString("http://api.namnapi.se/v2/names.xml?limit=3");

XmlDocument document = new XmlDocument();
document.LoadXml(xml);

foreach (XmlElement node in document.SelectNodes("names/name"))
{
    Label.Text += String.Format("{0} {1}<br/>", 
        node.SelectSingleNode("firstname").InnerText,  
        node.SelectSingleNode("lastname"));
}

There are also such approaches as using XmlSerializer for serializing XML into your own classes, XmlTextReader, Linq2Xml etc. Pick the most suitable one.

Read from XML instead of JSON C# asp.net

1 Answers1