Generate XML Tree Structure

See more:

C#2.0

C#

I want to form an XML document something like below in order to send this data to frontend( .net) to create tree structure.Herewith I have attached the sample Data in excel.

like need to write select ..... from table FOR XML AUTO,TYPE,ELEMENTS

<item id="16" name="Application">
<item id="17" name="3rd Party Applications">
<item id="18" name="Compatibility issues">
<item id="19" name="Unable to install">
<item id="19" name="Unable to launch">
<item id="19" name="Unable to uninstall">

<item>
<item id="78" name="IE">

<item id="79" name="Browsing">
<item id="81" name="Cookies Related">
<item id="82" name="DLL Corruption">
<item id="83" name="DNS issues">
...
...

<item>
<item>
....
...
..



Sample Data





Id Name ParentId
16 Application 0
17 3rd Party Applications 16
18 Compatibility issues 17
19 Unable to install 17
20 Unable to launch 17
21 Unable to uninstall 17
22 Unexpected behavior (crash) 17
23 Inbox MS Vista Applications 16
51 Other MS Applications 16
57 Hardware 0
78 IE 0
79 Browsing 78
80 3rd Party Add-in 79
81 Cookies Related 79
82 DLL Corruption 79
83 DNS issues 79
84 Flash/java Conent 79
85 Links don’t work 79
86 Slow Browsing 79
87 Toolbars 79
88 Unable to only some sites 79
89 Unable to view all sites 79
90 Unable to view graphics 79
91 Web Mail 79
92 Customer Education - How to 78
93 Malware 78
94 Others 78
95 Script errors 78
96 Silverlight 78
97 Unable to open or close IE 78
98 Unable to print 78
99 Unable to retain or set homepage 78