比如说我做书籍表,然后向表中添加数据,
insert into Book
select 0, 1, '小说' union
select 0, 2, '唐诗' union
select 1, 3, '武侠小说' union
select 2, 4, '豪放派' union
select 3, 5, '天龙八部' union
select 4, 6, '将进酒' union
select 0, 7, '宋词'
这样无限分下去的话,
我想把他做成树的形式,选中后在DataGridView中显示,
怎样获取他的父节点呀,树怎么弄呀,在线急等......

我靠,晕死,没人回......

这个论谈中有好多例子的,你查一下

表结构如下所示：
Num        Name                                 fatherNum       BZ
01       总节点                            0            ......
0101       第一个一级节点                    01            ......
010101       第一个一级节点的第一个支节点            0101            ......
010102       第一个一级节点的第二个支节点            0101            ......
010103       第一个一级节点的第三个支节点            0101            ......
0102       第二个一级节点                    01            ......
010201       第二个一级节点的第一个支节点            0102            ......
0103       第三个一级节点                    01            ......
010301       第三个一级节点的第一个支节点            0103            ......
01030101   第三个一级节点的第一个支节点01    010301            ......

使用递归方法 把数据表加载到treeview后,
怎样根据treeview上的某个节点知道它在数据库表上对应的主键值?
这是递归方法

C/S:
       public void AddTree(string fatherNum, TreeNode pNode)
        {

            DataView dvTree = new DataView(ds.Tables[0]);

            dvTree.RowFilter = "[father Num] = " + fatherNum;
            foreach (DataRowView Row in dvTree)
            {
                TreeNode Node = new TreeNode();
                if (pNode == null)
                {         //添加根节点   
                    Node.Text = Row["Name"].ToString();

                    treeView1.Nodes.Add(Node);
                    AddTree(Row["Num"].ToString(), Node);         //再次递归   
                }
                else
                {       //添加当前节点的子节点   
                    Node.Text = Row["Name"].ToString();
                    pNode.Nodes.Add(Node);

                    AddTree(Row["Num"].ToString(), Node);           //再次递归   
                }
            }
        }

        DataSet ds = new DataSet();
        private void Form2_Load(object sender, EventArgs e)
        {
            SqlConnection conn = new SqlConnection("server=.;database=test;uid=sa;pwd=;");
            SqlDataAdapter da = new SqlDataAdapter("select * from test",conn);
            da.Fill(ds);
            TreeNode pNode=null;
            AddTree("0", pNode);
        }




B/S:

   DataSet ds = new DataSet();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            SqlConnection conn = new SqlConnection("server=.;database=test;uid=sa;pwd=;");
            SqlDataAdapter da = new SqlDataAdapter("select * from test", conn);
            da.Fill(ds);

            TreeNode pNode = null;
            AddTree("0", pNode);
        }

    }
    public void AddTree(string fatherNum, TreeNode pNode)
    {
        DataRow[] dr = ds.Tables[0].Select("fatherNum=" + fatherNum);
        if (dr.Length > 0)
        {
            foreach (DataRow d in dr)
            {
                TreeNode tNode = new TreeNode();
                tNode.Text = d["Name"].ToString();
                if (pNode == null)
                {
                          //添加根节点  
                    TreeView1.Nodes.Add(tNode);
                }
                else
                {
                        //添加当前节点的子节点  
                    pNode.ChildNodes.Add(tNode);
                    tNode.Collapse();
                }
                AddTree(d["Num"].ToString(), tNode);       //递归
            }
        }    }

哦的神...

谢谢...解决问题