62,254
社区成员
发帖
与我相关
我的任务
分享
#region 建立初始化测试treeview
if (!IsPostBack)
{
//TreeView1.Attributes.Add("onclick", "postBackByObject()");
TreeView1.Nodes.Clear();
// 用于添加一级节点的foreach语句
DataTable dt = Mydb.ReturnDT("select * from Employees order by 部门名称;");
DataView dv = new DataView(dt);
strLast = "";
foreach (DataRowView drv in dv)
{
//给每个一级节点赋值
tmpNd = new TreeNode();
//strLast
strNew = drv["部门名称"].ToString();
if (strLast == strNew)
{
continue;
}
tmpNd.Value = strNew;
tmpNd.Text = strNew;
tmpNd.NavigateUrl = "javascript:void(0)";
//tmpNd.SelectAction = TreeNodeSelectAction.None;
tmpNd.Expanded = true;
TreeView1.Nodes.Add(tmpNd);
strLast = strNew;
//调用方法填充二级节点
AddchildNodes(tmpNd, dv);
}
}
#endregion
}
#endregion
#region 填充二级节点
private void AddchildNodes(TreeNode tmpNd, DataView dv)
{
strLast2 = tmpNd.Value.ToString();
strNew2 = "";
// 用于添加级二节点的foreach语句
//DataTable dt = Mydb.ReturnDT(
//DataView dv = new DataView(dt);
foreach (DataRowView drv in dv)
{
strNew2 = drv["部门名称"].ToString();
if (strLast2 != strNew2)
{
continue;
}
//给每个二级节点赋值
tmpNd2 = new TreeNode();
tmpNd2.Text = drv["人员名称"].ToString();
tmpNd2.Value = drv["人员名称"].ToString();
tmpNd2.NavigateUrl = "javascript:void(0)";
tmpNd.ChildNodes.Add(tmpNd2);
}
}
#endregion
#region ReturnDT
public DataTable ReturnDT(string SQL)
{
try
{
//SqlConn.Open();
sda = new SqlDataAdapter(SQL, SqlConn);
DataTable Mydt = new DataTable();
sda.Fill(Mydt);
//SqlConn.Close();
return Mydt;
}
catch (Exception ex)
{
throw ex;
}
}
#endregion
protected void TreeView_SelectedNodeChanged(object sender, EventArgs e)
{
//弹出员工姓名
}