hi guys, currently i can return parent + child data from database and display them to my web page.
I wonder how can i return parent + child + sub child data.
please advise. TQ
My Table Structure:
menuID menuName ParentID Type
1 ParentItem1 0 parent
2 ParentItem2 0 parent
3 ParentItem3 0 parent
4 ChildItem1 1 child
5 ChildItem2 1 child
6 ChildItem3 1 child
7 SubChild1 4 subchild
8 SubChild2 4 subchild
My Function
Public Function return_category() As DataSet
Dim strParentCat As String
Dim strChildCat As String
strParentCat = "SELECT menuID, menuName FROM category_table WHERE type = 'parent'"
strChildCat = "SELECT menuID, Pa ...
Go to the complete details ...