Database tree : TreeView « Asp Control « ASP.Net

ASP.Net
1. ADO.net Database
2. Ajax
3. Asp Control
4. Collections
5. Components
6. Data Binding
7. Development
8. File Directory
9. HTML Control
10. Language Basics
11. Login Security
12. Mobile Control
13. Network
14. Page
15. Request
16. Response
17. Server
18. Session Cookie
19. Sitemap
20. Theme Style
21. User Control and Master Page
22. Validation by Control
23. Validation by Function
24. WebPart
25. WPF
26. XML
Java
Java Tutorial
Java Source Code / Java Documentation
Java Open Source
Jar File Download
Java Articles
Java Products
Java by API
Photoshop Tutorials
Maya Tutorials
Flash Tutorials
3ds-Max Tutorials
Illustrator Tutorials
GIMP Tutorials
C# / C Sharp
C# / CSharp Tutorial
C# / CSharp Open Source
ASP.NET Tutorial
JavaScript DHTML
JavaScript Tutorial
JavaScript Reference
HTML / CSS
HTML CSS Reference
C / ANSI-C
C Tutorial
C++
C++ Tutorial
Ruby
PHP
Python
Python Tutorial
Python Open Source
SQL Server / T-SQL
SQL Server / T-SQL Tutorial
Oracle PL / SQL
Oracle PL/SQL Tutorial
PostgreSQL
SQL / MySQL
MySQL Tutorial
VB.Net
VB.Net Tutorial
Flash / Flex / ActionScript
VBA / Excel / Access / Word
XML
XML Tutorial
Microsoft Office PowerPoint 2007 Tutorial
Microsoft Office Excel 2007 Tutorial
Microsoft Office Word 2007 Tutorial
ASP.Net » Asp Control » TreeView 
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
www.java2java.com | Contact Us
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.