Read all xml nodes with same name and their childNodes in c#

Here is my code so far:

 

string studentName = "";
string studentAge = "";
List schoolList = new List();
List gradeList = new List();
List nameList = new List();
List ageList = new List();

foreach (XmlNode node in doc.SelectNodes("root/academic"))
{
for (int i = 0; i < node.ChildNodes.Count-1; i++ )
{
schoolName = node.ChildNodes[i].LocalName;

foreach (XmlNode node1 in doc.SelectNodes("root/academic/" + schoolName))
{
for(int j = 0; j < node1.ChildNodes.Count; j++)
{
gradeName = node1.ChildNodes[j].LocalName;

foreach(XmlNode node2 in doc.SelectNodes("root/academic/"+schoolName+"/"+gradeName))
{
foreach (XmlNode node3 in node2.ChildNodes)
{

if (node3.LocalName.Equals("student"))
{
studentName = node3.SelectSingleNode("name").InnerText;
studentAge = node3.SelectSingleNode("age").InnerText;

schoolList.Add(schoolName);
gradeList.Add(gradeName);
nameList.Add(studentName);
ageList.Add(studentAge);

}
}

} // grade foreach ends

} // grade for ends

} // school foreach ends

} // school for ends
}

Hi,

 

Please share the code you have written to select the student tags to list. Also provide what is your expected output for above xml. 

You can load your XML file or string to Dataset to load multiple datatable and then you can use its datatable Select method where you can pass filter string.Like dtXml.Select("fieldname like 'student'")This will return list of datarows with all rows satisfy the condition Or use LINQ to Dataset to get desired results

 

 the following code also loads datatable into dataset from the XML string. 

 The screens attached,