hi

at learn i see lesone the Building a Custom Database-Driven Site Map Provider ( http://www.asp.net/learn/data-access/tutorial-62-vb.aspx ) and i wanna change the codes an use it in my owne website.

at Step 6: Creating the Custom Site Map Provider i dont find from where read the ProductsBLL() and Northwind.ProductsDataTable

' Get the categories and products information from the database

Dim productsAPI As New ProductsBLL()

Dim products As Northwind.ProductsDataTable = productsAPI.GetProducts()

please let me know

thanks

Hi,

DrZ3D:

at Step 6: Creating the Custom Site Map Provider i dont find from where read the ProductsBLL() and Northwind.ProductsDataTable

I would suggest that you should read where you left off.

see these code lines:

 Dim productsAPI As New ProductsBLL()
            Dim products As Northwind.ProductsDataTable = productsAPI.GetProducts()

            ' Create the root SiteMapNode
            root = New SiteMapNode(Me, "root", "~/SiteMapProvider/Default.aspx", "All Categories")
            AddNode(root)

            ' Create SiteMapNodes for the categories and products
            For Each product As Northwind.ProductsRow In products

ProductsBLL() is a class that is in the App_Code folder, productsAPI.GetProducts() is a method of the ProductsBLL(), which returns the data of the product table.

Northwind is a dataset of the application, which is in the DAL folder of the root directory.

The line of the  For Each product As Northwind.ProductsRow In products is used to read the  read the ProductsBLL() and Northwind.ProductsDataTable.

Hope it helps.

hi Amanda Wang - MSFT  thanks for your replay

This Question was for 4 Days ago and after 4 days hard learning i creat my owne sitemap provider with my owne DataBase

now i have an othere question:

in my database are 3 tables like LearnParents, LearnChildren and Learn with the help of these codes i creat a sitemap for LearnParents and LearnChildren now i wanna bring also learns after the LearnChildren i didnt try it but i will do it today. if is somthing that i should know please let me know.

thanks

Hi DrZ3D ,

If the above reply help you, please mark it as answer.

If you have aother new question, I would suggest you should create a new thread , which make your question come up out of the forum, so the community members can reply yours priority.