Click here to Skip to main content
14,451,808 members
Rate this:
Please Sign up or sign in to vote.
See more:
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
Posted

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

What is your question? Do you have a question? Or are you requesting we do work for you?
   

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




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100