protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
TreeNode tn = new TreeNode();
tn.Text = "济南科大原创信息技术有限公司";
addNode("1", tn);
this.TreeView1.Nodes.Add(tn);
}
}
private void addNode(string ParentID, TreeNode pNode)
{
DataView dvTree = drv("select * from P_Dept where Pdt_id!=1");
dvTree.RowFilter = " Pdt_fid= '" + ParentID + "' ";
foreach (DataRowView drv1 in dvTree)
{
TreeNode node = new TreeNode();
if (pNode == null)
{
node.Text = drv1["Pdt_name"].ToString();
this.TreeView1.Nodes.Add(node);
node.Expanded = true;
node.NavigateUrl = "user.aspx?nid=" + drv1["Pdt_id"].ToString().Trim();
int n = Convert.ToInt32(drv1["Pdt_id"].ToString());
node.Value = drv1["Pdt_id"].ToString();
this.addNode(drv1["Pdt_id"].ToString(), node);
}
else
{
node.Text = drv1["Pdt_name"].ToString();
pNode.ChildNodes.Add(node);
node.Expanded = true;
node.NavigateUrl = "user.aspx?nid=" + drv1["Pdt_id"].ToString().Trim();
node.Value = drv1["Pdt_id"].ToString();
this.addNode(drv1["Pdt_id"].ToString(), node);
}
}
}
private DataView drv(string query)
{
//string connstr = ConfigurationManager.ConnectionStrings["TreeViewCon"].ConnectionString;
SqlConnection conn = new SqlConnection("server=192.168.50.41;uid=sa;pwd=123;database=OA_kdyc");
conn.Open();
SqlDataAdapter sda = new SqlDataAdapter(query, conn);
DataSet ds = new DataSet();
sda.Fill(ds, "tree");
return ds.Tables["tree"].DefaultView;
}
修改一下可以用在menu控件上,如下图
文章地址:http://www.cnblogs.com/njypcmqj/archive/2007/06/09/777581.html