建树的基本思路：从根节点开始递归调用显示子树

来源：互联网发布：安卓软件评测编辑：程序博客网时间：2024/05/14 10:32

数据库如下：

NodeId ParentId NodeName Address Icon 100000 0 公共查询部 icon_document.gif 100001 100000 人民币日报查询 public/a1.aspx icon_settings.gif 100002 100000 外币日报查询 public/a2.aspx icon_settings.gif 100003 0 分行科技部 tech/a1.aspx icon_document.gif 100004 100003 人民币日报查询 tech/a2.aspx icon_settings.gif 100005 100003 外币日报查询 100006 0 福田支行 icon_document.gif 100007 100006 月存款进度表 a1.aspx icon_settings.gif 100008 100006 月存款走势图 a2.aspx icon_settings.gif 100009 0 罗湖支行 icon_document.gif 100010 100009 月存款进度表 a1.aspx icon_settings.gif 100011 100009 月存款走势图 a2.aspx icon_settings.gif

public class menu_Left : System.Web.UI.Page
{
protected Microsoft.Web.UI.WebControls.TreeView tvMenu;
SqlConnection Conn;
SqlDataAdapter myCmd;
DataSet ds;
string cmdSelect;

private void Page_Load(object sender, System.EventArgs e)
{
   Conn=new SqlConnection(Application["ConnString"].ToString());
   CreateDataSet();
   InitTree(tvMenu.Nodes,"0");
}
//建立数据集
private DataSet CreateDataSet()
{
   cmdSelect="select * from S_Menu";
   myCmd=new SqlDataAdapter(cmdSelect,Conn);
   ds=new DataSet();
   myCmd.Fill(ds,"tree");
   return ds;
}
//建树的基本思路是：从根节点开始递归调用显示子树
         private void InitTree(TreeNodeCollection Nds,string parentId)
{
   DataView dv=new DataView();
   TreeNode tmpNd;
   string intId;
   dv.Table=ds.Tables["tree"];
   dv.RowFilter="ParentId='" + parentId + "'" ;
   foreach(DataRowView drv in dv)
   {
    tmpNd=new TreeNode();
    tmpNd.ID=drv["NodeId"].ToString();
    tmpNd.Text=drv["NodeName"].ToString();
    tmpNd.ImageUrl="../images/"+drv["Icon"].ToString();
    tmpNd.NavigateUrl="../"+drv["Address"].ToString();
    Nds.Add(tmpNd);
    intId=drv["ParentId"].ToString();
    InitTree(tmpNd.Nodes,tmpNd.ID);
   }
}