Display of Data category wise

I need to list all the categories in order like tree view model.
my category table structure
---------------------------------------
catid catname parant_catid
1books0
2Software0
3MS Ref book1
4C#3
5MS products2
6Asp.net3
7Java product2
8Msoffice5
9Java Books1
10JSDK7
i want to like
1.books(0)
9.Java Books(1)
3.MS Ref book(1)
6.Asp.net(3)
4.C#(3)
2.Software(0)
7.Java product(2)
10.JSDK(7)
5.MS products(2)
8.Msoffice(5)
Thanks & Regards,
Gopalan Mani

Please check the below mentioned URL:
http://vyaskn.tripod.com/hierarchies_in_sql_server_databases.htm

Thank you