Solved

Custom login in asp.net 2.0 error

Posted on 2008-10-12
3
230 Views
Last Modified: 2013-11-07
I decided to go against the custom membership provider that asp.net 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 asp.net 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 asp.net 1.1 just using the formsauthentication ticket. I think I can still do that in asp.net 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)

        Else

            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

        con.Open()

        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)

	

	

AS

	select * from members where cologin = @cologin

	RETURN

Open in new window

0
Comment
Question by:smitty68521
  • 2
3 Comments
 
LVL 5

Accepted Solution

by:
harwantgrewal earned 500 total points
ID: 22699921
Hi smitty68521
Have you gone through this URL ?
http://msdn.microsoft.com/en-us/library/aa480476.aspx
0
 
LVL 1

Author Closing Comment

by:smitty68521
ID: 31505478
This helped a great deal. I was able to get the steps done correctly. Thanks a bunch.
0
 
LVL 5

Expert Comment

by:harwantgrewal
ID: 22700000
Thanks smitty68521

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

Harry
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I found this questions asking how to do this in many different forums, so I will describe here how to implement a solution using PHP and AJAX. The logical flow for the problem should be: Write an event handler for the first drop down box to get …
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
Viewers will learn about basic arrays, how to declare them, and how to use them. Introduction and definition: Declare an array and cover the syntax of declaring them: Initialize every index in the created array: Example/Features of a basic arr…
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now