- public partial class _Default : System.Web.UI.Page
- {
- public SqlConnection getconn()
- { //链接到数据库
- SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=tree;Integrated Security=True" );
- return conn;
- }
- public DataView drv(string sqlselect)
- {//查找到和sqlselect有关的数据 并返回一个视图;
- SqlDataAdapter sda = new SqlDataAdapter(sqlselect, getconn());
- DataSet ds = new DataSet();
- sda.Fill(ds, "tree");
- return ds.Tables["tree"].DefaultView;
- }
- public void allnode(DataView table)
- {//填充节点
- foreach (DataRowView datav in table)
- {
- TreeNode tn = new TreeNode();// 建立一个节点
- tn.Text = datav["name"].ToString();//给节点的属性赋值
- tn.Value = datav["val"].ToString();
- tn.NavigateUrl = datav["url"].ToString();
- tn.Expanded = false;//折叠节点
- Tree.Nodes.Add(tn);//添加节点
- }
- }
- protected void Page_Load(object sender, EventArgs e)
- {
- }
- protected void Tree_Init(object sender, EventArgs e)
- {
- string sel = "select * from tree where pope=1 ";
- allnode(drv(sel));
- }
- }
在页面拖一个tree控件 ,从数据库中找到和控件关联的页面