Part 156 Binding asp net menu control to database table

Text version of the video

Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our YouTube channel. Hope you can help.

Slides

All ASP .NET Text Articles

All ASP .NET Slides

ASP.NET Playlist

All Dot Net and SQL Server Tutorials in English

All Dot Net and SQL Server Tutorials in Arabic

1. Create the required database tables using the script below.
Create Table tblMenuItemsLevel1
(
ID int identity primary key,
MenuText nvarchar(50),
NavigateURL nvarchar(50)
)

Create Table tblMenuItemsLevel2
(
ID int identity primary key,
MenuText nvarchar(50),
NavigateURL nvarchar(50),
ParentId int foreign key references tblMenuItemsLevel1(ID)
)

2. Create a stored procedure that returns data from both the tables.
Create Proc spGetMenuData
as
Begin
Select * from tblMenuItemsLevel1
Select * from tblMenuItemsLevel2
End

[nageswararaobanavath]

all your videos are excelent
thanx for uploading

[Vishal]

I have found two problems with this video.
1. You are using a stored procedure to get data from the tables but after that in c# code you did not specify that you are using a stored procedure, then how does your application know that you have used stored procedure instead of sql query.
2. I think 1 table is enough for storing the menuItems as The video of sql server series where we find who is the boss of which employee.

Thanks for this video series. Its a great one.

[drashtigopani]

very well explained
very simple code
thank uu

[HemantKumar-ykjk]

Venkat i request you please start the REST and ODATA tutorials...
awesome video you are making ....

[davidespada]

for your 1st point at 4:08 he add the SP name to dataAdapetr but you mean where is "CommandType.StoredProcedure" right ? i dont know but maybe because there was no parameters..

for 2nd point he used 2 table i think to make it simple,  and yes 1 tables can be used with "recursive associations".

Thank you Mr.venkat for the video and as i say continue plz with the asp.net forms and ado.net videos

[meetnarula]

Venkat i request you please start the WCF

in advance...

[saurabhchauhan]

Sir is there any video regarding N-Level dynamic menu?

[savithag]

hi please help me to freeze the header row of the gridview, I have tried many ways but all failed.Also I want to fix gridview at the same position whatever the count of the rows it have.... in my case if less rows the grid is coming to center, if more rows it is coming to the position.... how to overcome this?

[ranjeetgupta]

sir, how to hide the menu items at the time of user login and also how to shows
these menu items after admin login only... u help me sir plz...

[abhinavramagiri]

hi sir, this video was excellant, but i need a small modification that when i click menu items then submenus need to appear, i tried alot but i failed in that, can u please help me sir.

[gobindkumar]

how we used dynamic multi level menu
parent or child relation is done.bt if child have sub childs or sub childs have childs...then menu have no property to used this???
plz replay....