Hi everyone, I am looking for a best practice to provide users of my ecommerce website with a breadcrumb trail.

Current Site Setup: 3.5 SQL express 2005 DB

DB Table Setup:

[Category] - ID, parentid, name etc [Product] - ID catID name

Should i use a sqlsitemap provider and everytime i save a product add it to the Sitemap table ?

is there a more dynamic way to achieve the desired result ?

looking for your thoughts / ideas to achieve this.

Thanks in advanced.


There is this artictle which may help with creating the sql provider that you can use with the default breadcrumb in It also has sql caching for a speadier response too.

Daisy Moon