ASP.NET Tutorial/ADO.net Database/SqlHierarchicalDataSource
Building a SQL Hierarchical Data Source Control
<source lang="csharp">
<%@ Page Language="C#" %> <%@ Register TagPrefix="custom" Namespace="MyNamespace" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> <script runat="server">
protected void Menu1_MenuItemClick(object sender, MenuEventArgs e) { lblSelected.Text = Menu1.SelectedValue; }
</script> <html xmlns="http://www.w3.org/1999/xhtml" > <head id="Head1" runat="server">
<title>Show Menu</title>
</head> <body>
<form id="form1" runat="server">
<asp:Menu id="Menu1" DataSourceId="srcCategories" OnMenuItemClick="Menu1_MenuItemClick" Orientation="Horizontal" DynamicMenuStyle-CssClass="menu" Runat="server"> <DataBindings> <asp:MenuItemBinding TextField="Name" ValueField="Name" /> </DataBindings> </asp:Menu> <custom:SqlHierarchicalDataSource id="srcCategories" ConnectionString="<%$ ConnectionStrings:Categories %>" DataKeyName="CategoryId" DataParentKeyName="ParentId" SelectCommand="SELECT CategoryId, ParentId, Name FROM Categories" Runat="server" />
<asp:Label id="lblSelected" Runat="server" />
</form>
</body> </html></source>
Use the SqlHierarchicalDataSource control when working with the TreeView control
<source lang="csharp">
<%@ Page Language="C#" %> <%@ Register TagPrefix="custom" Namespace="MyNamespace" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> <script runat="server">
protected void TreeView1_SelectedNodeChanged(object sender, EventArgs e) { lblSelected.Text = TreeView1.SelectedValue; }
</script> <html xmlns="http://www.w3.org/1999/xhtml" > <head id="Head1" runat="server">
<title>Show TreeView</title>
</head> <body>
<form id="form1" runat="server">
<asp:TreeView id="TreeView1" DataSourceID="srcDiscuss" OnSelectedNodeChanged="TreeView1_SelectedNodeChanged" ImageSet="News" Runat="server"> <DataBindings> <asp:TreeNodeBinding TextField="Subject" ValueField="MessageId" /> </DataBindings> </asp:TreeView> <custom:SqlHierarchicalDataSource id="srcDiscuss" ConnectionString="<%$ ConnectionStrings:Discuss %>" DataKeyName="MessageId" DataParentKeyName="ParentId" SelectCommand="SELECT MessageId,ParentId,Subject FROM Discuss" Runat="server" />
You selected message number: <asp:Label id="lblSelected" Runat="server" />
</form>
</body> </html></source>