Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Various categories levels

Author  Topic 

shapper
Constraint Violating Yak Guru

450 Posts

Posted - 2007-04-26 : 11:47:41
Hello,

I would like to display on an Asp.Net 2.0 web site a Folder Tree where each node is a category. I might have only main categories or sub levels (1,2,3, ...).

I want the categories to be on an SQL2005 database because I will then associate each articles to the categories.

If I would have main categories and only 1 level down I would use to tables related to each other ... i think.

But what to do when the categories levels are unknown?

Is this usually done?

Thanks,
Miguel

Vinnie881
Master Smack Fu Yak Hacker

1231 Posts

Posted - 2007-04-26 : 12:52:24
The article I used was this. It's more complicated then most, but it allows the most flexibility.

http://www.sqlmanager.net/en/articles/mysql/725
Go to Top of Page
   

- Advertisement -