treeview 动态邦定数据

最新推荐文章于 2024-04-18 09:36:30 发布

tao19840705

最新推荐文章于 2024-04-18 09:36:30 发布

阅读量401

点赞数

分类专栏： ASP.NET 文章标签： string cmd

本文链接：https://blog.csdn.net/tao19840705/article/details/5858860

版权

ASP.NET 专栏收录该内容

15 篇文章 0 订阅

订阅专栏

    private void Bind()
    {
        string rootStr = "物料类别";
        TreeNode rootNode = new TreeNode(rootStr);
        rootNode.Value = "-1";
       // rootNode.Target = "main";
        //rootNode.NavigateUrl = string.Format("YLtypeUpdate.aspx?id={0}&name={1}&yltypename={2}", "0", "update", "物料类别");
        PopulateTreeView("0", rootNode);
        this.TreeView1.Nodes.Add(rootNode);
        this.TreeView1.ExpandAll();

    }
    private void PopulateTreeView(string parentId, TreeNode parentNode)
    {
        StringBuilder sb = new StringBuilder();
        sb.Append(" select kp_yltype_no ,kp_yltype_name from jb_bagyltype where kp_yltype_parent='" + parentId + "'");
        DbCommand cmd = GenericDataAccess.createcommand(sb.ToString());

        DataView dv = GenericDataAccess.selectcommand(cmd).DefaultView;    //classes.GetClass("parentId=" + parentId.ToString()).DefaultView;
        foreach (DataRowView drv in dv)
        {
            TreeNode myNode = new TreeNode(drv["kp_yltype_name"].ToString());
            //myNode.Expanded = false;
            myNode.Value = drv["kp_yltype_no"].ToString();
           // myNode.Target = "main";
           // myNode.NavigateUrl = string.Format("YLtypeUpdate.aspx?id={0}&name={1}&yltypename={2}", drv["kp_yltype_no"].ToString(), "update", drv["kp_yltype_name"].ToString());   //"body.aspx?classId=" + drv["classId"].ToString();
            parentNode.ChildNodes.Add(myNode);
            PopulateTreeView(drv["kp_yltype_no"].ToString(), myNode);
        }
    }