Results 1 to 2 of 2

Thread: Abnormal Login Page Behavior

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Mar 2005
    Posts
    312

    Abnormal Login Page Behavior

    Hello i m new to ASP.net, i have created a form and have these controls on it

    1. Login Name Textbox
    2. Password Textbox
    3. A button (Form Submit Button not the HTML Submit button)
    4. A label named lblNote to show a simple msg that login is successful or not.

    I have a Database named LoginSite.mdb which is a part of my project. This database has only loginName and Password in it.

    Now i wrote this code in my button click event.

    Code:
    Imports System.Data.OleDb
    Partial Class MainForm
        Inherits System.Web.UI.Page
    
        Dim dbConn As OleDbConnection
        Dim dbcmd As New OleDbCommand
        Dim rs As OleDbDataReader
        Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
            dbConn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=" & Server.MapPath("LoginSite.mdb"))
            dbconn.Open()
            dbcmd.Connection = dbConn
          
        End Sub
    
        Protected Sub btnLogin_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnLogin.Click
            Try
                dbcmd.CommandText = "Select * from LoginTBL"
                rs = dbcmd.ExecuteReader()
    
                While (IsDBNull(rs))
                    If (rs("loginName").Equals(txtLoginName.Text) = True And rs("loginPassword").Equals(txtPassword.Text) = True) Then
                        lblNote.Visible = True
                        lblNote.Text = "You have been Successfully Logged in"
                    Else
                        lblNote.Visible = True
                        lblNote.Text = "Error Logging In !!!"
                    End If
                End While
    
            Catch ex As Exception
                lblNote.Text = "Error Logging In !!!"
            End Try
        End Sub
    End Class
    The problem is that i m not able to see the lblNote label with any kind of information about the login being successful or not. lblNote is not being displayed.

    Please Help !!!

  2. #2

    Thread Starter
    Hyperactive Member
    Join Date
    Mar 2005
    Posts
    312

    Re: Abnormal Login Page Behavior

    Got It

    The Error was in this Line
    while (isDbNull(rs))
    it should be like this
    While (rs.read)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width