title: Treeview from sql table
body: <p>I have sql table like below. I have to show it in tree view</p>
  
  <pre><code>id   parentid     name
  1     NULL       outlook
  2     1      overcast
  3     1       rainy
  4     1       sunny
  5     2        yes
  6     3        wind
  7     4      humidity
  8     6       strong
  9     6        weak
  10    7        high
  11    8         no
  12    9         yes
  13   10          no
  14   15         yes
  15   7        normal
  </code></pre>
  
  <p>I want output as</p>
  
  <p>-outlook</p>
  
  <pre><code> - overcast
  
           - yes
  
  - rainy
       - wind
          - strong
                - no
          - weak
                - yes
  -sunny
     - humidity
  
           -high
                 -no
           -normal
                 -yes
  </code></pre>
  
  <p>There is only one root node 'outlook' here.then comes child nodes and sub-child nodes like that.</p>