I have to create a breadcrumbs trails for the Categories and their subcategories as u have seen it in many sites...
Maincetegory > Subcategory >subsubcategory > subsubsubcategory >items
This is the depth of the category..
category table i have Categoryid and categoryparentid where categoryid is linked to it... I have to link it with the below table
SELECT [Id], ,[Name], parentcategoryid
Id Name parentcategoryid
1 Books 0
2 Computers 0
3 Desktops 2
4 Notebooks 2
5 Accessories 3
6 Software 2
7 Games 2
8 Electronics 0
9 Camera, photo 8
and I want to have a breadcumps which shows
This should be dynamic! thanks a lot!
any help will be appreciated