reading xml document as attribute name and attirbute value

Question

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.

Amit Mohanty · Answer

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 Hawaldar · Answer

Hi Dear, Refer this article, XML Manipulation In C# https://www.c-sharpcorner.com/article/xml-manipulation-in-c-sharp/ Thanks

Jaish Mathews · Answer

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; }