Did anyone figure out how to make the additional SUBCATEGORY option for the ARTICLES? Marco mentioned about it in the book with the tip about additional field "SubCat" in the Category table, but did not go on :-). Actually, I'm interested in the unlimited levels of children in the ARTICLES (example: Room-->Wall-->Shelf-->Book-->Chapter-->Page-->Line-->Letter). Can anyone help with this?

I'm trying to implement that too...

On Category table I just have:
ID
ParentCategoryID
Name
Description
ImageURL

My problem is on admin pages...
I think I will use an tree menu!

on the user-end pages it's simple:
If the url is www.xxxx.com/showArticles.aspx?categID=2:
 On the top of the page I'll put one repeater (or something like this) for return all subcategories that have "ParentCategoryID = 2"

Next i will show a gridview with all articles that has "categoryID = 2"

If you have another idea please tell us!

Hi Maxxim
I am too trying to make this, but I am having some problems on how to write the code.
So if you have complited it can you post the code

Thanks

No i can't... :(
I worked on this code from past two weeks... But the first reason is because I added more stuff than simple n-level category and i had changed all my sql structure (names, etc)
If i put the code here, you might be confused...

But i'm free to help you...

I created n-level category and an upper level "sectionID"... because i'm building a "mega portal"
(you don't need section id (i suppose)
First add one column to your categories table: "ParentID"

Then modify your dal, bll code in order to show categorys and subcategories...
I used a treeview!

You may see this topics if you want:

http://p2p.wrox.com/topic.asp?TOPIC_ID=64640

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=89365

Before you start making some changes don't forget backup!

I have an example of how to use Common Table Expressions in my blog. They are by far the easiest way to deal with hierarchical data.

(It's similar to what is described in the sqlteam example).

http://entropia-online.blogspot.com/

But do this with sql isn't the hard stuff!

The challenge it's to do all the necessary stuff in TBH UI and BLL.

Not really ;)

Just use a CTE within your stored procedure to give you back the resultset you want. The principle would remain the same, you might just have to add a parameter or so...

http://entropia-online.blogspot.com/

I think that too... before I started to make my UI pages... :)

I tried to datasource my treeview with this select, But i got an error because treeview needs to bind with a hierarchical datasource...
I had two choices...
Get my SELECT from DB and create a xml file and then bind the treeview
Or
Catch a list with the select and then bind my treeviewNodes father my father...
I preferred the second choice because I want to add custom links to my treeView!

It wasn't easy... There no custom treeview samples on the web...
I'm on a middle of forums Creation so... when I debug my application I PrintScreen my ArticlesCategories for you see...

I created too an hierarchical ArticlesAuthor section.

Groups...
 Author

I'm creating a dog's portal.
I will have articles from handlers, breeders, doctors, etc...
I want that user can have the option to see all articles byAuthor, byAuthorGroup, byCategory, bySubCategory...

(forgive my bad english...)

Hmm. Interesting point... I have my CTE implemented in my database. If i have some spare time, I will try playing around with something similar at work tomorrow to see if I somehow can get it working somehow.

Cheers,

Peter

http://entropia-online.blogspot.com/

interesting atricle on flixon (september 18th) re creating a little user function in sql to allow recursive (safe) querying of sub-categories:

http://www.flixon.com/

jimi

http://www.originaltalent.com