for (int i = 0; i < intDepth; i++) { query = @"SELECT ID,EMPNAME,MANAGERID FROM EMPLOYEE where ManagerId = " + i.ToString(); myCommand = new OleDbCommand(query, myConnection); OleDbDataReader reader = myCommand.ExecuteReader(); if (i == 0) { while (reader.Read()) { parentNode = new TreeNode(reader["EMPNAME"].ToString()); parentNode.Tag = reader["ID"]; } treeView1.Nodes.Add(parentNode); } else { query = @"SELECT ID,EMPNAME,MANAGERID FROM EMPLOYEE where ID = " + i.ToString(); myCommand = new OleDbCommand(query, myConnection); OleDbDataReader reader1 = myCommand.ExecuteReader(); while (reader1.Read() && i != 1) { parentNode = find(reader1["EMPNAME"].ToString()); } while (reader.Read()) { parentNode.Nodes.Add(reader["EMPNAME"].ToString()); } }
Nodes.Find
Nodes.Add("B", "B");
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)