Retrieve Data From A Stored Procedure

Hello Group


I am new to stored procedures and I have been fighting this for a while and I hope someone can help. In my sp it checks username and password and returns an integer value. I would like to retrieve some data from the same database about the user (the users first and last name and the password of the user). I can’t retrieve the data. Here is my code.


CREATE PROCEDURE stpMyAuthentication


(


@fldUsername varchar( 50 ),


@fldPassword Char( 25 )--,


--@fldFirstName char( 30 ) OUTPUT,


--@fldLastName char( 30 ) OUTPUT


)


As


DECLARE @actualPassword Char( 25 )


SELECT


@actualPassword = fldPassword


FROM


tbMembUsers


Where


fldUsername = @fldUsername


IF @actualPassword IS NOT NULL


IF @fldPassword = @actualPassword


RETURN 1


ELSE


RETURN -2


ELSE


RETURN -1





SELECT


fldFirstName,


fldLastName,


fldPassword


FROM


tbMembUsers


Where


fldUsername = @fldUsername


GO


############### login page ################


Sub Login_Click(ByVal s As Object, ByVal e As EventArgs)


If IsValid Then


If MyAuthentication(Trim(txtuserID.Text), Trim(txtpaswrd.Text)) > 0 Then


FormsAuthentication.RedirectFromLoginPage(Trim(txtuserID.Text), False)


End If


End If


End Sub





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


Dim myConn As SqlConnection


Dim myCmd As SqlCommand


Dim myReturn As SqlParameter


Dim intResult As Integer


Dim sqlConn As String


Dim strFirstName, strLastName As String





sqlConn = ConfigurationSettings.AppSettings("sqlConnStr")


myConn = New SqlConnection(sqlConn)





myCmd = New SqlCommand("stpMyAuthentication", myConn)


myCmd.CommandType = CommandType.StoredProcedure





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


myReturn.Direction = ParameterDirection.ReturnValue





myCmd.Parameters.Add(Trim("@fldUsername"), Trim(strUsername))


myCmd.Parameters.Add(Trim("@fldPassword"), Trim(strPassword))


myCmd.Parameters.Add("@fldFirstName", strFirstName)


myCmd.Parameters.Add("@fldLastName", strLastName)


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





myConn.Open()


myCmd.ExecuteNonQuery()


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





myConn.Close()





'If strPassword = 55555555 Then


' Session("intDefaultPass") = 1


'End If





Session("strFullName") = strFirstName & " " & strLastName


Session("strPassword") = strPassword





If intResult < 0 Then


If intResult = -1 Then


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


Else


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


End If


End If





Return intResult


End FunctionAt this time I am not getting any errors. How can I retrieve the data that I am after?


Michael