private void TreeViewDepartment_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e) { string selectedDepartmentName = e.Node.Text; using (C1811LEntities db = new C1811LEntities()) { int departmentId = db.tblDepartments .Where(department => department.DeptName.Equals(selectedDepartmentName)) .FirstOrDefault().DeptID; List <tblEmployee> foundEmployees = db.tblEmployees .Where(employee => employee.DeptId == departmentId) .ToList(); this.gridViewEmployee.DataSource = foundEmployees; } }
public EmployeeList() { InitializeComponent(); using (C1811LEntities db = new C1811LEntities()) { List <tblDepartment> foundDepartments = db.tblDepartments.ToList(); Console.WriteLine("haha"); foundDepartments.ForEach(department => { this.treeViewDepartment.Nodes.Add(department.DeptName); }); this.treeViewDepartment.NodeMouseClick += TreeViewDepartment_NodeMouseClick; treeViewDepartment.SelectedNode = this.treeViewDepartment.Nodes[0]; this.TreeViewDepartment_NodeMouseClick(treeViewDepartment, new TreeNodeMouseClickEventArgs(treeViewDepartment.SelectedNode, new MouseButtons(), 0, 0, 0)); } }