在 DropDownList 的层次结构中显示类别和子类别

发布于 2024-10-02 12:54:28 字数 486 浏览 2 评论 0原文

我必须在层次结构中的 dropdownlist 中显示类别和子类别，如下所示：

cat1
    --cat11
           ----cat111
           ----cat112
           ----cat113
    --cat12
          ----cat121
          ----cat122
          ----cat123
cat2
     --cat21
           ----cat211
           ----cat212
           ----cat213
     --cat22
          ----cat221
          ----cat222
          ----cat223

我必须从 SqlServer 数据库显示它，其中创建新类别和子类别时，它将反映在下拉列表中还。我非常需要它。请尽快回复。提前致谢。哈里奥姆。

原文

I have to display the Category and SubCategory in the dropdownlist in hierarchy, like as follows:

cat1
    --cat11
           ----cat111
           ----cat112
           ----cat113
    --cat12
          ----cat121
          ----cat122
          ----cat123
cat2
     --cat21
           ----cat211
           ----cat212
           ----cat213
     --cat22
          ----cat221
          ----cat222
          ----cat223

I have to display it from SqlServer database, in which when the new category and subcategory is created it will reflect in the dropdown also.
I need it very much.
Please response soon.
Thanks in advance.
hariom.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

我也只是我 2024-10-09 12:54:28

您可以按照以下步骤操作 -
在单个查询中查询类别和子类别，例如 -

SELECT '-   '+SubCatName AS NameField,SubCatId AS ValueField,CatId FROM SubCat
UNION
SELECT CatName,0,CatId FROM Cat
ORDER BY CatId,SubCatId

禁用 cat 值 -

foreach (ListItem item in drpDistricts.Items)
{
     if (item.Value.ToString() == "0")
     {
       item.Attributes.Add("Style", "color:maroon");
       item.Attributes.Add("Disabled", "true");
     }
}

如果您想阅读完整的文章，请参阅我的博客上的这篇文章
http://suvendugiri。 wordpress.com/2012/08/26/asp-net-dropdownlist-containing-category-sub-category-hierarchy/

You may follow these steps -
Query both the categories and sub-categories in a single query like -

SELECT '-   '+SubCatName AS NameField,SubCatId AS ValueField,CatId FROM SubCat
UNION
SELECT CatName,0,CatId FROM Cat
ORDER BY CatId,SubCatId

Disable cat values -

foreach (ListItem item in drpDistricts.Items)
{
     if (item.Value.ToString() == "0")
     {
       item.Attributes.Add("Style", "color:maroon");
       item.Attributes.Add("Disabled", "true");
     }
}

if you like to read a complete article then see this post on my blog
http://suvendugiri.wordpress.com/2012/08/26/asp-net-dropdownlist-containing-category-sub-category-hierarchy/

回复收藏 0 原文