We Write

Home » Blog Details

Web Application Development Company - Multi Level Dropdown Menu

Multi Level Dropdown Menu

Multi Level Dropdown Menu

Multi Level Menu with ASP.NET, C#, jQuery and SQL Server

solution that I would like to share with others puzzled with the same as was one of my website development guys was having a tough time creating a multi level dropdown menu from database,
So I gave him this :
1. Database
We will be using 2 tables to achieve the same :
a. Category Table ( tbl_cat ):
Category_ID : Unique ID
Category_Name : Text
b. Table to hold category relations ( tbl_cat_rel )
Rel_ID : Unique ID
Category_ID : foreign key
Parent_ID : Parent Category ID
Sort_ID : In case you want to sort category display.

2. Stored Procedure

This part is bit tricky as we will be calculating number of childs a particular category holds
					

CREATE PROCEDURE sp_getCategory					

AS					

BEGIN					

Select a.Category_ID, a.Parent_ID, c.Category_Name, b.totalSubCats 					

from tbl_cat_rel as a LEFT OUTER JOIN 					

(SELECT Parent_ID, count(*) as totalSubCats 					

FROM tbl_cat_rel GROUP BY Parent_ID) as b 					

ON a.Category_ID = b.Parent_ID					

LEFT OUTER JOIN tbl_cat as c 					

on a.Category_ID = c.Category_ID					

ORDER BY a.Category_ID					

END					



3. jQuery

Although you can use any jQuery menu you find suitable, for this example I am using
DDSmooth menu available at : http://www.dynamicdrive.com/dynamicindex1/ddsmoothmenu.htm


4. Codes
I am assuming that you have selected a suitable menu Literal or similar to print its navigation values. In this example I will be using literal as follows :
					

<div id="smoothmenu1" class="ddsmoothmenu"> 					

<asp:Literal runat="server" ID="lt_navMenu"></asp:Literal>					

<br style="clear: left" />					

</div>					


And here are the CS codes :
					

// I am sure you know how to get data from tables :)					

this.createMenu(DSdataSet.Tables["tbl_categories"], 0); 					

					

private void createMenu(DataTable dt, int pID)					

{					

lt_navMenu.Text = lt_navMenu.Text + "&lt;ul&gt;";					

for (int i = 0; i < dt.Rows.Count; i++) //Loop until rows are still there.					

{					

if (Convert.ToInt32(dt.Rows[i]["ParentID"]) == pID) 					

{					

lt_navMenu.Text = lt_navMenu.Text + "<li><a href=\"/" +					

dt.Rows[i]["Category_Name"].ToString() + ".aspx \">" + 					

dt.Rows[i]["Category_Name"].ToString() + "</a>";					

					

//Till the time item has childs					

if (dt.Rows[i]["totalSubCats"] != DBNull.Value) 					

this.createMenu(dt, Convert.ToInt32(dt.Rows[i]["catID"]));					

lt_navMenu.Text = lt_navMenu.Text + "</li>";					

}					

}					

lt_navMenu.Text = lt_navMenu.Text + "</ul>";					

}					



The above was used in - http://www.svengg.co/


Till Next...
Jaswant.

SIMILAR POSTS

Directory Submission

SEO company in India , Megasoftwares, shares with you how to select for your directory listings. But there's much more toSearch Engine Optimisation than just submissions. Directory listings are done to brings links pointing to your website but its necessary that submissions are made in worthy directories and the right categories, else it can lead to a bad link profile. There are many fake directories these days but still do exist some like yahoo. Dmoz which have... CONTINUE READING

How To Improve Sites Search Engine Position

Search engine optimization is a great asset to a website to make itself approachable by the target audience. A website's search engine ranking depends on a number of factors. Once a site has got listed with the search engine, then our professional web design company can improve your search engine position by means of back links to your website and also by improving the site content etc. The main attempts include that all your meta tags are in place. Our web design... CONTINUE READING

Squidoo Blog

Squidoo Lens or Blog!. What exactly are these? How is Squidoo related or co-related to Blogger. If I talk in simple language, there's more of a similarity than difference in basics of both. Both are the writer's own pages where he can write about anything, just anything. If you wish to earn from the same, you need to give to the audience whatever they are looking for. You can make as many pages as you want in both, write about topics of interest both your's and your... CONTINUE READING

What Is Your Bounce Rate

When measuring a website's effectiveness and popularity, bounce rate is one of those important factors to be considered. To be defined, bounce rate is the percentage of single-page visits or visits in which the person left a site from the entrance first (landing) page. A high bounce rate generally indicates that site start page could not impress your visitor enough to stay and know more about your site/company/services. A not enough good first impression, or irrelevant... CONTINUE READING

Rules Business

1.The customer is out for himself, not for you. 2.Be clever, don't just try to be. 3.If all you do is respond to complaints, that's all you will get to do. 4.Bring out your mind, Stop and Ask. 5.It's fine that Nothing works at times. 6.You can learn from anyone and everyone. 7.Keep your custom website updated or do away with it. 8.Once social, be social, it's a 24/7 act. 9.Don't make your professionals crazy doing A,B and then C.... CONTINUE READING
Contact Us
Dont' be shy, give us a shout.
We're always curious what fun projects and cool new people lurk around the corners of the web.

DROP US A LINE

Copyright © 2003-2018 MegaSoftwares - Web Design, Website Development and Web Marketing Agency in India
Go Top