?
Solved

Custom login in asp.net 2.0 error

Posted on 2008-10-12
3
Medium Priority
?
240 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 5

Accepted Solution

by:
harwantgrewal earned 2000 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

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.
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn the basics of jQuery, including how to invoke it on a web page. 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.: (CODE)
Suggested Courses

650 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