Click here to Skip to main content
15,886,110 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi All, Convert XML string to Array but array is array item within item
XML
<NewDataSet>
  <items>
    <ID>1</ID>
    <Descrpition>SDM</Descrpition>
    <email>SDM78@gmail.com</email>
    <groupTitleColor>#4169e1</groupTitleColor>
    <EmpCode>10010000</EmpCode>
    <title>XYZ XYZ</title>
    <phone>1234567890</phone>
    <itemTitleColor>#4b0082</itemTitleColor>
    <items>
      <ID>2</ID>
      <Descrpition>Analyst - Network Services</Descrpition>
      <email>nitin@gmail.com</email>
      <groupTitleColor>#4169e1</groupTitleColor>
      <LineManager1ID>10010000</LineManager1ID>
      <EmpCode>11111</EmpCode>
      <title>Demo10 Demo10</title>
      <phone>9623309304</phone>
      <itemTitleColor>#4b0082</itemTitleColor>
    </items>        
    <items>
      <ID>9</ID>
      <Descrpition>Software Engineer</Descrpition>
      <email>sumit@Gmail.com</email>
      <groupTitleColor>#4169e1</groupTitleColor>
      <LineManager1ID>10010000</LineManager1ID>
      <EmpCode>10137133</EmpCode>
      <title>Sumit</title>
      <phone>1212</phone>
      <itemTitleColor>#4b0082</itemTitleColor>
      <items>
        <ID>31</ID>
        <Descrpition>Analyst - Network Services</Descrpition>
        <email>nitin@gmail.com</email>
        <groupTitleColor>#4169e1</groupTitleColor>
        <LineManager1ID>10137133</LineManager1ID>
        <EmpCode>145787</EmpCode>
        <title>Demo1 Demo1</title>
        <phone>9623309303</phone>
        <itemTitleColor>#4b0082</itemTitleColor>
      </items>
      <items>
        <ID>32</ID>
        <Descrpition>Analyst - Network Services</Descrpition>
        <email>nitin@gmail.com</email>
        <groupTitleColor>#4169e1</groupTitleColor>
        <LineManager1ID>10137133</LineManager1ID>
        <EmpCode>140214555</EmpCode>
        <title>Demo1 Demo1</title>
        <phone>9623309303</phone>
        <itemTitleColor>#4b0082</itemTitleColor>
      </items>      
    </items>
    <items>
      <ID>3</ID>
      <Descrpition>Analyst - Network Services</Descrpition>
      <email>kanil@gmail.com</email>
      <groupTitleColor>#4169e1</groupTitleColor>
      <LineManager1ID>10010000</LineManager1ID>
      <EmpCode>11112</EmpCode>
      <title>Sameer Kothari</title>
      <phone>9623309303</phone>
      <itemTitleColor>#4b0082</itemTitleColor>
   </items>  
</items>
</NewDataSet>


I want in to array but array structure like treeview
1
1----2
1----9
-----9-----31
-----9-----32
1----3
Posted

C#
using System;
using System.Linq;
using System.Xml.Linq;

public class Test
{
    static void Main()
    {
        string xml = "<newdataset>
  <items>
    <id>1</id>
    <descrpition>SDM</descrpition>
    <email>SDM78@gmail.com</email>
    <grouptitlecolor>#4169e1</grouptitlecolor>
    <empcode>10010000</empcode>
    <title>XYZ XYZ</title>
    <phone>1234567890</phone>
    <itemtitlecolor>#4b0082</itemtitlecolor>
    <items>
      <id>2</id>
      <descrpition>Analyst - Network Services</descrpition>
      <email>nitin@gmail.com</email>
      <grouptitlecolor>#4169e1</grouptitlecolor>
      <linemanager1id>10010000</linemanager1id>
      <empcode>11111</empcode>
      <title>Demo10 Demo10</title>
      <phone>9623309304</phone>
      <itemtitlecolor>#4b0082</itemtitlecolor>
    </items>        
    <items>
      <id>9</id>
      <descrpition>Software Engineer</descrpition>
      <email>sumit@Gmail.com</email>
      <grouptitlecolor>#4169e1</grouptitlecolor>
      <linemanager1id>10010000</linemanager1id>
      <empcode>10137133</empcode>
      <title>Sumit</title>
      <phone>1212</phone>
      <itemtitlecolor>#4b0082</itemtitlecolor>
      <items>
        <id>31</id>
        <descrpition>Analyst - Network Services</descrpition>
        <email>nitin@gmail.com</email>
        <grouptitlecolor>#4169e1</grouptitlecolor>
        <linemanager1id>10137133</linemanager1id>
        <empcode>145787</empcode>
        <title>Demo1 Demo1</title>
        <phone>9623309303</phone>
        <itemtitlecolor>#4b0082</itemtitlecolor>
      </items>
      <items>
        <id>32</id>
        <descrpition>Analyst - Network Services</descrpition>
        <email>nitin@gmail.com</email>
        <grouptitlecolor>#4169e1</grouptitlecolor>
        <linemanager1id>10137133</linemanager1id>
        <empcode>140214555</empcode>
        <title>Demo1 Demo1</title>
        <phone>9623309303</phone>
        <itemtitlecolor>#4b0082</itemtitlecolor>
      </items>      
    </items>
    <items>
      <id>3</id>
      <descrpition>Analyst - Network Services</descrpition>
      <email>kanil@gmail.com</email>
      <grouptitlecolor>#4169e1</grouptitlecolor>
      <linemanager1id>10010000</linemanager1id>
      <empcode>11112</empcode>
      <title>Sameer Kothari</title>
      <phone>9623309303</phone>
      <itemtitlecolor>#4b0082</itemtitlecolor>
   </items>  
</items>
</newdataset>";

        XDocument doc = XDocument.Parse(xml);

        var list = doc.Root.Elements("id")
                           .Select(element => element.Value)
                           .ToList();

        foreach (string value in list)
        {
            Console.WriteLine(value);
        }
    }
}
 
Share this answer
 
Using parseJSON

var obj = jQuery.parseJSON( '{ "name": "John" }' );alert( obj.name === "John" );
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900