最新推荐文章于 2025-08-22 11:25:37 发布

转载最新推荐文章于 2025-08-22 11:25:37 发布 · 57 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/luxp/p/3245978.html

文章标签：

#数据库

本文介绍了一个ASP.NET中使用DropDownList控件进行数据绑定的例子。通过查询数据库获取分类信息，并将其填充到DropDownList控件中，实现了下拉菜单的动态生成。特别地，文章展示了如何递归获取子类别的过程。

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

  #region 绑定类别=================================
        private void TreeBind(int _channel_id)
        {
            DataTable dt = GetList(0, _channel_id);

            this.ddlCategoryId.Items.Clear();
            this.ddlCategoryId.Items.Add(new ListItem("所有类别", ""));
            foreach (DataRow dr in dt.Rows)
            {
                string Id = dr["id"].ToString();
                int ClassLayer = int.Parse(dr["class_layer"].ToString());
                string Title = dr["title"].ToString().Trim();

                if (ClassLayer == 1)
                {
                    this.ddlCategoryId.Items.Add(new ListItem(Title, Id));
                }
                else
                {
                    Title = "├ " + Title;
                    Title = DESEncrypt.StringOfChar(ClassLayer - 1, "　") + Title;
                    this.ddlCategoryId.Items.Add(new ListItem(Title, Id));
                }
            }
        }
        #endregion

        public DataTable GetList(int parent_id, int channel_id)
        {
            DataSet ds = DB.Query("select * from category where channel_id=" + channel_id);
            DataTable oldData = ds.Tables[0] as DataTable;
            if (oldData == null)
            {
                return null;
            }

            DataTable newData = oldData.Clone();
            GetChilds(oldData, newData, parent_id, channel_id);
            return newData;
        }

        private void GetChilds(DataTable oldData, DataTable newData, int parent_id, int channel_id)
        {
            DataRow[] dr = oldData.Select("parent_id=" + parent_id);
            for (int i = 0; i < dr.Length; i++)
            {
                DataRow row = newData.NewRow();
                row["id"] = int.Parse(dr[i]["id"].ToString());
                row["channel_id"] = int.Parse(dr[i]["channel_id"].ToString());
                row["title"] = dr[i]["title"].ToString();
                row["class_layer"] = int.Parse(dr[i]["class_layer"].ToString());
                row["content"] = dr[i]["content"].ToString();
                row["parent_id"] = int.Parse(dr[i]["parent_id"].ToString());
                
                newData.Rows.Add(row);
                //调用自身迭代
                this.GetChilds(oldData, newData, int.Parse(dr[i]["id"].ToString()), channel_id);
            }
        }

　　Hrml代码：

请选择：<asp:DropDownList 
                ID="ddlCategoryId" runat="server" CssClass="select2" AutoPostBack="True" ></asp:DropDownList><br />

　　数据库设计：参考动易CMS

转载于:https://www.cnblogs.com/luxp/p/3245978.html

.net目录菜单，绑定目录类别。