Stored Procedure returning multiple rows

Question

I have a stored procedure which return a single value and one which return multiple rows between two colums.
In my code for the procedure which returns a single value i use (executescalar) which works fine.
I am not sure what command to use in my code when i am calling the stored procedure that returns multiple rows between colums.
Any help would be appreciated.
Thanks.

Answer 1

Use ExecuteReader... Google it "DataReader" & "Data Set"

Answer 2

Thanks.

Answer 3

Yes. Exceute Scalar returns -1. 0, or 1

 

Adam