C# Parse xml into arrays

Question

I have 400+ records of data in this format inside :

how do I create indivisual array to store the values of ows_ID, ows_LinkTitle annd so on?

foreach (System.Xml.XmlNode node in activeItemData)

        {
            if (node.Name == "rs:data")
            {
                for (int i = 0; i < node.ChildNodes.Count; i++)
                {
                    if (node.ChildNodes[i].Name == "z:row")
                    {
                        string [] resultTitle;
     resultTitle = (node.ChildNodes[i].Attributes["ows_Title"].Value).ToArray();
                        Console.ReadLine(); 
                    } 
                } 
          } 
      }

Its throwing error Error Cannot implicitly convert type 'char[]' to 'string[]' at resultTitle. How do I correct it? Thanks.

I did

char[] resultTitle;
resultTitle = (node.ChildNodes[i].Attributes ["ows_Title"].Value).ToArray();
string s = new string(resultTitle);
Console.ReadLine();

how do I do it for all the values of ["ows_Title"]. ? Thanks.

Conrad Frix · Accepted Answer

This code

char[] resultTitle;
resultTitle = (node.ChildNodes[i].Attributes ["ows_Title"].Value).ToArray(); 
string s = new string(resultTitle);
Console.ReadLine();

Takes a string value turns into a character array. ).ToArray() and then immediately converts the character array back into a string.

This is the same thing without the extra memory allocation

string s = node.ChildNodes[i].Attributes ["ows_Title"].Value;

If I were you however I would just use linq to xml. I'd also want to end up with a List

XNamespace z = "#RowsetSchema";
List list = (from row in xdoc.Descendants(z + "row")
                     select (string)row.Attribute("ows_LinkTitle")
                    ).ToList();

Complete sample

    static void Main(string[] args)
    {
        string xstring = @"
                            
                                
                               
                               
                           
                          ";



        XDocument xdoc = XDocument.Parse(xstring); // there are other ways to construct your xdoc
        XNamespace z = "#RowsetSchema";
        List list = (from row in xdoc.Descendants(z + "row")
                            select  (string)row.Attribute("ows_LinkTitle")
                            ).ToList();

        foreach (var item in list)
            Console.WriteLine(item);

    }

C# Parse xml into arrays

Answers (2)

Related Questions