Search XML with C#

tvkswamy

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.

2 Replies

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

Manas Mohapatra10y ago
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;
}
Rajesh Singh10y ago
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.