Tenho uma store procedure que retorna o valor do ultimo ID, estou executando da seguinte forma:
Dim sqlConn As New SqlConnection(connectionString)
sqlConn.Open()
Dim cmd As New SqlCommand(strNomeProcedure, sqlConn)
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add(New SqlParameter("@Action", SqlDbType.VarChar, 10))
cmd.Parameters("@Action").Value = "SALVAR"
cmd.Parameters.Add(New SqlParameter("@ID", SqlDbType.Int))
cmd.Parameters("@ID").Value = intValorID
cmd.Parameters.Add(New SqlParameter("@IDENTITY", SqlDbType.Int, 3, ParameterDirection.ReturnValue))
cmd.ExecuteNonQuery()
preciso receber o valor do parametro @IDENTITY.
obrigado