Populating TreeView from DataBase

[DeeJays]

hi

I have table with following structure and data

ID | LevelName | LevelNumber | ParentLevel
100 | AAA | 1 | 0
101 | BBB | 2 | 100
102 | CCC | 2 | 100
103 | DDD | 1 | 0
105 | EEE | 2 | 103
106 | FFF | 3 | 102
107 | GGG | 3 | 102
108 | HHH | 3 | 102


From this table i want to generate a treeview with the following structure

AAA
- BBB
- CCC
--- FFF
--- GGG
--- HHH
DDD
- EEE


For this i am using the following code


while (sqlDataReader.Read())
{
treeNode = new TreeNode(sqlDataReader["LevelName"].ToString(), sqlDataReader["ID"].ToString());

if (tvMain.FindNode(sqlDataReader["ParentLevel"].ToString()) == null)
{
tvMain.Nodes.Add(treeNode);

}
else
{
parentNode = tvMain.FindNode(sqlDataReader["ParentLevel"].ToString());
parentNode.ChildNodes.Add(treeNode);
}
}


But this code dosnt work properly. Could anyone help me on this issue