Creating A Data Driven Hierarchial Navigation

Hi need to create navigation that gets populated via database and is role based. below is the sql

 

CREATE TABLE [TopMenu] (

[MenuID] [int] IDENTITY (1, 1) NOT NULL ,

[Text] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[ParentID] [int] NULL ,CONSTRAINT [PK_Menu] PRIMARY KEY CLUSTERED

(

[MenuID]

) ON [PRIMARY] ) ON [PRIMARY]

GO

INSERT INTO TopMENU

Select 'Property','Property', NULL

UNION ALL Select 'Portfolio','Portfolio', NULL

UNION ALL Select 'Capital Expenditure','PortfolioCapex', 1

UNION ALL Select 'Depreciation','PortfolioDepreciation', 1

UNION ALL Select 'Condition Audit','PortfolioCondition', 1

UNION ALL Select 'Historical Expenditure','PortfolioHisEx', 1

UNION ALL Select 'Property Details','PropertyDetail', 2

UNION ALL Select 'Assets','PropertyAsset', 2

UNION ALL Select 'Depreciation','PropertyDepreciation', 2

UNION ALL Select 'Capital Expenditure','PropertyExpenditure', 2

UNION ALL Select 'Insurance','PropertyInsurance', 2

UNION ALL Select 'Documents','PropertyDocuments', 2

UNION ALL Select 'Capex','PortfolioCapex', 3

UNION ALL Select 'Graph','PortfolioCapexGraph', 3

UNION ALL Select 'Graph','PortfolioDepreciationGraph', 4

UNION ALL Select 'Current Depreciation','PortfolioDepreciation', 4

UNION ALL Select 'WDV & Depreciation','PortfolioDepreciationWDV', 4

UNION ALL Select 'Assets','PropertyAsset', 8

UNION ALL Select 'Capex','PropertyCapex', 8

UNION ALL Select 'Depreciation','PropertyDepreciation', 8

UNION ALL Select 'Condition','PropertyCondition', 8

UNION ALL Select 'Expenditure','PropertyExpenditure', 8

UNION ALL Select 'Disposed','PropertyDisposed', 8

UNION ALL Select 'Capital Ex','PropertyExpenditure', 10UNION ALL Select 'Capital Ex Graph','PropertyExpenditureGraph', 10

GO

 now clearly, I will have two top level navigation

 

property and portfolio. both  property will have subsequent navigation and those subsequest navigation may or may not have another sets of navigation.

I need to display in a row style not in a drop down style for eg. If I am in portfolio link the navigation structure should be as below

Portfolio

Capital Expenditure | Depreciation | Condition Audit | Historical Expenditure 

Capex | Graph

 by default Capex should be selected. it should also highlight Portfolio, Capital Expenditure and Capex as Capex's parent is Capital Expenditure and Portfolio

 I was thinking of using a 3 level datagrid. could someone please help me I am using asp.net 2.0 web application project with vb.net and sql server 2005

 

thanks in advance