treeView 与数据库的操作

 数据库字段 ID（自动增长列），Name（节点名称),F_ID（父节点ID，父节点为0)

private void Form4_Load(object sender, EventArgs e)
        {
            get_fujiedian();
        }

        //根菜单
        public void get_fujiedian()
        {
            DataTable dt = cla.select_table2_2();//调用SQL语句
            DataRow[] rows = dt.Select("F_ID=0");//添加SQL条件
            foreach (DataRow dr in rows)//循环赋值给DataRow
            {
                TreeNode node = new TreeNode();
                node.Tag = dr;
                node.Text = dr["Name"].ToString();
                treeView1.Nodes.Add(node);
                get_zijiedian(node);
            }
        }
        //得子节点
        public void get_zijiedian(TreeNode fnode)
        {
            DataTable dt = cla.select_table2_2();//调用SQL语句
            DataRow dr = (DataRow)fnode.Tag;//获取根节点的ID
            int f_id = (int)dr["id"];
            DataRow[] rows = dt.Select("F_ID=" + f_id);//SQL语句加入条件进行查询
            if (rows.Length == 0)//集合是否有值
            {
                return;
            }
            foreach (DataRow Drows in rows)
            {
                TreeNode node = new TreeNode();
                node.Tag = Drows;
                node.Text = Drows["Name"].ToString();
                //添加子节点              
                fnode.Nodes.Add(node);
                get_zijiedian(node);
            }
        }