how to populate treeview two tables using vb.net : Hello i have this two table

[Department Table][1]


[subDepartment table][2]


then i want this result using treeview

**id**     **department**      **category**
1	          MIS	        System
1	          MIS	         Networking
1	          MIS	         Programmer
2	          Audit	          Operations
2	          Audit	          DS
3	          HRD	          PA
3	          HRD	         PayBen
3	          HRD	          PS
3	          HRD	          PLD
4	          Acounting	Sup
4	           Acounting	FMCG
5	           Procurement	NULL

or like this

MIS
  -System
  -Networking
  -Programmer
AUDIT
  -Operations
  -DS
HRD
  -PA
  -PayBen
  -PS
  -PLD
Acounting
  -Sup
  -FMCG


can please guide me thank you. im having trouble finding any solution in the internet. and im newbei in vb.net language.


  [1]: http://i.stack.imgur.com/DwXUN.jpg
  [2]: http://i.stack.imgur.com/QIICZ.jpg
  [3]: http://i.stack.imgur.com/zy89e.jpg