ASP.NET Tutorial/ADO.net Database/SqlHierarchicalDataSource

Материал из .Net Framework эксперт
Перейти к: навигация, поиск

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>

Источник — «http://nfex.ru/index.php?title=ASP.NET_Tutorial/ADO.net_Database/SqlHierarchicalDataSource&oldid=2686»