TreeView数据库绑定

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace WB_DB
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
            DataTable dt = new DataTable();
            SqlConnection con = new SqlConnection(@"server=.;uid=sa;pwd=sa;database=WB_DB");
            con.Open();
            SqlDataAdapter dap = new SqlDataAdapter("select *from T_PKID ", con);
            dap.Fill(dt);
            con.Close();
                DataRow[] dr = dt.Select("ID=0");
                for (int j = 0; j < dr.Length; j++)
                {
                    TreeNode tr = new TreeNode();
                    tr.Text = dr[j]["Name"].ToString();
                    tr.Name = dr[j]["PKID"].ToString();
                    AddTreeNode(dt, tr);
                    treeView1.Nodes.Add(tr);
                }
        }
        public void AddTreeNode(DataTable dt, TreeNode tr)
        {
            DataRow[] dr = dt.Select("ID=" + tr.Name);
            for (int i = 0; i < dr.Length; i++)
            {
                TreeNode trn = new TreeNode();
                trn.Name = dr[i]["PKID"].ToString();
                trn.Text = dr[i]["Name"].ToString();
                AddTreeNode(dt, trn);
                tr.Nodes.Add(trn);
            }
        }
    }
}