Search XML with C#

Question

Hi I have an XML of this format. 2015-02-26 Monitor 2015-02-27 YYY Printer I want to populate a list as 2015-02-26  XXX  Monitor 2015-02-27  YYY  Printer In my code (C# - Winform) I have composed as below. XmlNodeList xNode = xd.SelectNodes(/Body/A/B/SH); foreach (XmlNode xndNode in xNode) { string LU = xndNode[last_update_time].InnerText; string D = xndNode[ D ].InnerText; string Comments = xndNode[comments].InnerText; } Yet I am not able to get the desired output. Any help where I have gone wrong please.

Rajesh Singh · Answer

Hi Swamy There is no problem in your code. The problem is in your xml. remove xmlns=http://schemas.xmlsoap.org/soap/envelope/ from . Add XXX in XXXX> Corrected xml is pasted below: 2015-02-26 XXX Monitor y YYY Printer Please paste corrected xml. You will get desired output which you have mention. I have tested the output. Its working fine. Please accept this answer if you feel this is right answer.

Manas Mohapatra · Answer

Try with below code: string sd = @ 2015-02-26 Monitor 2015-02-27 YYY Printer ; XmlDocument doc = new XmlDocument (); doc.LoadXml(sd); // creating namespace object XmlNamespaceManager nsmgr = new XmlNamespaceManager (doc.NameTable); nsmgr.AddNamespace( bk   http://schemas.xmlsoap.org/soap/envelope/ ); XmlNodeList xNode = doc.SelectNodes(bk:Body/bk:A/bk:B/bk:SH nsmgr); // looping node list foreach ( XmlNode xndNode in xNode) { string LU = xndNode[last_update_time].InnerText; string D = xndNode[D].InnerText; string Comments = xndNode[comments].InnerText; }