TreeView Control Question

[StuRReaL]

Does anyone know how to hierarchial data from a flat db table to a tree view. The problem I'm having is that some of the children are also parents and trying to recursively add these is proving had I have so far got my code to output the root elements, but I'm unsure how to proceed from there. Heres my code

  private void getCategories(int parent, int level)
  {
  	string query = "SELECT categoryid, name, parent FROM categories WHERE parent = '"+parent+"'";
  	listBox1.Items.Add(query);

  	NpgsqlCommand command = new NpgsqlCommand(query, this.db);

  	NpgsqlDataReader catReader = command.ExecuteReader();

  	while (catReader.Read())
  	{
    int parentid = Convert.ToInt32(catReader["parent"]);
    int categoryid = Convert.ToInt32(catReader["categoryid"]);

    if (parentid == 0)
    {
    	TreeNode rootNode = new TreeNode(Convert.ToString(catReader["name"]));
    	this.treeView1.Nodes.Add(rootNode);
    	this.getCategories(categoryid, level + 1);    	
    }
    else
    {
    	this.getCategories(categoryid, level + 1);
    }
  	}
  }

I'm using a Postgre database incase anyones wondering about the db connection stuff.

[Andareed]

Create the "super" root outside of getCategories. Modify getCategories to take the parent node and parent id. Don't check for parent == 0, and just call Nodes.Add on the passed in parent node, for each fetched child of parent.

[StuRReaL]

Ok i'll give that a shot, its gonna be a caffeine fueled night i think :(