Return value from store procedure to dotnet

Question

Hi,

I am using stored procedure to check whether the data is exist in the table or not, here i am not able to return value from database to my function in .net.

And also want to how to store multiple value of select query in a variable because i want to perform some calculation in stored procedure.

Please Help! :)