public void BindLocationDetails(string whereCondition) { string whereClause = ""; if (whereCondition != null && whereCondition != "") { whereClause = whereCondition; } else { whereClause = ""; } try { MenuFrameTV.Nodes.Clear(); DataTable dsDetails = employee.GetLocationView(whereClause); if (dsDetails != null && dsDetails.Rows.Count > 0) { TreeNode tvLoc = new TreeNode("Locations", "Locations"); MenuFrameTV.Nodes.Add(tvLoc); tvLoc.SelectAction = TreeNodeSelectAction.Expand; string[] locName = { "Location", "LocName" }; DataTable dtLocName = dsDetails.DefaultView.ToTable(true, locName); dtLocName.DefaultView.Sort = "Location asc"; DataTable dtUserName = dsDetails.Copy(); DataTable dtDeptName = dsDetails.Copy(); foreach (DataRow dr in dtLocName.Rows) { TreeNode tvLocName = new TreeNode(dr["Location"].ToString(), dr["LocName"].ToString()); tvLoc.ChildNodes.Add(tvLocName); tvLocName.SelectAction = TreeNodeSelectAction.Expand; dtDeptName.DefaultView.RowFilter = "Location='" + dr["Location"].ToString() + "'"; DataTable dtDept = dtDeptName.DefaultView.ToTable(true, "Department"); foreach (DataRow drDept in dtDept.Rows) { TreeNode tvDeptName = new TreeNode(drDept["Department"].ToString(), drDept["Department"].ToString()); tvLocName.ChildNodes.Add(tvDeptName); tvDeptName.SelectAction = TreeNodeSelectAction.Expand; dtUserName.DefaultView.RowFilter = "Location='" + dr["Location"].ToString() + "' and Department='" + drDept["Department"].ToString() + "'"; string[] UserName = { "UserName", "Name" }; DataTable dtUser = dtUserName.DefaultView.ToTable(true, UserName); DataTable dtG = dsDetails.Copy(); foreach (DataRow drow in dtUser.Rows) { TreeNode tvUser = new TreeNode("<table> <tr><td ><img src=\"../EmployeeData/Common/images/folder.gif\" runat=Server />" + "</td><td style=\"cursor:hand;\" onclick=\"javascript:return GetUserName('" + drow["Name"].ToString() + "');\" >" + drow["Name"].ToString() + " - " + drow["UserName"].ToString() + " </td></tr></table>", drow["Name"].ToString()); //TreeNode tvUser = new TreeNode("<div onclick=\"javascript:GetUserName('" + drow["Name"].ToString() + "');\">" + drow["Name"].ToString() + "-" + drow["UserName"].ToString(), drow["UserName"].ToString()); tvDeptName.ChildNodes.Add(tvUser); tvUser.SelectAction = TreeNodeSelectAction.Expand; dtG.DefaultView.RowFilter = "UserName='******'"; DataTable dtGroup = dtG.DefaultView.ToTable(true, "GroupName"); //int UserID = Convert.ToInt32(dtUserName.Rows[0]["ID"].ToString()); //DataTable dtGroup = employee.GetUserGroup(UserID); //if (dtGroup.Rows.Count > 0) //{ foreach (DataRow drow1 in dtGroup.Rows) { TreeNode tvGroup = new TreeNode(drow1["GroupName"].ToString(), drow1["GroupName"].ToString()); // TreeNode tvGroup = new TreeNode(drow1["SecGroupApp"].ToString(), drow1["SecGroupApp"].ToString()); tvUser.ChildNodes.Add(tvGroup); tvGroup.SelectAction = TreeNodeSelectAction.Expand; } } } } } } catch (Exception ex) { } }