How to retrive values from Stored procedures in .net?

[svs_aditya]

Hello anyone,
Can anyone tell me how to retrive the values from "Stored Procedures" using .net.
I know oneway is using " Out parameters".
can anyone suggest the other?????

[techguru]

I would use sqldatareader.. so you can loop throug..
there is no need to define any out parameters in the procedure..

create procedure

in parameters

select * from table


retruns all the records you need as datareader which you can loop through...

[svs_aditya]

hai, thanks for giving one solution.

but my real problem is:
1.if we return any value in stored procedure using "return"(keyword) statement then how catch the return value in C#
2. simillar the above how fetch the returnerror message in C#

[a.karrabi]

if u use sqlcommand for executing stored procedure by wizard, return value stored in sqlcommand.parameter(0).value after sqlcommand.executeScalar().
if you write the code by yourself, you must add a parameter as RETURN type in add parameter list.