treeview调取数据库

 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 = "sid='0'";  //筛选到根结点的所有子节点
        }
        else  //不是根结点
        {
            dv.RowFilter = "sid='" + node.Value + "'";   //筛选对应节点的所有子节点
        }
        foreach (DataRowView drv in dv)   //遍历填充节点的所有子节点，如果传入的节点node为叶子节点，遍历要退出，不再进行递归
        {
            TreeNode no = new TreeNode(drv["txt"].T