将药品类别表数据加载到页面的目录树中

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

public partial class Daochu节点树 : System.Web.UI.Page
{
    string sqlstr=ConfigurationManager.ConnectionStrings["sqlstr"].ConnectionString;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            bindTree();
        }
       
    }
    private void bindTree()
    {
        DataTable dt = this.GetTreeData();
        this.FillNode(dt,null);
    }
    private void FillNode(DataTable dt,TreeNode node)
    {
        DataView dv = new DataView(dt);
        if (node==null)
        {
            dv.RowFilter = "parentid='0'";
        }
        else
        {
            dv.RowFilter = "parentid='" + node.Value + "'";
        }
        foreach (DataRowView drv in dv)   //遍历填充节点的所有子节点，如果传入的节点node为叶子节点，遍历要退出，不再进行递归
        {
            TreeNode no = new TreeNode(drv["drugname"].ToString(), drv["drugid"].ToString());
            FillNode(dt, no);  //填充no节点的子节点
            if (node == null)
            {
                this.TreeView1.Nodes.Add(no);
            }
            else
            {
                node.ChildNodes.Add(no);
            }
        }       
    }
    private DataTable GetTreeData()
    {
        using (SqlConnection sqlcnn = new SqlConnection(sqlstr))
        {
            using (SqlCommand sqlcmm = sqlcnn.CreateCommand())
            {
                sqlcmm.CommandText = "select * from Drug order by parentid";
                sqlcnn.Open();
                DataSet ds = new DataSet();
                SqlDataAdapter adapter = new SqlDataAdapter(sqlcmm);
                adapter.Fill(ds);
                return ds.Tables[0];
            }
        }
    }
}