只把.cs文件的代码写出来了,页面中定义一个treeView1就可以了~
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (Session["userName"] != null)
{
showlist();
}
else
{
Response.Write("<script>alert('请先登录!');location.href='login.aspx';</script>");
}
}
}
private void showlist(){
//添加根节点
TreeView1.Nodes.Clear();
TreeNode node = new TreeNode();
node.Text = Session["userName"].ToString();
node.Target = "0";
node.Expanded = true;
TreeView1.Nodes.Add(node);
treeShow(0, node);
TreeView1.DataBind();
}
//递归
private void treeShow(int parterid,TreeNode treenode){
DataSet ds=returnDataset(parterid);
if (ds!=null)
{
for(int i=0;i<ds.Tables[0].Rows.Count;i++)
{
TreeNode node=new TreeNode();
if (!ds.Tables[0].Rows[i]["NodeName"].ToString().Equals(treenode.Value))
{
node.Target = ds.Tables[0].Rows[i]["nodeID"].ToString();
node.Text = ds.Tables[0].Rows[i]["NodeName"].ToString();
treenode.ChildNodes.Add(node);
node.Expanded = true;
DataSet ds2 = returnDataset(Int32.Parse(ds.Tables[0].Rows[i]["Nodeid"].ToString()));
if (ds2.Tables[0].Rows.Count > 0)
{
treeShow(Int32.Parse(ds.Tables[0].Rows[i]["Nodeid"].ToString()), node);
}
}
}
}
}
private DataSet returnDataset(int parterid){
SqlConnection conn = new SqlConnection();
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["DB_PhotoManagerConnectionString"].ConnectionString;
String userName = Session["userName"].ToString();
SqlCommand cmd;
DataSet ds=new DataSet();
try
{
conn.Open();
cmd = new SqlCommand("select * from tree where parid=" + parterid +"order by creatTime asc", conn);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(ds);
}
catch(Exception ex)
{
Response.Write(ex.ToString());
Response.End();
}
finally{
conn.Dispose();
}
return ds;
}