动态绑定treeview 无限极

前台: <asp:TreeView ID="TreeView1" runat="server" Height="450px" Width="180px" >
        </asp:TreeView>

后台:

public partial class User_MyTeam : BasePageUserManger
{
    string sql = "";
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            SelectTop();

        }
    }
    protected void TreeView1_SelectedNodeChanged(object sender, EventArgs e)
    {

    }
    //查询顶级
   public  void SelectTop()
    {
        sql = string.Format("select * from user_table where Id={0}", int.Parse(Session["userId"].ToString()));

        DataTable dt = cls_common.QSQL_DT(sql);
        foreach (DataRow dr in dt.Rows)
        {
            TreeNode node = new TreeNode();
            node.Text = dr["userCode"].ToString();
            node.Value = dr["Id"].ToString();
            //bind child nodes
            BindNodes(dt.Rows[0]["userCode"].ToString(), node);
            TreeView1.Nodes.Add(node);
        }
    }
//查询子集
 void BindNodes(string  parentID, TreeNode node)
   {
       sql = string.Format("select * from user_table  where userParentCode='{0}'", parentID);
       DataTable dt = cls_common.QSQL_DT(sql);
       foreach (DataRow rows in dt.Rows)
       {
           TreeNode tnode = new TreeNode();
           tnode.Text = rows["userCode"].ToString();
           tnode.Value = rows["Id"].ToString();
           node.ChildNodes.Add(tnode);
           BindNodes(dt.Rows[0]["userCode"].ToString(), tnode);
       }
   }

}