Create Portals Menu in ASP.NET from Tree Structure Table of SQL Server 2005

/* SQL Stored Procedure */
create proc [dbo].[GetMenuXml]
as
select
	1 as Tag,
	null as Parent,
	null as [root!1!id],
	null as [category!2!id],
	null as [category!2!name],
	null as [category!2!url],
	null as [category!2!parent]
union all
select
	2 as Tag,
	1 as Parent,
	a.CategoryId,
	a.CategoryId,
	a.CategoryName,
	a.CategoryUrl,
	a.ParentId
from
	dbo.[Q23655605] a
order by [root!1!id],[category!2!parent]
for xml explicit
 
/* Sample Data */ 
<root>
  <category id="1" name="Main Company" url="~/Home.aspx" />
  <category id="2" name="Citizen" url="~/Citzen.aspx" parent="1" />
  <category id="3" name="Tissot" url="~/Tissot.aspx" parent="1" />
  <category id="4" name="Omega" url="~/Omega.aspx" parent="1" />
  <category id="5" name="Men" url="~/Men.aspx" parent="2" />
  <category id="6" name="Women" url="~/Women.aspx" parent="2" />
  <category id="7" name="Quartz" url="~/Quartz.aspx" parent="3" />
  <category id="8" name="HardWorkers" url="~/HardWorkers.aspx" parent="5" />
</root>
 
/* XSLT */ 
<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="msxsl">
    <xsl:output method="xml" indent="yes"/>
    <xsl:key name="categories" match="category" use="@parent"/>
  <xsl:template match="/">
    <root>
      <xsl:apply-templates select="//category[not(@parent)]" mode="root" />
    </root>  
  </xsl:template>
  <xsl:template match="category" mode="root">
    <xsl:apply-templates select="key('categories',@id)"  />
  </xsl:template>
  <xsl:template match="category">
    <category>
      <xsl:copy-of select="@*"/>
      <xsl:apply-templates select="key('categories',@id)" />
    </category>
  </xsl:template>
    <xsl:template match="@* | node()">
        <xsl:copy>
            <xsl:apply-templates select="@* | node()"/>
        </xsl:copy>
    </xsl:template>
</xsl:stylesheet>
 
/* ASPX Page */
<div>
    <asp:Menu ID="MainMenu" runat="server" DataSourceID="MenuXmlDataSource">
         <DataBindings>
          <asp:MenuItemBinding DataMember="category" 
              NavigateUrlField="url" TextField="name" ValueField="name" />
           </DataBindings>
    </asp:Menu>
    <asp:XmlDataSource ID="MenuXmlDataSource" runat="server" XPath="/*/*" 
        TransformFile="MenuBusinessLogic.xslt"/>
</div>
 
/* Code Behind */
protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        using (SqlConnection connection = new SqlConnection(Settings.Default.ExpertsExchangeDb))
        {
            connection.Open();
            using (SqlCommand command = new SqlCommand("GetMenuXml", connection))
            {
                command.CommandType = CommandType.StoredProcedure;
 
                using (XmlReader reader = command.ExecuteXmlReader())
                {
                    XmlDocument document = new XmlDocument();
                    document.Load(reader);
                    this.MenuXmlDataSource.Data = document.DocumentElement.OuterXml;
                }
 
            }
        }
    }
}
                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="msxsl">
    <xsl:output method="xml" indent="yes"/>
    <xsl:key name="categories" match="category" use="@parent"/>
  <xsl:template match="/">
    <root>
      <xsl:apply-templates select="//category[not(@parent)]" mode="root" />
    </root>  
  </xsl:template>
  <xsl:template match="category" mode="root">
    <xsl:apply-templates select="key('categories',@id)"  />
  </xsl:template>
  <xsl:template match="category">
    <category>
      <xsl:copy-of select="@*"/>
      <xsl:apply-templates select="key('categories',@id)" />
    </category>
  </xsl:template>
 </xsl:stylesheet>

                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20: