效果：

 

前端代码：

1 <%@ Master Language="C#" AutoEventWireup="true" CodeBehind="Site1.master.cs" Inherits="APManage.Site1" %> 2  3  4  5  6  7 
       8      9     
      
       10     
      11 12 13     
      
       14     
       
        15         
        
         16         
        17         
        
         修改节点
        18         
        
         19         20         
        21     
       
22     
      
23 24 

 

后端代码：

1 using System; 2 using System.Collections.Generic; 3 using System.Data; 4 using System.Linq; 5 using System.Web; 6 using System.Web.UI; 7 using System.Web.UI.WebControls; 8 using APManage.App_Code; 9 using System.Data.SqlClient;10 11 12 namespace APManage13 {14     public partial class updateNodes : System.Web.UI.Page15     {16         protected void Page_Load(object sender, EventArgs e)17         {18             this.DropDownList1.DataSource = SQLHelper.ExecuteTable("select * from Tb_APCategory where ParentID = 1000", CommandType.Text);19             this.DropDownList1.DataValueField = "ID";20             this.DropDownList1.DataTextField = "CategoryName";21             this.DropDownList1.DataBind();22 23 24             List
      
        inof = new List
       
        ();25             SqlDataReader sdr = SQLHelper.ExcuteReader("select ID, CategoryName from Tb_APCategory where ParentID = 1000", CommandType.Text);26             while (sdr.Read())27             {28                 SqlDataReader sdr_2 = SQLHelper.ExcuteReader("select ID, CategoryName from Tb_APCategory where ParentID = " + sdr["ID"].ToString() + "", CommandType.Text);29                 while (sdr_2.Read())30                 {31                     inof.Add(new category(sdr_2["ID"].ToString(), sdr_2["CategoryName"].ToString()));32                 }33             }34 35             this.DropDownList2.DataSource = inof;36             this.DropDownList2.DataValueField = "ID";37             this.DropDownList2.DataTextField = "Name";38             this.DropDownList2.DataBind();39 40             //this.DropDownList2.DataSource = SQLHelper.ExecuteTable("select * from Tb_APCategory", CommandType.Text);41             //this.DropDownList2.DataValueField = "";42             //this.DropDownList2.DataTextField = "";43             //this.DropDownList2.DataBind();44         }45 46         public class category47         {48             public category(string id, string name)49             {50                 Id = id;51                 Name = name;52             }53 54             private string id;55 56             public string Id57             {58                 get { return id; }59                 set { id = value; }60             }61 62             private string name;63 64             public string Name65             {66                 get { return name; }67                 set { name = value; }68             }69         }70     }71 }