Winform中的Treeview动态绑定数据库

http://bbs.csdn.net/topics/370139193

CREATE TABLE [dbo].[Company] (
    [Id] [int] IDENTITY (1, 1)  Primary Key NOT NULL ,
    [Levers] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
    [LevelId] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
    [Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
)

public partial class Form1 : Form
    {
        public string rootId = "-1";
 
        public Form1()
        {
            InitializeComponent();
            AddRootCompany(rootId);
            AddSubCompany();
        }
 
        /// <summary>
        /// 添加总公司
        /// </summary>
        /// <param name="rootId"></param>
        private void AddRootCompany(string rootId)
        {
            DataSet ds = new DataSet();
            using (SqlConnection con = new SqlConnection("Data Source=localhost;uid=sa;pwd=saiyang;Database=CSDN"))
            {
                con.Open();
                string strSQL = "select * from Company where Levers='" + rootId + "'";
                using (SqlDataAdapter adapter = new SqlDataAdapter(strSQL, con))
                {
                    adapter.Fill(ds);
                }
                TreeNode NewNode = new TreeNode();
                NewNode.Text = ds.Tables[0].Rows[0]["Name"].ToString().Trim();
                this.treeView1.Nodes.Add(NewNode);
            }
        }
 
        /// <summary>
        /// 添加子公司
        /// </summary>
        private void AddSubCompany()
        {
            DataSet ds = getMenuByLevel(rootId.ToString());
            for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
            {
                InitTreeCompanyChildNode(treeView1.Nodes[j], ds.Tables[0].Rows[j]["LevelId"].ToString());
            }
 
        }
 
        /// <summary>
        /// 获取层次级别
        /// </summary>
        /// <param name="getparams"></param>
        /// <returns></returns>
        public DataSet getMenuByLevel(string param)
        {
            DataSet ds = new DataSet();
            using (SqlConnection con = new SqlConnection("Data Source=localhost;Initial Catalog=CSDN;User ID=sa;Password=saiyang"))
            {
                con.Open();
                string strSQL = "select * from Company where Levers='" + param + "'";
                using (SqlDataAdapter adapter = new SqlDataAdapter(strSQL, con))
                {
                    adapter.Fill(ds);
                }
            }
            return ds;
        }
 
        /// <summary>
        /// 递归获取子节点
        /// </summary>
        /// <param name="PNode"></param>
        /// <param name="classParentID"></param>
        private void InitTreeCompanyChildNode(TreeNode pNode, string classParentID)
        {
            DataSet ds = getMenuByLevel(classParentID);
            DataView dataView = new DataView();
            dataView = ds.Tables[0].DefaultView;
            foreach (DataRowView drv in dataView)
            {
                string id = drv["LevelId"].ToString();
                string name = drv["Name"].ToString();
                TreeNode NewNode = new TreeNode();
                //将子公司添加到父节点下面
                NewNode.Text = name;
                pNode.Nodes.Add(NewNode);
                InitTreeCompanyChildNode(NewNode, id);
            }
        }
 
    }