Web Forms :: Add Menu From Database?
May 7, 2015I want to bind menus for user from the database....
How do i do it with master page after user login.....
I want to bind menus for user from the database....
How do i do it with master page after user login.....
I've got a piece of code that should generate a menu with subitems from a datasource. The menu is displaying without errors but de submenu items are presented as menuitems. Can't figure out whats wrong:
Dim sqlMenuRdr As SqlDataReader = objDbMenu.GetDbMenuItems.ExecuteReader
Dim sqlSubMenuRdr As SqlDataReader = Nothing
Dim i As Integer = 0
[code]...
How to bind Menu and their submenus from database for example like this menu
Home page Departments Contact Us
-Accounting
-IT
-Engineering
How to i connect Asp.net menu Control with Database?
means i update the database menu is automatically updated
I have jQuery menu in my page this is code
<ul class="sf-menu">
<li class="current">
<a href=Furniture.aspx">Furniture</a>
<ul> <li class="current"> <ul>
<li class="current"><a href="Furniture.aspx">kitchen</a></li>
<li><a href="Furniture.aspx">Electric</a></li>
<li><a href=Furniture.aspx">Furniture</a></li>
</ul></li>
Â
I want when user click one of item from menubar it go to Furniture.aspx and when it go to that page in furniture.aspx show my product related to that item i have Product table in my DB
Id Code Name Description H_name
1 1112 Iron This is test Electric
2 1113 Pot This is test Kitchen
3 1114 Chair This is test Furniture
4 1115 Laundry This is test Electric
5 1116 Container This is test Kitchen
6 1117 Sofa This is test Furniture
I want when user click on Kitchen from menubar in furniture.aspx show product that have H_name=Kitchen  or if they click on Electric item from menubarin  furniture.aspx show my product that have H_name=ElectricÂ
How i can do it?
i want show menu as :
PCLaptop
MacIBMAsusAcer
Printer
HPCanon
So , how to create table in database ?
I am trying to populate menu from database in asp.net 3.5 but as i am new to this technology i really don't know what is the exact way. I tried to find out on web but i found nothing useful for me.
I am developing site for bookstore.First i want to populate departments and then in department, their categories as subitem.
I have both the tables in database.
I tried following code but it is giving me an erroe on relation code line
This constraint cannot be enabled as not all values have corresponding parent values.
All departments dont have categories.
code :
DataSet DepartmentData = new DataSet();
DataTable Department = CatalogAccess.GetDepartments();
DataTable Categories = CatalogAccess.GetCategories();
DepartmentData.Tables.Add(Department);
DepartmentData.Tables.Add(Categories);
DepartmentData.Relations.Add("Children", DepartmentData.Tables[0].Columns["DepartmentId"], DepartmentData.Tables[1].Columns["CategoryId"]);
foreach (DataRow item in DepartmentData.Tables["Department"].Rows)
{
MenuItem DepartmentItem = new MenuItem((string)item["Name"]);
DepartmentItem.ChildItems.Add(DepartmentItem);
foreach (DataRow childItem in item.GetChildRows("Children"))
{
MenuItem childrenItem = new MenuItem((string)childItem["Name"]);
DepartmentItem.ChildItems.Add(childrenItem);
}
}
Departments.DataBind();
and how to add navigation url too!
I can use any other logic but i want to know the better way to code this from expert.
I'm new to asp.net and SQL but i'm supposed to do my final project using these.
I'm using visual web developer and Ms.Access. And i want to display the items stored in one of the database columns as sub menu items on the page.
How to apply path separator for database menu in asp.net ....
View 1 RepliesIn classic ASP I would write some logic to get a nice menu on the site, but now with the Menu-control, it's as easy as it gets.. Maybe to easy. I can't quite figure out how I would do this.. I have a multilevel navigation structure (from a database) that I want to put into the Menu-control, but I don't know which approach is the best/easiest way for me..
I'm all into performance, usability and all that.. The only thing I have really decided is that I want to use the Menu-control, I haven't decided what datasource I should use or how to style the individual links my way The data is coming from a database and is not supposed to be changed very often (maybe once or twice every month).. Thought of making an XML-sitemap, but also of making some sort of SQL-hookup.. I'm leaning towards the XML-sitemap because it wouldn't take long to generate the XML every time the navigation changes and that won't happen very often. The next issue is styling, how to do that? I have the neccesary css ready for the individual links, but I'm still unsure of how to get it to the Menu-control.. The css I have looks like below and in its current form is intended just for the anchors
[Code]....
I have menu list like this
and I want to fill it's Items from my SQL database, is that possible ?
i have created menus using menucontrol (populated using database) its showing me menu items properly.now menu items goes out of screen (viewing area of the screen)i want to wrap that menu items means if the menu items goes out of the screen it will automatically shows the remaining menu items to the next line... and i have taken menucontrol in span tag..
View 2 RepliesI am unable to create dynamic menu from database. I have made two tables for this work.First table is Menu which stores menu id and its relevant name.
MId Text
------------
1 File
2 Edit
3 View
..
..
Second table is subMenu which stores submenus which will be linked to the menu table with menu id.
SId Text MID
-------------------
1 New 1
2 Open 1
3 Save 1
4 Cut 2
5 Copy 2
the menu should be created dynamically from the database, each menu should be displayed in single row
when we click on a menu the submenus are displayed in rows that in expand & contrast form
how to design & develope this page
I have to create menu bar with SQL Database and this should be availble in my all the pages.
View 1 RepliesIs there a way to add/delete/update the default classes (for instance AspNet-Menu-WithChildren,AspNet-Menu-NonLink ) of the html generated by the asp.net menu or treeview control? I am using CSSAdapters so the menu control renders in a list format instead of table format.
View 1 RepliesCurrently I have a menu control on my webform in ASP.Net 4.0 :
<div class="PNMenu">
<asp:SiteMapDataSource ID="PNSiteMap" runat="server" ShowStartingNode="false" />
<asp:Menu ID="PNMainMenu" runat="server" DataSourceID="PNSiteMap" RenderingMode="List" Orientation="Horizontal" CssClass="PN-PrimaryNavMenu" >
</asp:Menu>
</div>
I am trying to style the menu control to allow the menu items to float to the right of the container, however I am unable to do so as whenever I am styling the a, ul or li it keeps getting overidded by asp.net and floats everything left.
.PNMenu
{
clear:both;
[code]...
i have a asp menu in master page and it is populated from database.Â
i want if user click a link that menu link's background color should change how to do? Â
What I want is to show menu items Administrator or show user menu items.Show menu items using login...How I can do it with role provider, control menu and siteMap in masterpage?
View 1 RepliesI want to build a menu something like shown in the below url.
I need to load the menu items from the DataBase....
Dynamically i want to change it.... Any possiblities...?
[URL]
or any other way to have an accordionmenu from the database...
i am creating a software., in that i want to form menu in treeview structure.the parent node, child node and sub child node location are stored in database table SQL 2005..using coding i have to display the treeview menu structure to the screen when the page loads and that too without any flickering on page load...i need in javascript or C#
View 2 RepliesSite.Master file contains
<ul id="nav">
<% Html.RenderAction("Menu", "ShoppingCart"); %>
</ul>
[ChildActionOnly]
public ActionResult Menu()
{
// for to geenrate menu ?
return ????
}
How to generate hierarchical menu below in Menu method from database data ? Should I use stringbuilder or is there better way ?
Resulting html shoudl look like:
[Code]....
We have to develop an application which has a Vertical left pane menu control which displays all the web pages (A,B,C say). Now if user is in page A and filled some data and clicks on menu control to go to page B, all the data in page A needs to be saved. Also if all the required field in page A are not filled and user navigated to page B, there will be one ! sign after the menu so that user can understand that there some some more fields need to be filled up.
We are planning to place the menu control in the Mater page. Please give me some direction to do this. My question is:
1. If user change menu (In Master Page), how should we save data?
2. How should we display the ! in the menu control?
I am doing a rework on one of my sites and I am attempting to use the asp:menu control.
I am using images in the static and dynamic menus. Hard coded at this point.
On my local machine it works fine but when I upload to the server, the image on the dynamci menus do not appear.
Instead I just get white space where the images should be.
Here is the code:
[code]
I know that the code depicted below will not work but I am including it to convey the idea of what I wish to accomplish. I want to use a different SiteMap to construct the menu on the displayed page for each of three different classes of service (COS).
I set a session variable named "COS" at the login and want to test its value prior to rendering each page. I want to display a menu based upon the appropriate COS. Here is my first stab at it but I know that I cannot include <asp:...> controls within the "case" statements. Can anyone suggest methods of doing this? I know C# and can use that but I do not know how to select the proper sitemap within the <menu> control. I am also using a CSS in my production version.
[Code]....
I am need to build a menu and each item of the menu has an image as background knowing that i depend on sitemap to build the menu i used
[Code]....
where menuitem is in a css sheet
[Code]....
it display the image but in the wrong place?