TreeView连接数据库详解（ASP.NET）

数据库中建表（SQL Server）

表中填写数据

前台代码

<div>
            <asp:TreeView ID="TreeView1" runat="server"></asp:TreeView>
        </div>

连接数据库

 <connectionStrings>
    <add name ="sqlserverstr" connectionString ="Data Source=HOME;Initial Catalog=YouZhi;User ID=sa;Password=***"></add>
  </connectionStrings>

后台代码

 public partial class WebForm1 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
               DataTable dt= LoadNews();
               LoadShopClass(null, "0", dt);
            }
        }

        //递归调用
        private void LoadShopClass(TreeNode td, string id, DataTable dt)
        {
            DataRow[] rows = dt.Select("fatherId=" + id);
            foreach (DataRow row in rows)
            {
                TreeNode node = new TreeNode();
                node.Text = row["hwName"].ToString();
                node.Value = row["ID"].ToString();
                if (td == null)
                {
                    this.TreeView1.Nodes.Add(node);
                }
                else
                {
                    td.ChildNodes.Add(node);
                }
                LoadShopClass(node, node.Value, dt);
            }

        }
        private DataTable LoadNews()
        {
            string sqlstr = ConfigurationManager.ConnectionStrings["sqlserverstr"].ConnectionString;
            DataTable dt = new DataTable();
            using (SqlConnection conn = new SqlConnection(sqlstr))
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = "select * from T_hwNavigation";
                    SqlDataAdapter adapter = new SqlDataAdapter(cmd);
                    adapter.Fill(dt);
                }
            }
            return dt;
        }
    }

效果图