treeview problem

Question

I am new to C#.Net window application.
I have table categories where the following values are stored.


1 Software 0 0
2 Hardware 0 0
3 Electronics 0 0
4 Others 0 0
5 Adobe 1 0
6 Pen Drive 2 0
7 Adapter 3 0
8 C# 4 0
9 avast 1 0
10 Microsoft 1 0
11 avg 1 0
12 Cardreader 2 0
13 monitor 2 0
14 mobile 3 0
15 camera 3 0
16 Java 4 0
17 .Net 4 0
18 ad2001 5 0
19 ad2005 5 0
20 amkette 6 0
21 iball 6 0
22 ad#1 7 0
23 ad#2 7 0
24 vs2005 8 0
25 vs2008 8 0
NULL NULL NULL NULL

Now I want the tree view control which can be populated as I show it below:

Software
?Adobe
?ad2001
?ad2008
?avast
?Microsoft
?avg

Hardware
?Pendrive
?amkette
?iball
?Cardreader
?monitor

Electronics
?adaptor
?ad#1
?ad#2
?mobile
?camera

Others
?C#
?vs2005
?vs2008
?Java
?.Net

You can see the relation between Cate and MC
The child node’s MC = Cate of Parent Node. I am finding problem to construct treeview in visual studio 2005 and C#.Net window application.

The Main Problem is :
1) How can we count the parent , child and grandchild node by firing query?
2) How can we add childnode at exact below its correct parent node?
3) How can we display the information in Listview from table for selected node?

Please help me on this topic and get bless from god! My project has to be completed in next 2 days. Please help me! Thanx In advance!