Custom login in 2.0 error

I decided to go against the custom membership provider that 2.0 provides and create my own login page using forms authentication ticket. However, when I run the code I get the following error:

Object must implement IConvertible

I've attempted to sort of convert 1.1 code into 2.0 code. I am decent at coding but by no means an expert at it.   I included my code here to hopefully see if anyone can tell me the error of my ways.

Please note that I don't have any desire to use the membership provider in 2.0 nor do I want to create a membership provider as I can't get that to work. I used to be fine with it in 1.1 just using the formsauthentication ticket. I think I can still do that in 2.0.

Thanks in advance for your help.
This is my button1_click event:
Dim breturn As Boolean
        breturn = verifyuser(loginname.Text, password.Text)
        If breturn = True Then
            Dim ticket As FormsAuthenticationTicket = New FormsAuthenticationTicket(loginname.Text, False, 5000)
            FormsAuthentication.RedirectFromLoginPage(loginname.Text, False)
            feedback.Text = "The Login Name and Password you typed in doesn't match our records"
        End If
This is my "verifiyuser" function:
Protected Function verifyuser(ByVal username As String, ByVal password As String) As Boolean
        Dim sdr As System.Data.SqlClient.SqlDataReader
        Dim con As SqlConnection = New SqlConnection("myconnectionstring)
        Dim breturn As Boolean
        Dim cmd As SqlCommand = New SqlCommand("login", con)
        cmd.CommandType = Data.CommandType.StoredProcedure
        cmd.Parameters.Add("@cologin", NVarChar, 255).Value = loginname
        cmd.Parameters("@cologin").Value = loginname
        sdr = cmd.ExecuteReader
        While sdr.Read
            If sdr("Password") = password Then
                breturn = True
            End If
        End While
        Return breturn
    End Function
This is my stored Procedure:
@cologin as nvarchar (max)
	select * from members where cologin = @cologin

Open in new window

Who is Participating?
harwantgrewalConnect With a Mentor Commented:
Hi smitty68521
Have you gone through this URL ?
smitty68521Author Commented:
This helped a great deal. I was able to get the steps done correctly. Thanks a bunch.
Thanks smitty68521

Just for future alwasy try to search in Google first you will definately find answers there.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.