C# split xml innertext or parse innerxml

Question

I have an XML file with a structure similar to this

<entry name="something">
  <members>
    <member>aaa</member>
    <member>bbb</member>
  </members>
</entry>
<entry name="something_else">
  <members>
    <member>ccc</member>
    <member>ddd</member>
  </members>
</entry>

I need to be able to get the values out of each of the member nodes to store in a datatable. if i use the innertext property, it concatenates the values (aaabbb). there is nothing discernible to split the string on. I can also use the inner XML but then i just get a string with the XML structure (aaa bbb<\member>)

What is the best way to get each value out of the XML elements and store it in a string array?

here is what I have been trying.

foreach (XmlNode grpNode in GrpList)
{
    subNode = grpNode.Attributes["name"];
    if (subNode != null)
    {
        Obj = grpNode.Attributes["name"].Value;
    }

    subNode = grpNode["members"];
    if (subNode != null)
    {
        string innerXml = string.Empty;
        innerXml = grpNode["members"].InnerXml.ToString();

        string[] tempArrary = innerXml.Split(new char[] {'>', '<'});
    }
}

Answer 1

You can use Xpath to iterate through Entry nodes and get the members within it like this

string xml = "<root><entry name='something'>" +
              "<members>" + 
                "<member>aaa</member>" + 
                "<member>bbb</member>" + 
              "</members>" + 
            "</entry>" + 
            "<entry name='something_else'>" + 
              "<members>" + 
                "<member>ccc</member>" + 
                "<member>ddd</member>" + 
             "</members>" +
            "</entry></root>";

            XmlDocument doc = new XmlDocument();
            doc.LoadXml(xml);

            var memsList = doc.SelectNodes("//entry");
            foreach (XmlNode a in memsList)
            {
                Console.WriteLine(a.Attributes["name"].Value);

                var memList = a.SelectNodes("members/member");

                foreach(XmlNode x in memList)
                    Console.WriteLine(x.InnerText);
            }