How to display value in gridview which undercategories

Question

Example

I have stored values in database undercategories like

parentcategoire=fruits

   

child categories=apple

  and save 

again i camback 

 and select the parentcategories from dropdownlist as fruits

  

and childcategoires=mango.

 if i add parentcategories=animal

child categoires=lion

and save 

and agin i came back and select  animal as parentcategorie

and enter childcategoires=zebra.

then the values in gridview must appear with matching to theri parent categores.

like

parentcategories     childcategories     

fruit                              apple

fruit                         mango

animal                     lion

animal                      zebra

please reply me with the code as soon as possible  in c#.net with storedprocedure