Click here to Skip to main content
15,892,059 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
The line with the asterisk is the line where the error is but I don't know what make that line error! Any idea???? please help hehhe


VB
Private Sub btnLogin_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLogin.Click

     Dim intResult As Integer
     conn = New OleDbConnection(strConn)
     conn.Open()

     ' Catch sa error k2ng form clause
     Try
         strSQL = "SELECT * FROM User WHERE (Username LIKE ?) AND (Password LIKE ?)"the

         'strSQL = "SELECT * FROM User WHERE Username = @Username AND Password = @Password"

         Dim dbCmd As New OleDbCommand(strSQL, conn)
         'G Add lng
         'dbCmd.CommandType = CommandType.Text

         dbCmd.Parameters.AddWithValue("Username", txtUsername.Text)
         dbCmd.Parameters.AddWithValue("Password", txtPassword.Text)
        ****** dbReader = dbCmd.ExecuteReader()


         Using dbReader
             If dbReader.Read() Then
                 Dim strResult1 As String = dbReader.Item("Username")
                 Dim strResult2 As String = dbReader.Item("Password")

                 If chkRememberUsername.Checked = True Then
                     My.Settings.Username = txtUsername.Text
                     My.Settings.Save()
                     My.Settings.Reload()

                 End If

                 Me.Close()
                 mediaSoundPlayer.Stream = My.Resources.tada
                 mediaSoundPlayer.Play()

                 frmLoading.ShowDialog()

                 'frmMain.LogOffToolStripMenuItem.Text = "Log Off"
                 'frmMain.SettingToolStripMenuItem.Enabled = True
                 frmMain.LogOffToolStripMenuItem.Text = "Log Off"
                 Me.Close()
                 frmMain.Show()
             Else

                 intResult = MessageBox.Show("Invalid Username Or Password", "Login", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error)


                 If intResult = DialogResult.Cancel Then
                     Me.Close()

                 Else
                     intResult = DialogResult.Retry
                     Me.Show()

                 End If
                 frmMain.SettingsToolStripMenuItem.Enabled = False
                 frmMain.LogOffToolStripMenuItem.Text = "Login"


             End If


         End Using
         conn.Close()


     Catch ex As Exception
         MsgBox("System Error", MsgBoxStyle.Critical, "Error in login")
     End Try
     'frmMain.Show()



 End Sub
Posted
Updated 24-Feb-10 8:13am
v2

now it says dbdatareader is not define...... any idea about this??
 
Share this answer
 
Looks like you have not declared the reader.

Insert the following at the top of the method

Dim dbReader as DbDataReader  OleDbDataReader= Nothing


I have changed the Object Type, as only just noticied you where using OleDbCommand which returns a different type from the ExecuteReader function.
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900