defaultcs.aspx.cs

来自「Telerik是很大的第三方软件制造商」· CS 代码 · 共 92 行

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
using Telerik.QuickStart;
using Telerik.WebControls;

namespace Telerik.TreeViewExamplesCSharp.SqlBinding
{
	/// <summary>
	/// Summary description for _Default.
	/// </summary>
	public class DefaultCS: XhtmlPage
	{
		protected Telerik.WebControls.RadTreeView RadTree1;
	
		private void GenerateTreeView()
		{
			OleDbConnection dbCon = new OleDbConnection ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("~/TreeView/Data/Tree.mdb")); 
			dbCon.Open();

			OleDbDataAdapter adapter = new OleDbDataAdapter("SELECT * FROM Links", dbCon); 
			DataSet ds = new DataSet();
			adapter.Fill(ds);

			ds.Relations.Add("NodeRelation", ds.Tables[0].Columns["id"], ds.Tables[0].Columns["parentId"]);

			foreach(DataRow dbRow in ds.Tables[0].Rows)
			{
				if(dbRow.IsNull("parentId"))
				{					
					RadTreeNode node = CreateNode(dbRow["Text"].ToString(), true, dbRow["id"].ToString());
					RadTree1.AddNode(node);
					RecursivelyPopulate(dbRow, node);
				}
			}
		}

		private void RecursivelyPopulate(DataRow dbRow, RadTreeNode node)
		{
			foreach (DataRow childRow in dbRow.GetChildRows("NodeRelation"))
			{				
				RadTreeNode childNode = CreateNode(childRow["Text"].ToString(), true, childRow["id"].ToString());
				node.AddNode(childNode);
				RecursivelyPopulate(childRow, childNode);				
			}
		}

		private RadTreeNode CreateNode(string text, bool expanded, string id)
		{
			RadTreeNode node = new RadTreeNode(text);
			node.Expanded = true;
			node.ID = id;

			return node;
		}

		private void Page_Load(object sender, System.EventArgs e)
		{
			if (!Page.IsPostBack)
			{			
				GenerateTreeView();
			}
		}

		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: This call is required by the ASP.NET Web Form Designer.
			//
			InitializeComponent();
			base.OnInit(e);
		}

		private void InitializeComponent()
		{
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

	}
}