Tell me more ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.

I want to create the admin panel of website. I need to create dynamic menus and sub menus, and also dynamic pages.

I have these tables:

  • Menu
  • News
  • Articles
  • Gallery
  • ContentPage (for creating content pages same about us etc.)
  • PageLinks(for adding link of other websites)

and other tables.

I don't know how can I manage my DB to create dynamic menus with link menu items to dynamic pages, news and articles.

This is menu table :

CREATE TABLE [dbo].[Menu](
[Id] [tinyint] IDENTITY(1,1) NOT NULL,
[ParentId] [tinyint] NULL,
[Id_AllPages] [int] NULL,
[MenuTitle] [nvarchar](50) NULL,
[Description] [nvarchar](50) NULL,
[Position] [tinyint] NULL,
[IsActive] [bit] NULL,
[CreateDate] [datetime] NULL,
[Language] [char](1) NULL,
 CONSTRAINT [PK_Menu] PRIMARY KEY CLUSTERED 

How can I save link of dynamic page for menu items?

I don't need c# code at this time, I just need helping about DB structure for dynamic menus and pages.

Thanks

share|improve this question

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.