如何创建类别& asp.net中的子类别菜单表单数据库 [英] how to create category & subcategory menu form database in asp.net

问题描述

先生，请告诉我如何从数据库绑定的代码



html代码

sir please provide me code when how to bind from database

html code are

<div id='cssmenu'>
<ul>
   <li><a href="Default.aspx"><span>Home</span></a></li>
   <li class='active has-sub'><a href="products.htm"><span>Women</span></a>
      <ul>
        <li class='has-sub'><a href="products.htm"><span>Top</span></a></li>
         <li class='has-sub'><a href="products.htm"><span>Shirt</span></a></li>
         <li class='has-sub'><a href="products.htm"><span>Jeans</span></a></li>
         <li class='has-sub'><a href="products.htm"><span>Suit</span></a></li>

      </ul>
   </li>
   <li><a href="products.htm"><span>Men</span></a>
   <ul>
         <li class='has-sub'><a href="products.htm"><span>T-Shirt</span></a></li>
         <li class='has-sub'><a href="products.htm"><span>Shirt</span></a></li>
         <li class='has-sub'><a href="products.htm"><span>Jeans</span></a></li>
         <li class='has-sub'><a href="products.htm"><span>Formal Shirt</span></a></li>

      </ul>
   </li>
   <li class='last'><a href='#'><span>Sale</span></a></li>
   <li><a href='#'><span>Handicrafts</span></a></li>
      <li><a href="blog.htm"><span>Blog</span></a></li>
       <li><a href="contact.htm"><span>Contact</span></a></li>
   </li>
</ul>
</div>

从以下评论中复制的其他信息

这是类别表

additional information copied from comments below
this is category table

CREATE TABLE [dbo].[tblcategory](
[Id] [int] IDENTITY(1,1) NOT NULL,
[category] [nvarchar](max) NULL,
[cat_image] [nvarchar](max) NULL,
[descri] [nvarchar](max) NULL,
[applydate] [nvarchar](50) NULL,
CONSTRAINT [PK_tblcategory] PRIMARY KEY CLUSTERED 
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

这是子类别表

this is subcategory table

CREATE TABLE [dbo].[tblproduct](
[Id] [int] IDENTITY(1,1) NOT NULL,
[cat_id] [int] NULL,
[product_name] [nvarchar](50) NULL,
[product_image] [nvarchar](max) NULL,
[descri] [nvarchar](max) NULL,
[applydate] [nvarchar](50) NULL,
CONSTRAINT [PK_tblproduct] PRIMARY KEY CLUSTERED 
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

我想创建类似菜单和类别的类别子类别如子菜单动态

i want to create category like menu & subcategory like submenu dynamicly

推荐答案

1。写下你的疑问。

- 加入你的两张桌子。



2.从数据库中获取数据。

1. Write your query.
- JOIN your two table.

2. Get the data from database.

string queryString = "your query is here";
DataSet dataset = new DataSet();
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = new SqlCommand(
queryString, connection);        
adapter.Fill(dataset);

3.渲染你的html用户界面。

您使用asp.net webform还是mvc？我不知道你到底想要什么。

这是msdn样本。您只需要替换模板。



http://msdn.microsoft.com/ko-kr/library/system.web.ui.webcontrols.repeater(v = vs.110）.aspx [ ^ ]



4.下拉菜单。

使用bootstrap或其他库。你可以很容易地做到这一点。

以下是bootstrap示例。



http://getbootstrap.com/components/#dropdowns [ ^ ]

使用数据表绑定数据的最佳方式



并在datalist2中添加datalist1表

绑定datalist1中onitem创建的第二个datalist

the best way to bind the data using datatable

and add datalist1 table within datalist2
bind second datalist at onitemcreated in datalist1

<asp:DataList ID="DataList1" runat="server" OnItemCreated="DataList1_ItemCreated">

<ItemTemplate>
                <%# Eval("main_cate") %>
                                <asp:DataList ID="DataList2" runat="server">

                                        <ItemTemplate>
                                            <div class="sub_cate"style="margin-left: 20px">
                            <%# Eval("sub_cate") %>
                                            </div>

                                        </ItemTemplate>

                                 </asp:DataList>
</ItemTemplate>

</asp:DataList>

onitemcreated方法为datalist2写fatching记录，其中where condition

onitemcreated method write fatching record for datalist2 with where condition

这篇关于如何创建类别& asp.net中的子类别菜单表单数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！