public class XmlTreeModel {

#region Private Variable

private int _indexid;

private int _parentid;

private string _title = string.Empty;

private System.Collections.Generic.List<xmltreemodel> _childnodes = new System.Collections.Generic.List</xmltreemodel><xmltreemodel>();

private XmlTreeModel _parent = null;

private string _pathoftreeindex = string.Empty;

private string _pathoftitle = string.Empty;

private string _xmltag = string.Empty;

private string _pathseparator = "/";   // 搭配TreeView.PathSeparator使用

#endregion

#region public enum XmlTreeModelPathType {...}

public enum XmlTreeModelPathType {

        PathOfTreeIndex = 0,

        PathOfTitle = 1

}

#endregion

#region Public Property

public int IndexID { get { return _indexid; } }

public int ParentID { get { return _parentid; } }

public string Title { get { return _title; } }

public System.Collections.Generic.List</xmltreemodel><xmltreemodel> ChildNodes { get { return _childnodes; } }

public XmlTreeModel Parent { get { return _parent; } }

public string XmlTagName { get { return _xmltag; } }

public string PathSeparator {

        get { return _pathseparator; }

        set { _pathseparator = value; }

}

#endregion

#region 多型 public XmlTreeModel()

#region public XmlTreeModel(int indexid, string title) {...}

public XmlTreeModel(int indexid, string title) {

        _indexid = indexid;

        _title = title;

        _pathoftitle = title;

        _pathoftreeindex = indexid.ToString();

        _xmltag = _title.Replace(' ', '_');

}

#endregion

#region public XmlTreeModel(int indexid, string title, string xmltagname) {...}

public XmlTreeModel(int indexid, string title, string xmltagname) {

        _indexid = indexid;

        _title = title;

        _pathoftitle = title;

        _pathoftreeindex = indexid.ToString();

        _xmltag = xmltagname;

}

#endregion

#endregion

#region public XmlTreeModel AppendChild(XmlTreeModel item) {...}

public XmlTreeModel AppendChild(XmlTreeModel item) {

        item._parent = this;

        item._parentid = this._indexid;

        item._pathseparator = this._pathseparator;

        item._pathoftreeindex = this._pathoftreeindex + this._pathseparator + item._pathoftreeindex;

        item._pathoftitle = this._pathoftitle + this._pathseparator + item._pathoftitle;

        _childnodes.Add(item);

return item;

}

#endregion

#region 多型 public string ToXMLString()

#region public string ToXMLString() {...}

public string ToXMLString() {

return ToXMLString(false);

}

#endregion

#region public string ToXMLString(bool bInsCrLf) {...}

public string ToXMLString(bool bInsCrLf) {

string cr = (bInsCrLf) ? "\n" : "";

string sXml = "< " + this._xmltag + " IndexID=\"" + this._indexid + "\" Title=\"" + this._title + "\"";

if (this._childnodes.Count == 0) {

            sXml += " />" + cr;

} else {

            sXml += ">" + cr;

foreach (XmlTreeModel xtm in this._childnodes) {

string nXml = xtm.ToXMLString(bInsCrLf);

                sXml += nXml;

}

            sXml += "" + cr;

}

return sXml;

}

#endregion

#endregion

#region public XmlTreeModel SearchNode(string treePath, XmlTreeModelPathType pt) {...}

public XmlTreeModel SearchNode(string treePath, XmlTreeModelPathType pt) {

string chkPath = string.Empty;

switch (pt) {

case XmlTreeModelPathType.PathOfTreeIndex:

                chkPath = this._pathoftreeindex;

break;

case XmlTreeModelPathType.PathOfTitle:

                chkPath=this._pathoftitle;

break;

default:

break;

}

if (chkPath == treePath)

return this;

foreach (XmlTreeModel xtm in _childnodes) {

            XmlTreeModel node = xtm.SearchNode(treePath, pt);

if (node != null)

return node;

}

return null;

}

#endregion

}

using System;

using System.Configuration;

using System.Data;

using System.Data.SqlClient;

public class QAManager {

    XmlTreeModel Root;

public string XmlString { get { return Root.ToXMLString(); } }

public QAManager() { SetXmlTreeModel(); }

#region private void SetXmlTreeModel() {...}

private void SetXmlTreeModel() {

        SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);

        cn.Open();

        SqlCommand cmd = new SqlCommand();

        cmd.Connection = cn;

        cmd.CommandType = CommandType.Text;

        cmd.CommandText = "Select * From TB_QAClasses Order By DataPath";

        SqlDataReader reader = cmd.ExecuteReader();

        Root = new XmlTreeModel(0, "Q &amp; A", "Root");

while (reader.Read()) {

string path = (string)reader["DataPath"];

string parentPath = path.Substring(0, path.LastIndexOf('/'));

            XmlTreeModel xtm = Root.SearchNode(parentPath, XmlTreeModel.XmlTreeModelPathType.PathOfTreeIndex);

if (xtm != null) {

                xtm.AppendChild(new XmlTreeModel((int)reader["ClassID"], (string)reader["Title"], "Class"));

}

}

        reader.Close();

        cmd.Dispose();

        cn.Close();

        cn.Dispose();

}

#endregion

}

CREATE TABLE [dbo].[TB_QAClasses] (

[ClassID] [int] IDENTITY (1, 1) NOT NULL ,

[Title] [nvarchar] (32) NOT NULL ,

[DataPath] [varchar] (256) NOT NULL

) ON [PRIMARY]

GO

ALTER TABLE [dbo].[TB_QAClasses] ADD

    CONSTRAINT [DF_TB_QAClasses_ParentID] DEFAULT ('0') FOR [DataPath],

    CONSTRAINT [PK_TB_QAClasses] PRIMARY KEY  CLUSTERED

(

[ClassID]

)  ON [PRIMARY]

GO

protected void Page_Load(object sender, EventArgs e) {

if (!IsPostBack) {

        SetTreeView();

}

}

private void SetTreeView() {

    xds.Data = new QAManager().XmlString;       // 利用QAManager自資料庫中取回資料並轉成XML格式

    xds.GetXmlDocument().LoadXml(xds.Data);     // 利用XmlDataSource的GetXmlDocument()載入XML資料

    tv.DataBindings.Clear();

    TreeNodeBinding tnb = new TreeNodeBinding();// 設定TreeView的節點

    tnb.TextField = "Title";                    //

    tnb.ValueField = "IndexID";                 //

    tnb.ToolTipField = "Title";                 //

    tv.DataBindings.Add(tnb);                   //

    tv.DataSourceID = "xds";                    // 指定TreeView的DataSourceID為xds

    tv.DataBind();                              // 執行Databind()

    tv.ExpandAll();                             // 展開樹狀目錄

}