using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Configuration;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
bindTree();
}
}
private DataTable getTable()
{
string str = ConfigurationManager.ConnectionStrings["con"].ConnectionString;
using (SqlConnection con=new SqlConnection(str))
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "select * from menutree order by parentid,menuorder";
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
return ds.Tables[0];
}
}
private void bindTree()
{
DataTable dt = this.getTable();
this.FillNode(dt,null);
}
private void FillNode(DataTable dt, TreeNode node)
{
DataView dv = new DataView(dt);
if (node == null)
{
dv.RowFilter = "parentid='0'";
}
else
{
dv.RowFilter = "parentid='" + node.Value + "'";
}
foreach (DataRowView item in dv)
{
TreeNode no = new TreeNode(item["menuname"].ToString(),item["menuid"].ToString());
FillNode(dt,no);
if (node == null)
{
this.TreeView1.Nodes.Add(no);
}
else
{
node.ChildNodes.Add(no);
}
}
}
}
保持初学者的心态!!!