HI There,
i have a table in database and my requirement is to bind all the items present in database to a menu.
i need to bind all those to my menu Please some body help me out
My data should be like
Home Products
SubHome1--->Sub_SubHome1 ..... SubProducts1----->Sub_SubProducts1
SubHome2---->Sub_subHome2..... SubProducts2-----...........................
................Like this i have unlimited N-Nodes have to bind them.
I need a recursive funcitionality.
My Table Looks Like
MenuId MenuName ParentId MenuUrl MenuImage(if any)
1 Home 0 HomwUrl HomeImage
2 Products 0 ProductsUrl ProductsImage
3 Categories 0 CategoriesUrl CtaegoriesImage
4 Accesories 0 AccessoriesUrl AccesoriesImage
5 s_home 1 s_homeUrl s_homeImage
6 s_Products 2 s_ProductsUrl s_ProductImage
7 s_Categories 3 s_categories s_categoriesIMage
8 s_accessories 4 s_accessories s_accessoriesImage
9 s_s_home 5 s_s_HomeUrl s_s_HomeImage
10 s_s_categories 7 s_s_categoriesUrl s_s_CategoriesImage
11 s_s_products 6 s_s_productsUrl s_s_productsImage
NULL NULL NULL NULL NULL
Here My parent id is nothing but the menuid.................Which is present in the First column.
So Please help me out in this issue
Regards,
Janardhan