Unspected Result

Hi Ive just started with asp.net and this question is maby stupid but I cant find the error.





Problem: I am trying to make a loginpage with the username and password stored in a database. The page do not generates any error then runnin BUT it is not possible to log in. The sql-procedure always return -1 even if the username do exist.





--------------------------------------------


Function MyAuthentication(strUsername As String, strPassword As String) As Integer





Dim myConn As SQLConnection


Dim myCmd As SQLCommand


Dim myReturn As SQLParameter


Dim intResult As Integer


Dim conn As String





conn = ConfigurationSettings.AppSettings("Generala")


myConn = New SQLConnection(conn)





myCmd = New SQLCommand("MyAuthentication",myConn)


myCmd.CommandType = CommandType.StoredProcedure





myReturn = myCmd.Parameters.Add("RETURN_VALUE",SqlDbType.Int)


myReturn.Direction = ParameterDirection.ReturnValue





myCmd.Parameters.Add("@username",strUsername)


myCmd.Parameters.Add("@password",strPassword)





myConn.Open()


myCmd.ExecuteNonQuery()


intResult = myCmd.Parameters( "RETURN_VALUE" ).Value


myConn.Close()





If intResult < 0 Then


If intResult = -1 Then


lblMessage.Visible = true


lblMessage.Text = "Username Not Registered!<br><br>"


Else


lblMessage.Visible = true


lblMessage.Text = "Invalid Password!<br><br>"


End If


End If





Return intResult


End Function





-----------------------


SQL Procedure


----------------------





CREATE PROCEDURE MyAuthentication (@username As Char( 25 ), @password As Char( 25 )) As





DECLARE @actualPassword Char( 25 )





SELECT @actualPassword=Password FROM [User] WHERE user=@username





IF @actualPassword IS NOT NULL


IF @password = @actualPassword


RETURN 1


ELSE


RETURN -2


ELSE


RETURN -1


GO





-----------------------





Someone that can help me with and find the error?