I am calling a strored procedure from my asp .net application. How do I get the value of the result into the application back ? What are the classes to use for this..can any body show me the code examples pls
:)

You need to specify an output paramter in the sp.. EX:
create mysp
@id int,
@myreturn varchar(10) OUTPUT
as

set @myreturn = 'A Test'


Then in your .NET code:

create a command or adapter object
dim mycommand as new sqlcommand

..set properties.. params..etc
dim myreturn as string
mycommand.executenonquery
myreturn = mycommand.parameters("@myreturn").value

Jim

thanx Jim.
But I am getting an error like this.
Procedure 'mysp' expects parameter '@myreturn', which was not supplied

What I required to do is, I want to pass a parameter to the procedure which is an Itemcode. And from 5 related tables I want to fetch 8 information and display them on a form in 7 textBox controls and in 1 image control. So basically I need 8 output parameters. I cannot use the datareader because I will not be able to bind them to this control. How can I write code to get all these info from the tables and present it on the form.

In that case you do not use return parameters. Simply create a sql select statment. I would use a sqldataadapter and fill a dataset. The textboxes and image controls can then be bound to columns in the dataset table.