C# 中的treeview绑定数据库(递归算法）

近日面试的给我两道题目，一道是IQ测试，第二个就是题目所言

总共两个表 department(id int not null primary key,parentid int,name char(50));

employee(id int not null foreign key(id) references department(id) ,departmentid,name char(50));

实现的代码记录如下

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data.SqlClient;

public partial class Default01 : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {

        fill_Tree();

    }

    void fill_Tree()

    {

        SqlConnection SqlCon = new SqlConnection("server=(local);uid=sa;pwd=sa;database=test");

        SqlCon.Open();

        SqlCommand SqlCmd = new SqlCommand("Select id,name from department", SqlCon);

        SqlDataReader Sdr = SqlCmd.ExecuteReader();

        SqlCmd.Dispose();

        string[,] ParentNode = new string[, ];

        int count = ;

        while (Sdr.Read())

        {

            ParentNode[count, ] = Sdr.GetValue(Sdr.GetOrdinal("id")).ToString();

            ParentNode[count++, ] = Sdr.GetValue(Sdr.GetOrdinal("name")).ToString();

        }

        Sdr.Close();

        for (int loop = ; loop < count; loop++)

        {

            TreeNode root = new TreeNode();

            root.Text = ParentNode[loop, ];

            root.Target = "_blank";

            root.NavigateUrl = "Default01.aspx";

            SqlCommand Module_SqlCmd = new SqlCommand("Select name,id from employee where departmentid =" + ParentNode[loop, ], SqlCon);

            SqlDataReader Module_Sdr = Module_SqlCmd.ExecuteReader();

            while (Module_Sdr.Read())

            {

                TreeNode child = new TreeNode();

                child.Text = Module_Sdr.GetValue(Module_Sdr.GetOrdinal("name")).ToString();

                child.Target = "_blank";

                child.NavigateUrl = "Default01.aspx";

                root.ChildNodes.Add(child);

            }

            Module_Sdr.Close();

            TreeView1.Nodes.Add(root);

        }

        TreeView1.CollapseAll();

        SqlCon.Close();

    }

    protected void TreeView1_SelectedNodeChanged(object sender, EventArgs e)

    {

    }

}

巴特西

C# 中的treeview绑定数据库(递归算法）

最新文章

热门文章