asp.net TreeView綁定數據庫

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數據：

顯示效果：