mysql 删除树节点_树的操作（绑定数据库，添加新节点，删除节点）(转载加实现)...-CSDN博客

本文链接：https://blog.csdn.net/weixin_42501688/article/details/113475684

这篇博客介绍了如何在ASP.NET MVC中创建一个大师页面，实现了动态绑定树形菜单（TreeLeft）和下拉列表（ddlParentID）。通过`TreeleftBind`和`bindGroup`方法，分别展示了如何从数据库获取数据并构建树形结构，以及如何根据父节点ID填充下拉列表。此外，还提供了添加新节点、删除已选节点的功能，并在节点被选中时触发页面跳转。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

usingSystem;usingSystem.Data;usingSystem.Configuration;usingSystem.Collections;usingSystem.Web;usingSystem.Web.Security;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Web.UI.WebControls.WebParts;usingSystem.Web.UI.HtmlControls;usingSystem.Data.SqlClient;publicpartialclassMaster_MasterPage : System.Web.UI.MasterPage

{protectedvoidPage_Load(objectsender, EventArgs e)

{if(!IsPostBack)

{

TreeleftBind();

bindGroup();

}

}#region绑定树privatevoidTreeleftBind()

{this.TreeLeft.Nodes.Clear();

DataTable dt=master.Getdt();

DataView dv=newDataView(dt);

dv.RowFilter="TreeParentID = 0";

TreeNode node=newTreeNode();foreach(DataRowView drvindv)

{

node.Text=drv["TreeName"].ToString();

node.Value=drv["ID"].ToString();

node.Expanded=true;this.TreeLeft.Nodes.Add(node);

AddReplies(dt, node);

}

}privatevoidAddReplies(DataTable dt, TreeNode node)

{

DataView dv=newDataView(dt);

dv.RowFilter="TreeParentID='"+node.Value+"'";foreach(DataRowView rowindv)

{

TreeNode replyNode=newTreeNode();

replyNode.Text=row["TreeName"].ToString();

replyNode.Value=row["ID"].ToString();

replyNode.NavigateUrl=row["Link"].ToString();

replyNode.Expanded=false;

node.ChildNodes.Add(replyNode);

replyNode.ShowCheckBox=true;

AddReplies(dt, replyNode);

}

}#endregion#region绑定DropDownListprivatevoidbindGroup()

{this.ddlParentID.Items.Clear();

DataTable dt=master.Getdt();//获取所有节点if(dt.Rows.Count>0)

{foreach(DataRow rowindt.Rows)

{if(row["TreeParentID"].ToString().Trim()=="0")//绑定根节点{this.ddlParentID.Items.Add(newListItem(row["TreeName"].ToString(), row["Id"].ToString()));this.bindDropChildItem(this.ddlParentID, dt, row["ID"].ToString(),1);

}

}privatevoidbindDropChildItem(DropDownList d, DataTable dt,stringid,intlength)

{

DataRow[] rows=dt.Select("TreeParentID='"+id+"'","Id ASC");//取出id子节点进行绑定for(inti=0; i

{this.ddlParentID.Items.Add(newListItem(this.SpaceLength(length)+rows[i]["TreeName"].ToString(), rows[i]["Id"].ToString()));this.bindDropChildItem(d, dt, rows[i]["Id"].ToString(), length+1);//空白数目加1}

}privatestringSpaceLength(inti)

{stringspace="";for(intj=0; j

{

space+="--";

}returnspace;

}#endregion#region动态增加节点protectedvoidbtnSubmit_Click(objectsender, EventArgs e)

{stringrootID=ddlParentID.SelectedValue.ToString();stringtxtName=this.txtNodeName.Text;

master.InsertNode("AutoTree","TreeName","TreeParentID",txtName,rootID);this.txtNodeName.Text="";

TreeleftBind();

bindGroup();

}#endregion#region动态删除节点protectedvoidbtnDelete_Click(objectsender, EventArgs e)

{if(TreeChecked()!=0)

{stringstrjavascript="";

Page.ClientScript.RegisterStartupScript(this.GetType(),"onclick", strjavascript);

}else{foreach(TreeNode nodeinTreeLeft.CheckedNodes)

{stringSelectTreeID=node.Value;

master.DeleteRecords(SelectTreeID);

}

TreeleftBind();

bindGroup();

}

}protectedintTreeChecked()

{intcount=0;foreach(TreeNode nodeinthis.TreeLeft.CheckedNodes)

{if(node.ChildNodes.Count>0)

{

count=count+1;

}

}returncount;

}#endregion#region页面跳转protectedvoidTreeLeft_SelectedNodeChanged(objectsender, EventArgs e)

{

TreeNode node=TreeLeft.SelectedNode;if(node.ChildNodes.Count!=0)

{

node.SelectAction=TreeNodeSelectAction.Expand;

node.Expanded=true;

}else{stringurl="@"+node.NavigateUrl;

Response.Redirect(url);//数据库中LINK字段的数据为：~/WOW/Moniqi.aspx//Response.Redirect(@"~/Yule/wowmoni.aspx");}

}#endregion}