Read the XML (from a string) and get some fields - Problems reading XML

Question

I have this XML (stored in a C # line called myXML )

 <?xml version="1.0" encoding="utf-16"?> <myDataz xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <listS> <sog> <field1>123</field1> <field2>a</field2> <field3>b</field3> </sog> <sog> <field1>456</field1> <field2>c</field2> <field3>d</field3> </sog> </listS> </myDataz> 

and I would like to see all the <sog> elements. For each of them, I would like to print a child of <field1> .

So this is my code:

 XmlDocument xmlDoc = new XmlDocument(); string myXML = "<?xml version=\"1.0\" encoding=\"utf-16\"?><myDataz xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"><listS><sog><field1>123</field1><field2>a</field2><field3>b</field3></sog><sog><field1>456</field1><field2>c</field2><field3>d</field3></sog></listS></myDataz>" xmlDoc.Load(myXML); XmlNodeList parentNode = xmlDoc.GetElementsByTagName("listS"); foreach (XmlNode childrenNode in parentNode) { HttpContext.Current.Response.Write(childrenNode.SelectSingleNode("//field1").Value); } 

but it seems I can not read the string as XML? I get a System.ArgumentException

Answer 1

You should use the LoadXml method, not Load:

 xmlDoc.LoadXml(myXML); 

The load method attempts to load xml from a file and LoadXml from a string. You can also use XPath:

 XmlDocument xmlDoc = new XmlDocument(); xmlDoc.LoadXml(xml); string xpath = "myDataz/listS/sog"; var nodes = xmlDoc.SelectNodes(xpath); foreach (XmlNode childrenNode in nodes) { HttpContext.Current.Response.Write(childrenNode.SelectSingleNode("//field1").Value); } 

Answer 2

Use Linq-XML,

 XDocument doc = XDocument.Load(file); var result = from ele in doc.Descendants("sog") select new { field1 = (string)ele.Element("field1") }; foreach (var t in result) { HttpContext.Current.Response.Write(t.field1); } 

OR: Get the node list of the <sog> .

  XmlDocument xmlDoc = new XmlDocument(); xmlDoc.Load(myXML); XmlNodeList parentNode = xmlDoc.GetElementsByTagName("sog"); foreach (XmlNode childrenNode in parentNode) { HttpContext.Current.Response.Write(childrenNode.SelectSingleNode("field1").InnerText); } 

Answer 3

The rest of the answers are several years old (and do not work for Windows Phone 8.1), so I decided that I would take another option. I used this to parse the RSS response for a Windows Phone application:

 XDocument xdoc = new XDocument(); xdoc = XDocument.Parse(xml_string); 

Answer 4

Or use the XmlSerializer class.

 XmlSerializer xs = new XmlSerializer(objectType); obj = xs.Deserialize(new StringReader(yourXmlString)); 

Answer 5

I used System.Xml.Linq.XElement for this purpose. Just check the code below to read the value of the first child node element for xml (not root node).

  string textXml = "<xmlroot><firstchild>value of first child</firstchild>........</xmlroot>"; XElement xmlroot = XElement.Parse(textXml); string firstNodeContent = ((System.Xml.Linq.XElement)(xmlroot.FirstNode)).Value;