How to create treeview from to db using one table in asp.net

Hi frnds How to create treeview parent n child node using db in asp.net. 1. I have a table with column name like Userid. Username. Designation name I want to create treeview using single table here we can use name n designation column.so how to do these things. N use stored procedure