Trouble Retrieving Value Of Output Parameter

I am using Asp.net 2.0 and I am trying to retrieve the value from an output parameter in a sql server 2005 stored procedure. The following is my code:

 

Public Function GetUserProfile(ByVal UserID As String, ByVal Name As String) As String

Dim Value As StringDim ValueParam As SqlParameter = New SqlParameter("@Value", SqlDbType.VarChar, 50, ParameterDirection.Output)Dim command As New SqlCommand("sp_GetUserProfile", con)

command.CommandType = CommandType.StoredProcedure

command.Parameters.AddWithValue("@UserID", UserID)command.Parameters.AddWithValue("@Name", Name)

'ValueParam.ParameterName = "@Value"

'ValueParam.SqlDbType = SqlDbType.VarChar

'ValueParam.Direction = ParameterDirection.Output

'ValueParam.Size = 50

'command.Parameters.Add(ValueParam)

'ValueParam.Direction = ParameterDirection.Output

command.Parameters.Add(ValueParam)

 

'TryIf con.State <> ConnectionState.Open Then con.Open()

command.ExecuteNonQuery()Value = command.Parameters("@Value").Value.ToString

If con.State <> ConnectionState.Closed Then con.Close()Return Value

'Catch ex As Exception

'If con.State <> ConnectionState.Closed Then con.Close()

'Return ""

'End Try

End Function

 

 ALTER PROCEDURE dbo.sp_GetUserProfile

(@UserID varchar(36),

@Name varchar(25),

@Value varchar(50) OUTPUT

)

AS

--SET NOCOUNT ON

 SELECT @Value = [Value]

FROM UserProfileWHERE [UserID] = @UserID

AND [Name] = @Name

 

The error I am recieving is :   Procedure or function 'sp_GetUserProfile' expects parameter '@Value', which was not supplied. Can someone tell me what I am doing wrong? Thanks!