下面是我工作中遇到读取树结构 (即如何将一树结构的数据绑定到一个TreeView，级数可扩展) 时找到一个小方法，作为收藏并共享给大家。

1.数据表结构如下:

2、页面文件Default.aspx

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

http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
http://www.w3.org/1999/xhtml">

   


   
 
    function client_OnTreeNodeChecked()
    {
        var bj = window.event.srcElement;
            var treeNodeFound = false;
            var checkedState;
            if (obj.tagName == "INPUT" && obj.type == "checkbox") {
            var treeNode = obj;
            checkedState = treeNode.checked;
            do
            {
            bj = obj.parentElement;
            } while (obj.tagName != "TABLE")
            var parentTreeLevel = obj.rows[0].cells.length;
            var parentTreeNode = obj.rows[0].cells[0];
            var tables = obj.parentElement.getElementsByTagName("TABLE");
            var numTables = tables.length
            if (numTables >= 1)
            {
                for (i=0; i < numTables; i++)
                {
                    if (tables[i] == obj)
                    {
                    treeNodeFound = true;
                    i++;
                        if (i == numTables)
                        {
                        return;
                        }
                    }
                    if (treeNodeFound == true)
                    {
                         var childTreeLevel = tables[i].rows[0].cells.length;
                            if (childTreeLevel > parentTreeLevel)
                            {
                            var cell = tables[i].rows[0].cells[childTreeLevel - 1];
                            var inputs = cell.getElementsByTagName("INPUT");
                            inputs[0].checked = checkedState;
                            }
                        else
                        {
                        return;
                        }
                    }
                }
            }}
        }
 

3、代码文件Default.aspx.cs

using System;
using System.Data;
using System.Configuration;
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;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        this.bindtvUserGroup();

    }

    #region 为TreeView添加节点

    public void bindtvUserGroup()//为树添加一个 "总目录".
    {

        this.tvUGManage.Nodes.Clear();

        TreeNode tnUG = new TreeNode();

        tnUG.Text = "F0000根目录";

        tnUG.Value = "F0000";

        tnUG.Expanded = true;

        tvUGManage.Nodes.Add(tnUG);

        bindtvParentUserGroup(tnUG);

    }

    public void bindtvParentUserGroup(TreeNode tnTwo)//在总目录下...添加 "父级树结点"
    {

        string sqlString = "select FID,FNodeKey,FParentNodeKey,FFunctionName from B_Functions";
        string CnnString = "Data Source=(local);Initial Catalog=Test;User ID=sa;Password=111111;";
        SqlConnection myconn = new SqlConnection(CnnString);
        myconn.Open();
        SqlCommand B_ZSGC = new SqlCommand();
        B_ZSGC.Connection = myconn;
        B_ZSGC.CommandType = CommandType.Text;
        B_ZSGC.CommandText = sqlString;
        SqlDataAdapter dt = new SqlDataAdapter();
        dt.SelectCommand = B_ZSGC;
        DataSet dsBF = new DataSet();
        dt.Fill(dsBF);

        DataTable dtBF = dsBF.Tables[0];

        //this.tvUserGroup.Nodes.Clear();

        DataRow[] RowList = dtBF.Select("FParentNodeKey = 'F0000'");

        if (RowList.Length > 0)
        {

            for (int i = 0; i < RowList.Length; i++)
            {

                TreeNode tnTwoUG = new TreeNode();

                tnTwoUG.Text =  RowList[i]["FFunctionName"].ToString();

                tnTwoUG.Value = RowList[i]["FNodeKey"].ToString();

                tnTwoUG.Expanded = false;

                tnTwo.ChildNodes.Add(tnTwoUG);//总目录下添加子结点(父级树结点)

                bindtvChildUserGroup(tnTwoUG, dtBF);

            }

        }

    }

    public void bindtvChildUserGroup(TreeNode tnThre, DataTable dtChild)//在父级树结点下添加 "子结点"
    {

        DataRow[] RowList = dtChild.Select("FParentNodeKey = '" + tnThre.Value + "'");

        if (RowList.Length > 0)
        {

            for (int j = 0; j < RowList.Length; j++)
            {

                TreeNode tnThreUG = new TreeNode();

                tnThreUG.Text =  RowList[j]["FFunctionName"].ToString();

                tnThreUG.Value = RowList[j]["FNodeKey"].ToString();

                //tnThreUG.Expanded = false;

                tnThre.ChildNodes.Add(tnThreUG);

                bindtvChildUserGroup(tnThreUG, dtChild); //循环遍历子节点.

            }

        }

    }

    #endregion

}

4、完成效果忘了截图，自己试一下吧！