How to retrive the procedure return value in vb.net?

Question

Hi I am Thiru. i am try to create the small search engine. i can retirve all the values using the below queries.

-----------------------------

create procedure FindtestThree

@Name varchar(25),

@Location varchar(25),

@EmpId varchar(25)

as

select * from TbInfo where Name like + '%' + @Name + '%'

select * from TbInfo where Location like + '%' + @Location + '%'

select * from hi where ComName like + '%' + @EmpId + '%'

Exec FindtestThree 'aa','a','d'

---------------------------------------

The above Procedure will return the three table values. i need to retrive all the values in vb.net by using Dot Net application.

i can retrive the single table values by using Sqlcommand object. and other two table value should get it for me. how can i achieve this goal? is there any ideas? please give me suggestion for it