#XML #C# Read a XML (from a string) and get some fields

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

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

Try :
        childrenNode.SelectSingleNode("field1").Value
.InnerText or .InnerXML

-------------------------------------------------

string decryptedMarkup = "<Product><Type>Metal</Type>"
    + "<Department>Foundry</Department></Product>";
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.LoadXml(decryptedMarkup);


// XmlDocument.Load(string)

string pathToFile = "test.xml";
XmlDocument xmlDoc2 = new XmlDocument();
xmlDoc2.Load(pathToFile);

--------------------------------------------

For further information, take a look at:

XmlDocument.Load(string)

String parameter:
URL for the file containing the XML document to load. The URL can be either a local file or an HTTP URL (a Web address).

XmlDocument.LoadXml(string)

String parameter:
String containing the XML document to load.

Source :
"<?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>"

Ref : https://stackoverflow.com/questions/8401280/read-a-xml-from-a-string-and-get-some-fields-problems-reading-xml