We are excited to announce that the ASP.NET Forums are moving to the new Microsoft Q&A experience. Learn more >
How would i iterate of each child of child Nodes and Display its Element Name and attribute Value [Answered]
1 reply
Last post Nov 12, 2015 04:21 AM by Zhi Lv - MSFT
None
0 Points
1 Post
How would i iterate of each child of child Nodes and Display its Element Name and attribute Value...
Nov 12, 2015 02:07 AM|Deamon_Dagger|LINK
I Have some Sample Data XML,
<oval-res:results> <oval-res:system> <oval-res:definitions> <oval-res:definition definition_id="oval:com.rapid7.oval:def:5004" version="1" result="true"> <oval-res:criteria operator="OR" negate="false" result="true"> <oval-res:criterion test_ref="oval:com.rapid7.oval:tst:50041" version="1" negate="false" result="true"/> <oval-res:criterion test_ref="oval:com.rapid7.oval:tst:50042" version="1" negate="false" result="false"/> <oval-res:criterion test_ref="oval:com.rapid7.oval:tst:50043" version="1" negate="false" result="false"/> <oval-res:criterion test_ref="oval:com.rapid7.oval:tst:50044" version="1" negate="false" result="false"/> </oval-res:criteria> </oval-res:definition> <oval-res:definition definition_id="oval:com.rapid7.oval:def:7182" version="1" result="true"> <oval-res:criteria operator="AND" negate="false" result="true"> <oval-res:criterion test_ref="oval:com.rapid7.oval:tst:7281" version="1" negate="false" result="true"/> <oval-res:extend_definition definition_ref="oval:com.rapid7.oval:def:5004" version="1" negate="false" result="true"/> </oval-res:criteria> </oval-res:definition> </oval-res:definitions> </oval-res:system> </oval-res:results>
Suppose i want to get the attribute Values of <oval-res:definition></oval-res:definition> and <oval-res:criterion></oval-res:criterion>
XDocument xdoc = XDocument.Load(filepath); IEnumerable<XElement> records = xdoc.Descendants("oval-res:results");//Rulestring outputDirectory = @"C:\Users\Public\TestFolder";//Directory path where you want to save the output txt file if (!System.IO.Directory.Exists(outputDirectory)) { System.IO.Directory.CreateDirectory(outputDirectory); } string outputfileName1 = DateTime.Now.ToString("yyyy_MM_dd") + @"-definition.txt"; string filepath = @"C:\Users\Kir@n\Desktop\ConsoleApplication1\linux_arf.xml"; XmlDocument doc = new XmlDocument(); doc.Load(filepath); if (!(doc == null)) { try { XmlNodeList elemList = doc.GetElementsByTagName(@"oval-res:definition"); using (System.IO.StreamWriter file = new System.IO.StreamWriter(outputDirectory + @"\" + outputfileName1)) { file.WriteLine(string.Format("{0}|{1}|{2}|", "definition_id", "version", "result")); for (int i = 0; i < elemList.Count; i++) { string def_id = elemList[i].Attributes["definition_id"].Value; if (def_id != null) def_id = def_id.Replace("\n", "\\n"); string version = elemList[i].Attributes["version"].Value; if (version != null) version = version.Replace("\n", "\\n"); string result = elemList[i].Attributes["result"].Value; if (result != null) result = result.Replace("\n", "\\n"); Console.WriteLine(def_id + " | " + version + " | " + result + " | "); file.WriteLine(string.Format("{0}|{1}|{2}|", def_id, version, result)); } } } catch (Exception ex) { Console.WriteLine(ex); } }All-Star
45489 Points
7008 Posts
Microsoft
Re: How would i iterate of each child of child Nodes and Display its Element Name and attribute V...
Nov 12, 2015 04:21 AM|Zhi Lv - MSFT|LINK
Hi Deamon_Dagger,
Welcome to asp.net forum.
As for this issue, you could try to use nested foreach statement or for statement. Here is a sample, you could refer to it:
Code in xml file:
<?xml version="1.0" encoding="utf-8" ?> <Questions> <Question id="1" type='SingleChoice'> <Text>Where is your project primarily located? (select only one)</Text> <Answers> <Answer id="1"> In an urbanized area</Answer> <Answer id="2"> In a metropolitan area outside of core urbanized area </Answer> <Answer id="3"> In a small city/town</Answer> <Answer id="4"> In a rural area</Answer> </Answers> </Question> <Question id="2" type='SingleChoice'> <QuestionType>SingleChoice</QuestionType> <Text>What neighborhood is the project located in? (select only one)</Text> <Answers> <Answer id="1">Primarily a residential area</Answer> <Answer id="2">Primarily an employment area</Answer> <Answer id="3">Primarily an industrial/warehousing area</Answer> </Answers> </Question> </Questions>Code in page (.aspx.cs)
protected void Page_Load(object sender, EventArgs e) { XmlDocument xml = new XmlDocument(); xml.Load(Server.MapPath("Questions.xml")); StringBuilder sb = new StringBuilder(); List<DiagnosticTool> queslist = new List<DiagnosticTool>(); XmlNodeList list = xml.SelectNodes("/Questions/Question"); foreach (XmlNode xn in list) { DiagnosticTool dt = new DiagnosticTool(); dt.QuestionId = Convert.ToInt32(xn.Attributes["id"].Value); //Get Question Id dt.QuestionType = xn.Attributes["type"].Value; //Get Question Type dt.Text = xn["Text"].InnerText; //Get Text Node sb.AppendLine(dt.QuestionId.ToString()); sb.AppendLine("\t"); sb.AppendLine(dt.QuestionType); sb.AppendLine("\t"); sb.AppendLine(dt.Text); sb.AppendLine("<br />"); List<Answer> answerlist = new List<Answer>(); XmlNodeList list2 = xn.SelectNodes(".//Answers/Answer"); foreach (XmlNode xn2 in list2) { Answer an = new Answer(); an.AnswerId = Convert.ToInt32(xn2.Attributes["id"].Value);//Get answer id. an.Text = xn2.InnerText;//Get answer node. answerlist.Add(an); //add answer to List sb.AppendLine(an.AnswerId.ToString()); sb.AppendLine("\t"); sb.AppendLine(an.Text); sb.AppendLine("<br />"); } dt.Answers = answerlist; queslist.Add(dt); // Add question to list sb.AppendLine("<br />"); } Response.Write(sb.ToString()); }Code in class:
public class DiagnosticTool { public string Text { get; set; } public IList<Answer> Answers { get; set; } public int QuestionId { get; set; } public string QuestionType { get; set; } } public class Answer { public int AnswerId { get; set; } public string Text { get; set; } }The output:
Best regards,
Dillion