Dynamic menu in asp .net

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

, +

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

XML

<!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

Posted 7-May-13 23:56pm

Member 9815058

Add a Solution

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 8-May-13 6:02am

Please try to do something by your own. And if you face any difficulty, then come back here with the code.
The members will be happy to help you then.

Hints
Fetch the data from DataBase table, build your dynamic menu bu StringBuilder Class and then append that to the div which you want to.

Member 9815058 8-May-13 6:05am

Thanks For Hints ... and ya i try

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 8-May-13 6:23am

Most Welcome.... Please let me know after you implement, otherwise I will help you if any problem.

Thanks,
Tadit

Member 9815058 8-May-13 6:26am

I started and if face any problem then tell you..

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 8-May-13 7:13am

Ok... Click reply button when you want to reply to me, don't add by clicking on "Have a question or Comment" as you did now.
I will not be notified.. Got it ?

Member 9815058 8-May-13 7:17am

Ya...i got it...

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 8-May-13 7:18am

Ok... :)

Member 9815058 8-May-13 8:27am

Please Help Me ...

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 8-May-13 8:37am

Tell me the problem and how far you have proceeded ?

Member 9815058 9-May-13 6:36am

Now i create dynamic menu by writing code in cs file
and code is here

//Code for dynamic menu

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 = "<ul id='mainUL'>";
while (dr.Read())
{
if (mcat == "")
{
menu += "<li>" + dr[0].ToString() + "<div><div class='column'>" + dr[0].ToString() + "'s clothing";
mcat = dr[0].ToString();
}
else if (mcat != dr[0].ToString() && menu != "<ul id='mainUL'>")
{
menu += "</div></div></li><li>" + dr[0].ToString() + "<div><div class='column'>"+dr[0].ToString()+"'s clothing";
mcat = dr[0].ToString();
}
menu += "" + dr[1].ToString() + "";

}
menu += "</ul>";
Response.Write("<div class='ddmenu'>'" + menu + "'</div>");
// Response.Write(menu);

con.Close();
but when i click on T-Shirt or any other link it does not work because i above code in this line menu += "" + dr[1].ToString() + ""; not write anything

what i write replace to # because i have many items

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 9-May-13 8:38am

Ok. I will try and let you know.

Member 9815058 9-May-13 8:45am

Sir it's solve and all items are display

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 9-May-13 9:40am

Nice Awesome... Finally You did it yourself... That's really great.

Member 9815058 9-May-13 10:20am

Ya..Thanks

MS Babu 11-May-13 3:59am

Mouseover Tabs Menu

Hello,

Please help to convert 2 level asp menu like http://www.dynamicdrive.com/dynamicindex1/mouseovertabs.htm[^]

Thanks,
MS Babu

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Member 9815058 · Accepted Answer · 2013-05-09T03:13:00

SQL

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

C#

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

XML

<%--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>