How to get data from multiple tables using stored procedure?

Question

Hi,

Am Prabhakar,

I have one requirement, i, e, i have one database in this 2  tables one is Category and Second one is subCategory,

i want to display category field records and appropriate subcategry field records in listview control,

if i mouse hover on 1st category record item, the appropriate sub category  records to be dispaly..

 so please help to me to complete this requirement.

this is an urgent task so please give me ur valueable guidence and suggestions and Related links as soon as possible..

Thank You..