private void PopulateTreeView() { treeDepartments.Nodes.Clear(); String strConn = "Server =server;Database =DB;Integrated Security = True;"; SqlConnection conn = new SqlConnection(strConn); SqlDataAdapter da = new SqlDataAdapter("Select * from tSubDepartments", conn); SqlDataAdapter daCategories = new SqlDataAdapter("Select * from tDepartments", conn); da.Fill(ds, "tSubDepartments"); daCategories.Fill(ds, "tDepartments"); ds.Relations.Add("Dept_SubDept", ds.Tables["tDepartments"].Columns["dpCode"], ds.Tables["tSubDepartments"].Columns["dpCode"]); foreach (DataRow dr in ds.Tables["tDepartments"].Rows) { int id = Convert.ToInt32(dr["dpCode"]); TreeNode tn = new TreeNode(dr["dpName"].ToString()); foreach (DataRow drChild in dr.GetChildRows("Dept_SubDept")) { tn.Nodes.Add(drChild["sdName"].ToString()); } treeDepartments.Nodes.Add(tn); } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)