Database tree : TreeView « Asp Control « ASP.Net






Database tree


<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="DataBaseTree" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
   <title>Custom TreeView</title>
</head>
<body>
   <form id="form1" runat="server">
   <div id="container">
      <h1>Database TreeView </h1>
      <p>This example fills a <code>TreeView</code> control from a database</p>

      <h2>Tree Filled From Database</h2>      
      <asp:TreeView ID="treeMain" 
                    runat="server" 
                    CssClass="tree" 
                    ShowCheckBoxes="Leaf">
      </asp:TreeView>
   </div>
   </form>
</body>
</html>

File: Default.aspx.cs

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class DataBaseTree : System.Web.UI.Page
{
   protected void Page_Load(object sender, EventArgs e)
   {
      if (!IsPostBack)
      {
         string[] groups = ProductCatalog.GetGroups();
         foreach (string grp in groups)
         {
            TreeNode groupNode = new TreeNode(grp);

            string[] subheadings = ProductCatalog.GetSubHeadingsByGroup(grp);
            foreach (string sub in subheadings)
            {
               TreeNode subheadingNode = new TreeNode(sub);

               string[] products = ProductCatalog.GetProductsBySubHeading(sub);
               foreach (string prod in products)
               {
                  TreeNode productNode = new TreeNode(prod);
                  subheadingNode.ChildNodes.Add(productNode);
               }
               groupNode.ChildNodes.Add(subheadingNode);
            }
            treeMain.Nodes.Add(groupNode);
         }
      }
   }
}



class ProductCatalog
{
   private static Product[] _products = { 
      new Product(1, "A", "7", 39.99),
      new Product(2, "B", "8", 49.99), 
      new Product(3, "C", "7", 39.99),
      new Product(4, "D", "8", 49.99), 
      new Product(5, "E", "7", 39.99),
      new Product(6, "F", "8", 49.99), 
      new Product(7, "G", "7", 39.99),
      new Product(8, "H", "8", 49.99), 
      new Product(9, "I", "7", 39.99),
      new Product(10, "J", "8", 49.99), 
      new Product(11, "K", "7", 39.99),
      new Product(12, "L", "8", 49.99), 
   
   };


   private static string[] _groups = { "Categories", "Series" };

   private static string[] _subheadings1 = { "Graphics", "Internet", };
   private static string[] _subheadings2 = { "Core Series", ".NET Series" };

   private static string[] _books1 = { "GDI" };
   private static string[] _books2 = { "HTML", "CSS", "Javascript", "Web Services" };
   private static string[] _books3 = { "Java", "C#",  "CSS" };
   private static string[] _books4 = { "C++", "Web Services" };


   private static Product[] _prods1 = { _products[0] };
   private static Product[] _prods2 = { _products[5], _products[6], _products[7], _products[3] };
   private static Product[] _prods3 = { _products[0], _products[1], _products[7] };
   private static Product[] _prods4 = { _products[2], _products[3] };

   public static Product[] GetProducts()
   {
      return _products;
   }

   public static Product GetProductById(int id)
   {
      foreach (Product prod in _products)
      {
         if (prod.Id == id)
            return prod;
      }
      return null;
   }


   public static string[] GetGroups()
   {
      return _groups;
   }

   public static string[] GetSubHeadingsByGroup(string group)
   {
      if (group == "Categories")
         return _subheadings1;
      else
         return _subheadings2;
   }

   public static string[] GetProductsBySubHeading(string subheading)
   {
      if (subheading == "Graphics")
         return _books1;
      else if (subheading == "Internet")
         return _books2;
      else if (subheading == "Core Series")
         return _books3;
      else
         return _books4;
   }

   public static Product[] GetProductObjectsBySubHeading(string subheading)
   {
      if (subheading == "Graphics")
         return _prods1;
      else if (subheading == "Internet")
         return _prods2;
      else if (subheading == "Core Series")
         return _prods3;
      else
         return _prods4;
   }
}

class Product
{
   public int Id;
   public string Name;
   public string Isbn;
   public double Price;


   public Product(int id, string name, string isbn)
   {
      Id = id;
      Name = name;
      Isbn = isbn;
      Price = 0.0;
   }
   public Product(int id, string name, string isbn, double price)
   {
      Id = id;
      Name = name;
      Isbn = isbn;
      Price = price;
   }
}

 








Related examples in the same category

1.A basic TreeView control
2.A TreeView control with the MSDN style applied to it
3.Binding a TreeView control to the Data.xml file
4.Add check boxes to leaf nodes (C#)
5.Add check boxes to leaf nodes (VB)
6.Applying custom images to the TreeView control
7.Expanding and collapsing the nodes of the TreeView control programmatically (C#)
8.Expanding and collapsing the nodes of the TreeView control programmatically (VB)
9.Expanding specific nodes programmatically
10.Expanding nodes programmatically using the Expanded property
11.Displaying database data with a TreeView control.
12.Using Populate On Demand and AJAX
13.Formatting the TreeView Control
14.Using Styles with the TreeView control.
15.Applying styles to different TreeView node levels.
16.Adding nodes programmatically to the TreeView control (C#)
17.Adding nodes programmatically to the TreeView control (VB)
18.Custom TreeView Control
19.TreeView Populate On Demand
20.Test TreeView
21.TreeView DataBindings
22.Dynamic tree view
23.ParentNodeStyle in a TreeView
24.DirectoryInfo TreeView