dynamically populating treeview

[jiaudheen]

Hi…I’m new to .net..so pls help me.

I have a asp.net treview. I need to populate the treview at run time from the sql database. The parent node must be bound from table tblDepartmentDetails. In this table I have deptCode,deptName. I need to populate the parent node with deptName(such as financial,customer support.IT,BuissnessDevelopememt etc…so as many depts).

Next I need to populate the child node of each parent node. The child node should be bound from table tblEmployeeDetails. In this table I have deptCode,EmployeeNumber,EmployeeName. I need to populate the childnodes with EmployeeNames. Each depts have many employes.

And atlast if click on any one of the child node(EmpName) the corresponding employe’s EmployeeNumber,EmployeeName and deptName should be displayed in textboxes(txtEmpNum,txtEmpName,txtDeptName respectivelly).

Pls help me with deatil C# code.

[talhaekram]

Hi…I’m new to .net..so pls help me.

I have a asp.net treview. I need to populate the treview at run time from the sql database. The parent node must be bound from table tblDepartmentDetails. In this table I have deptCode,deptName. I need to populate the parent node with deptName(such as financial,customer support.IT,BuissnessDevelopememt etc…so as many depts).

Next I need to populate the child node of each parent node. The child node should be bound from table tblEmployeeDetails. In this table I have deptCode,EmployeeNumber,EmployeeName. I need to populate the childnodes with EmployeeNames. Each depts have many employes.

And atlast if click on any one of the child node(EmpName) the corresponding employe’s EmployeeNumber,EmployeeName and deptName should be displayed in textboxes(txtEmpNum,txtEmpName,txtDeptName respectivelly).

Pls help me with deatil C# code.

If it is a static database create xml file for your table like this:
<department>
<employee>
</employee>
</department>
then map it to your tree.

Other option is to parse the table to be fit in database.

1> loop foreach record
>if dept not found in tree
>create dept node
>create new treenode( empname, ..,navigation URL( ..?empNo="+no ) );
> create child node and add to above node
> add the above parent node to treeview


and on page_load use Get["empNo"] and treeview1.selectdNode.text to textbox