Help With Error Handling Please Strored Procedures

I've got the folloing stored procedure








ALTER PROCEDURE AddUserData


(@login varchar (8),


@password varchar (8),


@fullName varchar (50),


@RoleID Int,


@statusID Int)


AS





if exists


(SELECT login, @errorReturn


FROM tbEmployee


WHERE login = @login)


return 55555


Else


INSERT INTO tbEmployee (login, password, fullname, RoleID, statusId)


VALUES (@login, @password, @fullName, @RoleID, @statusID)





RETURN @@error








the function that calls this stored procedure is this








Public Shared Function InsertUserData(ByVal login As String, ByVal password As String, ByVal fullName As String, ByVal StatusID As Integer, ByVal RoleID As Integer)





' Create the connection object


Dim connection As New SqlConnection(connectionString)


' Create and initilise the command object


Dim command As New SqlCommand("AddUserData", connection)


command.CommandType = CommandType.StoredProcedure


command.Parameters.Add("@password", SqlDbType.VarChar)


command.Parameters("@password").Value = password


command.Parameters.Add("@login", SqlDbType.VarChar)


command.Parameters("@login").Value = login


command.Parameters.Add("@fullName", SqlDbType.VarChar)


command.Parameters("@fullName").Value = fullName


command.Parameters.Add("@roleID", SqlDbType.Int)


command.Parameters("@roleID").Value = RoleID


command.Parameters.Add("@statusID", SqlDbType.Int)


command.Parameters("@statusID").Value = StatusID


' Open the connection


Try





connection.Open()


command.ExecuteNonQuery()





Finally


connection.Close()


End Try





End Function








now I'm trying to get ahold of the return value from the stored procedure so I can output a message to the user in a label control.





e.g the soted procedure checks to see if a user already exists if it does it returns 55555. how can I get ahold of this 55555 and place it in a variable in the function so I can then send it to another error function to display the approperate lable message ??





thanks all