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

上一篇：Managed DirectX中的DirectShow應用（簡單Demo及源碼)

下一篇：C#文件及文件夾復制，移動，刪除