reading xml document as attribute name and attirbute value

Pranav P

7y789Visual Basic .NET

from the given piece of xml document

Everyday Italian

Giada De Laurentiis

2005

30.00

Harry Potter

J K. Rowling

2005

29.99

how to read the attributes names and their values from an xml document as the given format below

{category:'COOKING',title:'Everyday Italian',author: 'Giada De Laurentiis',year: '2005',price:'30.00'}

{category:'CHILDREN',title:'Harry Potter',author: 'J K. Rowling',year: '2005',price:'29.99'}

is there any sample code that i can refer ?

thanks in advance.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jaish Mathews7y ago
Many ways including below approach. It used XDocument, XElement types and also Attribute() and Element() methods.
string tempXml = @"
            'COOKING'>
             Everyday Italian
               Giada De Laurentiis
                 2005
                 30.00

                 'CHILDREN'>
                  Harry Potter
                     J K.Rowling
                        2005
                        29.99
                        ";
            XDocument doc = XDocument.Parse(tempXml);
            IEnumerable cust = doc.Descendants("book");
            foreach (XElement element in cust)
            {
                string category = element.Attribute("category").Value;
                string title = element.Element("title").Value;
                string author = element.Element("author").Value;
                string year = element.Element("year").Value;
                string price = element.Element("price").Value;
            }
Amit Mohanty7y ago
Add Namespaces
using System.Xml;
using Newtonsoft.Json;
Call the below coding in your method
string xml =
    @"
        'COOKING'>
            Everyday Italian
            Giada De Laurentiis
            2005
            30.00

        'CHILDREN'>
            Harry Potter
            J K. Rowling
            2005
            29.99

    ";
XmlDocument doc = new XmlDocument();
doc.LoadXml(xml);
string json = JsonConvert.SerializeXmlNode(doc);
Console.WriteLine(json);
Rajanikant Hawaldar7y ago
Hi Dear,

Refer this article, XML Manipulation In C#

https://www.c-sharpcorner.com/article/xml-manipulation-in-c-sharp/

Thanks