asp.net中的动态菜单 [英] Dynamic menu in asp .net
问题描述
您好我从menucool网站开发了静态菜单但在我的网站上我必须开发动态菜单所以请帮助我
我的桌子
$ / $
MainCategory_Master:
MainCategory_ID int未选中
MainCategory_Name nvarchar(50)已检查
和
SubCategory_Master:
SubCategory_ID int未选中
SubCategory_Name nvarchar(50)已选中
MainCategory_ID int未选中
和代码静态菜单
Hello i developed static menu from menucool website but in my website i have to develop dynamic menu so please help me
My table
MainCategory_Master:
MainCategory_ID int Unchecked
MainCategory_Name nvarchar(50) Checked
and
SubCategory_Master:
SubCategory_ID int Unchecked
SubCategory_Name nvarchar(50) Checked
MainCategory_ID int Unchecked
and code for static menu
<!DOCTYPE html>
<html>
<head>
<title>Menucool Drop Down Menu</title>
<link href="Styles/ddmenu.css" rel="stylesheet" type="text/css" />
<script src="Scripts/ddmenu.js" type="text/javascript"></script>
</head>
<body>
<nav id="ddmenu">
<ul>
<li><a href="Home.aspx">Home</a>
</li>
<li><a href="#">MEN</a>
<div>
<div class="column">
<b>MEN'S CLOTHING</b>
<a href="DisplayAll.aspx?type=T Shirts">T-SHIRTS</a>
<a href="DisplayAll.aspx?type=Casual Shirts"> CASUAL SHIRTS</a>
<a href="DisplayAll.aspx?type=Formal Shirts"> FORMAL SHIRTS</a>
<a href="DisplayAll.aspx?type=Sweaters and Sweatshirts">SWEATERS and SWEATSHIRTS</a>
<a href="DisplayAll.aspx?type=Jackets and Blazers">JACKETS and BLAZER</a>
<a href="DisplayAll.aspx?type=Kurtas">KURTAS</a>
<a href="DisplayAll.aspx?type=Jeans">JEANS</a>
<a href="DisplayAll.aspx?type=Shorts">Shorts</a>
<a href="DisplayAll.aspx?type=Trousers">TROUSERS</a>
</div>
<div class="column" style="width:200px;text-align:center;">
<img src="Images/img1.jpg" alt="Image" style="width:200px; height:175px;" />
</div>
</div>
</li>
<li><a href="#">WOMEN</a>
<div>
<div class="column">
<b>WOMEN'S CLOTHING</b>
<a href="DisplayAll.aspx?type=Sarees">SAREES</a>
<a href="DisplayAll.aspx?type=Dresses">DRESSES</a>
<a href="DisplayAll.aspx?type=Shrugs and Jackets">Shrugs and JACKETS</a>
<a href="DisplayAll.aspx?type=Sweaters and Sweatshirts">SWEATERS and SWEATSHIRTS</a>
<a href="DisplayAll.aspx?type=Jeans and Jeggings">Jeans and Jeggings</a>
<a href="DisplayAll.aspx?type=Shorts and Skirts">SHORTS and SKIRTS</a>
<a href="DisplayAll.aspx?type=Leggings and Capris">LEGGINGS and CAPRIS</a>
<a href="DisplayAll.aspx?type=Trousers">TROUSERS</a>
<a href="DisplayAll.aspx?type=Polos and T-Shirts">POLOS and T-SHIRTS</a>
</div>
<div class="column" style="width:200px;text-align:center;">
<img src="Images/img2.jpg" alt="Image" style="width:200px; height:175px;" />
</div>
</div>
</li>
<li><a href="#">KIDS</a>
<div>
<div class="column">
<b>FOR BOYS</b>
<a href="DisplayAll.aspx?type=Boys Top Wear">TOP WEAR</a>
<a href="DisplayAll.aspx?type=Boys Ethnic Wear">ETHNIC WEAR</a>
<a href="DisplayAll.aspx?type=Boys Winter Wear">WINTER WEAR</a>
<a href="DisplayAll.aspx?type=Boys Bottom Wear">BOTTOM WEAR</a>
<a href="DisplayAll.aspx?type=Boys Night Wear">NIGHT WEAR</a>
<a href="DisplayAll.aspx?type=Boys Sets">SETS</a>
</div>
<div class="column">
<b>FOR GIRS</b>
<a href="DisplayAll.aspx?type=Girls Top Wear">TOP WEAR</a>
<a href="DisplayAll.aspx?type=Girls Ethnic Wear">ETHNIC WEAR</a>
<a href="DisplayAll.aspx?type=Girls Winter Wear">WINTER WEAR</a>
<a href="DisplayAll.aspx?type=Girls Bottom Wear">BOTTOM WEAR</a>
<a href="DisplayAll.aspx?type=Girls Night Wear">NIGHT WEAR</a>
<a href="DisplayAll.aspx?type=Girls Sets">SETS</a>
</div>
<div class="column" style="width:200px;text-align:center;">
<img src="Images/img.jpg" alt="Image" style="width:200px; height:175px;" />
</div>
</div>
</li>
<li><a href="#">NEW ARRIVALS</a>
<div>
<div class="column">
<a href="#"><b>MEN</b></a>
</div>
<div class="column">
<a href="#"><b>WOMEN</b></a>
</div>
<div class="column" style="width:200px;text-align:center;">
<img src="Images/img3.jpg" alt="Image" style="width:200px; height:175px;" />
</div>
<div class="column" style="width:200px;text-align:center;">
<img src="Images/img4.jpg" alt="Image" style="width:200px; height:175px;" />
</div>
</div>
</li>
</body>
</html>
now how i develop dynamic menu please help by code
now how i develop dynamic menu please help by code
推荐答案
Table : MainCategory_Master
MainCategory_ID int Unchecked
MainCategory_Name nvarchar(50) Checked
Table : SubCategory_Master
SubCategory_ID int Unchecked
SubCategory_Name nvarchar(50) Checked
MainCategory_ID int Unchecked
In CS file and Page_Load event write following code
In CS file and Page_Load event write following code
con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Online Shopping Portal.mdf;Integrated Security=True;User Instance=True");
con.Open();
string select="SELECT MainCategory_Master.MainCategory_Name,SubCategory_Master.SubCategory_Name,MainCategory_Master.MainCategory_ID FROM MainCategory_Master INNER JOIN SubCategory_Master ON MainCategory_Master.MainCategory_ID = SubCategory_Master.MainCategory_ID";
cmd = new SqlCommand(select, con);
dr = cmd.ExecuteReader();
String mcat = "";
String menu = "<nav id='ddmenu'><ul id='mainUL'>";
while (dr.Read())
{
if (mcat == "")
{
menu += "<li><a href='#'>" + dr[0].ToString() + "</a><div><div class='column'><b>" + dr[0].ToString() + "'s clothing</b>";
mcat = dr[0].ToString();
}
else if (mcat != dr[0].ToString() && menu != "<ul id='mainUL'>")
{
menu += "</div></div></li><li><A href='#'>" + dr[0].ToString() + "</a><div><div class='column'><b>"+dr[0].ToString()+"'s clothing</b>";
mcat = dr[0].ToString();
}
menu += "<A href='DisplayAll.aspx?SubCategory_Name="+dr[1].ToString()+"'>" + dr[1].ToString() + "</a>";
}
menu += "</ul>";
Response.Write("<div class='ddmenu'>'" + menu + "'</div>");
and DisplayAll.aspx file
and DisplayAll.aspx file
<%--DataList For Display Items--%>
<div id="displayproduct" class="c2">
<asp:DataList
ID="dlMenu"
runat="server"
DataSourceID="srcMenu"
RepeatColumns="4" >
<ItemTemplate>
<asp:HyperLink ID="hlDisplay" NavigateUrl='<%#Eval("Product_ID","~/DisplayOne.aspx?Product_ID={0}") %>' runat="server">
<asp:Image
ID="ImgDisplay"
runat="server"
ImageUrl='<%#Eval("Product_ID","~/Display.aspx?Product_ID={0}") %>'
onmouseover="MOver();"
Width="175" /></asp:HyperLink>
<br />
<asp:Label
ID="lblName"
runat="server"
Text='<%#Eval("Item_Name") %>' Font-Size="Smaller" Font-Bold="True" ></asp:Label>
<br />
<asp:Label
ID="lblPriceDis"
runat="server"
Text="Rs."></asp:Label>
<asp:Label
ID="lblPrice"
runat="server"
Text='<%#Eval("Price") %>'></asp:Label>
<br />
<asp:Label
ID="lblAvailableSize"
runat="server"
style="visibility:hidden"
Text='<%#Eval("AvailableSize")%>'></asp:Label>
<br />
</ItemTemplate>
</asp:DataList>
</div>
<asp:SqlDataSource ID="srcMenu" runat="server"
ConnectionString="<%
ConnectionStrings:ConnectionString%>\"
SelectCommand=\"SELECT Product_Master.Product_ID,Item_Master.AvailableSize, Product_Master.Image, Item_Master.Item_Name, Product_Master.Price FROM Product_Master INNER JOIN Item_Master ON Product_Master.Item_ID = Item_Master.Item_ID WHERE (Item_Master.SubCategory_Name =@efg)\">
<SelectParameters>
<asp:QueryStringParameter Name=\"efg\" QueryStringField=\"SubCategory_Name\" />
</SelectParameters>
</asp:SqlDataSource>
ConnectionStrings:ConnectionString %>" SelectCommand="SELECT Product_Master.Product_ID,Item_Master.AvailableSize, Product_Master.Image, Item_Master.Item_Name, Product_Master.Price FROM Product_Master INNER JOIN Item_Master ON Product_Master.Item_ID = Item_Master.Item_ID WHERE (Item_Master.SubCategory_Name =@efg)"> <SelectParameters> <asp:QueryStringParameter Name="efg" QueryStringField="SubCategory_Name" /> </SelectParameters> </asp:SqlDataSource>
这篇关于asp.net中的动态菜单的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!