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