using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.OleDb;
using System.Data;
namespace WebApplication2
{
public partial class WebForm1 : System.Web.UI.Page
{
static readonly string connstr = "Provider=MSDAORA;Data Source=mydata;Password=123123;User ID=myname";
protected void Page_Load(object sender, EventArgs e)
{
Button1_Click(sender, e);
}
protected DataTable CreateTable()
{
OleDbConnection conn = new OleDbConnection(connstr);
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
OleDbCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from test";
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
conn.Close();
return dt;
}
protected void Button1_Click(object sender, EventArgs e)
{
TreeView2.ShowLines = true; //顯示連接線
TreeView2.Target = "_blank";//在新窗口中打開鏈接
DataTable dt = CreateTable();//聲明一個DataTable
TreeNode tn_root1 = new TreeNode();//手動創建根節點1
TreeNode tn_root2 = new TreeNode();//手動創建根節點2
tn_root1.Text = "搜索引擎";
tn_root2.Text = "網頁信息";
TreeView2.Nodes.Add(tn_root1); //添加節點到控件里
TreeView2.Nodes.Add(tn_root2); //添加節點到控件里
DataView dv = new DataView(dt);//聲明數據視圖
foreach (DataRowView dr in dv)//遍歷數據視圖
{
if (dr["NODEID"].ToString() == "1")
{
TreeNode tn = new TreeNode();
tn.Text = dr.Row["text"].ToString();
tn.NavigateUrl = dr.Row["url"].ToString();
tn_root1.ChildNodes.Add(tn);
}
else if (dr["NODEID"].ToString() == "2")
{
TreeNode tn = new TreeNode();
tn.Text = dr.Row["text"].ToString();
tn.NavigateUrl = dr.Row["url"].ToString();
tn_root2.ChildNodes.Add(tn);
}
}
}
}
}
SQL數據:
顯示效果: