用递归无限级绑定 treeview,DropDownList

最新推荐文章于 2025-10-21 22:09:11 发布

原创最新推荐文章于 2025-10-21 22:09:11 发布 · 1k 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#dataset #string #command #database #menu

ASP.NET(C#) 专栏收录该内容

108 篇文章

订阅专栏

本文介绍了一种使用TreeView和DropDownList进行数据绑定的方法。通过SQL查询从数据库中获取层级结构的数据，并将其填充到TreeView中展示所有文章类型及其子项。同时，利用存储过程填充DropDownList，以递归方式展示具有层级关系的选项。

表结构，id ,Parentid

TreeView:

public void bind()
  {
   TreeNode no=new TreeNode();
   no.Expanded = true;
   TreeView2.Nodes.Add(no);
   no.Text = "所有文章类型";
   CreateTree("0", no);
  }
  private void CreateTree(string belong,TreeNode rootnode)
  {
//   SqlConnection connString = new SqlConnection("server=192.168.2.9;uid=sa;pwd=;database=Bjmti");
   SqlConnection connString = new SqlConnection(ConfigurationSettings.AppSettings["ConnStr"].ToString());
   SqlCommand command = new SqlCommand("Select * FROM school_Menu where W_ParentID='"+belong+"'", connString);
   SqlDataAdapter adapter = new SqlDataAdapter(command);
   DataSet ds = new DataSet();
   adapter.Fill(ds);
   foreach(DataRow dr in ds.Tables[0].Rows)
   {
    TreeNode treenode = new TreeNode();
    treenode.Text = dr["W_Name"].ToString().Trim();
    treenode.Expanded = true;
    rootnode.Nodes.Add(treenode);
    string id = dr["W_ID"].ToString().Trim();
    treenode.NavigateUrl="Bjmti_ArticleShow_List.aspx?ID="+dr["W_ID"].ToString()+"";
    CreateTree(id, treenode);
   }
  }

DropDownList:

private void GetArticleCategory(string pid)
  {
   string strSpGroup = "Bjmti_KD_Ken_SEL_Group";
   SqlParameter[] spParamGroup = new SqlParameter[1];
   spParamGroup[0] =new SqlParameter("@KD_ParentID",SqlDbType.VarChar,36);
   spParamGroup[0].Value=pid;
            DataSet ds= DbHelperSQL.BjmtiDataSet(strSpGroup,spParamGroup);
     foreach(DataRow row in ds.Tables[0].Rows)
     {
    this.ddlKl.Items.Add(new ListItem(toadd + " " + row["KD_Name"].ToString(),row["KD_ID"].ToString()));
    toadd += "─┴";
    this.GetArticleCategory(row["KD_ID"].ToString());
    toadd = toadd.Substring(0, toadd.Length - 2); //处理层次关系显示
   }
  }