ddl无限绑定栏目（递归实现）

最新推荐文章于 2024-09-20 17:14:37 发布

Awinye

最新推荐文章于 2024-09-20 17:14:37 发布

阅读量1.5k

点赞数

分类专栏： asp.net 文章标签： string cmd 数据库

asp.net 专栏收录该内容

69 篇文章 0 订阅

订阅专栏

数据库中的表NewsKind

NewsKindID int
NewsKindName varchar
ParentID int

SqlConnection conn = new SqlConnection (System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
    conn.Open();
    string sqlstr = "select NewsKindID, NewsKindName,ParentID from NewsKind where ParentID=0 order by NewsKindID asc";
    SqlCommand cmd = new SqlCommand(sqlstr,conn);
    SqlDataReader dr = cmd.ExecuteReader();
    while(dr.Read())
    {
     ddlParentNewsKind.Items.Add(new ListItem(("┣")+dr["NewsKindName"].ToString(),dr["NewsKindID"].ToString()));
     if(dr["NewsKindID"].ToString()!=dr["ParentID"].ToString())
     {
      smallClass(long.Parse(dr["NewsKindID"].ToString()),"┃");
     }
    }

private void smallClass(long classId,string tempStr)
  {
   SqlConnection conn = new SqlConnection (System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
   conn.Open();
   string sqlstr = "select NewsKindID, NewsKindName,ParentID from NewsKind where ParentID="+classId+" order by NewsKindID asc";
   SqlCommand cmd = new SqlCommand(sqlstr,conn);
   SqlDataReader dr = cmd.ExecuteReader();
   while(dr.Read())
   {
    ddlParentNewsKind.Items.Add(new ListItem((tempStr+"┣")+dr["NewsKindName"].ToString(),dr["NewsKindID"].ToString()));
    if(dr["NewsKindID"].ToString()!=dr["ParentID"].ToString())
    {
     tempStr =tempStr +"┃";
     smallClass(long.Parse(dr["NewsKindID"].ToString()),tempStr);
    }
   }
  }