How would i iterate of each child of child Nodes and Display its Element Name and attribute Value
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:
1 SingleChoice Where is your project primarily located? (select only one)
1 In an urbanized area
2 In a metropolitan area outside of core urbanized area
3 In a small city/town
4 In a rural area
2 SingleChoice What neighborhood is the project located in? (select only one)
1 Primarily a residential area
2 Primarily an employment area
3 Primarily an industrial/warehousing area
Best regards,
Dillion
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue.
If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
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
45439 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
Please remember to click "Mark as Answer" the responses that resolved your issue.
If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.