Vs 2005 treeview无限循环

 

 

        protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            TreeNode tn = new TreeNode();
            tn.Text = "济南科大原创信息技术有限公司";
            addNode("1", tn);
            this.TreeView1.Nodes.Add(tn);
        }
    }
    private void addNode(string ParentID, TreeNode pNode)
    {

        DataView dvTree = drv("select * from P_Dept where Pdt_id!=1");
        dvTree.RowFilter = " Pdt_fid= '" + ParentID + "' ";
        foreach (DataRowView drv1 in dvTree)
        {
            TreeNode node = new TreeNode();
            if (pNode == null)
            {
                node.Text = drv1["Pdt_name"].ToString();
                this.TreeView1.Nodes.Add(node);
                node.Expanded = true;
                node.NavigateUrl = "user.aspx?nid=" + drv1["Pdt_id"].ToString().Trim();
                int n = Convert.ToInt32(drv1["Pdt_id"].ToString());
                node.Value = drv1["Pdt_id"].ToString();
                this.addNode(drv1["Pdt_id"].ToString(), node);
            }
            else
            {
                node.Text = drv1["Pdt_name"].ToString();
                pNode.ChildNodes.Add(node);
                node.Expanded = true;
                node.NavigateUrl = "user.aspx?nid=" + drv1["Pdt_id"].ToString().Trim();
                node.Value = drv1["Pdt_id"].ToString();
                this.addNode(drv1["Pdt_id"].ToString(), node);

            }
        }
    }
    private DataView drv(string query)
    {
        //string connstr = ConfigurationManager.ConnectionStrings["TreeViewCon"].ConnectionString;
        SqlConnection conn = new SqlConnection("server=192.168.50.41;uid=sa;pwd=123;database=OA_kdyc");
        conn.Open();
        SqlDataAdapter sda = new SqlDataAdapter(query, conn);
        DataSet ds = new DataSet();
        sda.Fill(ds, "tree");
        return ds.Tables["tree"].DefaultView;
    }

 

修改一下可以用在menu控件上，如下图

文章地址：http://www.cnblogs.com/njypcmqj/archive/2007/06/09/777581.html