How to execute procedure having insert and select command

Sep 24 2014 6:59 AM

I am using insert in stored procedure. In same procedure I am select the data from table. I use command object to execute query now I want to get data of select command from that procedure. Please help me