Calling SQL 2005 Stored Procedure That Returns A Value

I have a stored procedure on a SQL server, which is workign correctly to check some date/time parameters and then insert a row into a log table.

I am calling it from an ASP page.   Initially I just called it and didn't worry about the return value.  However the Stored procedure now will return a value to determine if it made the change or not and if not why (ie log entry was at incorrect time etc).

 I woudl liek to capture this returned value in my code to display a message to the user but am havign problems finding the right way to get the value.

I am calling the SP as follows:

     Shared Sub createlogentry(ByVal ID, ByVal tme, ByVal val)
        Dim result As String
        Dim cs As String = ConfigurationManager.ConnectionStrings("connecttion1").ToString
        Using con As New System.Data.SqlClient.SqlConnection(cs)
            con.Open()
            Dim cmd As New System.Data.SqlClient.SqlCommand()
            cmd.Connection = con
            cmd.CommandType = Data.CommandType.StoredProcedure
            cmd.CommandText = "CreateLogEntry"
            cmd.Parameters.Add("@ChID", Data.SqlDbType.Int)
            cmd.Parameters("@ChID").Value = ID
            cmd.Parameters.Add("@Value", Data.SqlDbType.Int)
            cmd.Parameters("@Value").Value = val
            result = cmd.ExecuteNonQuery().ToString
        End Using
    End Sub

 

I have tried amending the ExecuteNonQuery line to ExecuteReader()

 Any help appreciated

Regards

Clive