return value from stored proc using MS Data Access Application Block

H

hansiman

How do I read a stored proc return value ( return(@return_value) )
using MS Data Access Application Block.

Normally I use:

Dim conn As SqlConnection = New
SqlConnection("connectionstring")
Dim cmd As SqlCommand = New SqlCommand
cmd.Connection = conn
cmd.CommandText = "NameOfStoredProc"
cmd.CommandType = CommandType.StoredProcedure

cmd.Parameters.Add("@Param1", SqlDbType.Int)
cmd.Parameters("@Param1").Value = [value]

Dim retParam As SqlParameter =
cmd.Parameters.Add("@return_value", SqlDbType.Int)
retParam.Direction = ParameterDirection.ReturnValue

conn.Open()
cmd.ExecuteNonQuery()
conn.Close()

[local var] = retParam.Value

I figure I must use SqlHelper.ExecuteScalar... but can't find out how!

Please help

Morten
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,755
Messages
2,569,537
Members
45,020
Latest member
GenesisGai

Latest Threads

Top