首页 > 学院 > 开发设计 > 正文

TreeView绑定无限层级关系类

2019-11-17 03:13:26
字体:
来源:转载
供稿:网友

TreeView绑定无限层级关系类

PRotected void Page_Load(object sender, EventArgs e){if (!IsPostBack){Bind_TV(TreeView1.Nodes);}}#region 添加父节点////// 添加父节点//////private void Bind_TV(TreeNodeCollection tree){//先添加第一级父节点uint id = Convert.ToUInt32(session["ID"]);//登陆人idstring sqlmcount = "select * from account where status=1 and id='" + id + "'";DataTable Trdtmcount = MySQLDbHelper.GetDataTable(sqlmcount, null);if (Trdtmcount.Rows.Count > 0){TreeNode tn = new TreeNode();tn.Value = Trdtmcount.Rows[0]["id"].ToString();tn.Text = Trdtmcount.Rows[0]["nickname"].ToString();tree.Add(tn);BindSon(Convert.ToUInt32(Trdtmcount.Rows[0]["id"]), tn.ChildNodes);//根据父节点添加子节点}}#endregion#region 递归添加子节点////// 递归添加子节点/////////private void BindSon(uint fatherid, TreeNodeCollection tree){string sqlMancount = "select id,nickname from account where masterid=" + fatherid + ";";DataTable sonDT = MySqlDbHelper.GetDataTable(sqlMancount, null);DataView dv = new DataView(sonDT);foreach (DataRowView item in dv){//判断此人id 是否有下属if (sonDT.Rows.Count > 0)//有{TreeNode sontn = new TreeNode();sontn.Value = item["id"].ToString();sontn.Text = item["nickname"].ToString();tree.Add(sontn);BindSon(Convert.ToUInt32(item["id"]), sontn.ChildNodes);}}}#endregion
发表评论 共有条评论
用户名: 密码:
验证码: 匿名发表