0

I keep getting an error when trying to check values from a database and read from a database to text boxes. At the for i as integer line I get the following error message:

An unhandled exception of type 'System.NullReferenceException' occurred in VBPROJECT.exe despite the code working earlier.

Here's the code:

Imports System.Data.OleDb
Public Class StudentLogin
    Dim objConnection As New OleDb.OleDbConnection(
    "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Customers.accdb")
    Dim objDA As _
    New OleDb.OleDbDataAdapter("Select * from tblStudents", objConnection)
    Dim objCB As New OleDb.OleDbCommandBuilder(objDA)
    Dim objDS As New DataSet()
    Public UserID, Password As String
    Dim StudentFound As Boolean

    Private Sub Retrieve()
        objDS.Clear()
        objDA.FillSchema(objDS, SchemaType.Source, "tblStudents")
        objDA.Fill(objDS, "tblStudents")
    End Sub

    Private Sub Button1_Click(sender As Object, e As EventArgs) Handles btnLogin1.Click
        UserID = txtUsername.Text
        Password = txtPassword.Text
        For i As Integer = 1 To (objDS.Tables("tblStudents").Rows.Count)
            If CStr(objDS.Tables("tblStudents").Rows(i - 1).Item("Surname")) =
           UserID And
            CStr(objDS.Tables("tblStudents").Rows(i - 1).Item("Student Number")) =
            Password Then


                StudentFound = True

                frmStudentPortal.txtMCQ.Text = CStr(objDS.Tables("tblstudents").Rows(i - 1).Item("MCQ Result"))
                frmStudentPortal.txtProject.Text = CStr(objDS.Tables("tblstudents").Rows(i - 1).Item("Project Result"))
                frmStudentPortal.txtOverall.Text = CStr(objDS.Tables("tblstudents").Rows(i - 1).Item("Overall Result"))
                frmStudentPortal.lblname.Text = "Welcome " & CStr(objDS.Tables("tblstudents").Rows(i - 1).Item("First Name"))
                frmStudentPortal.lblname.Visible = True

                MessageBox.Show("Welcome to the System!")
                lblStudentIDincorrect.Hide()
                lblPasswordIncorrect.Hide()
                Me.Hide()


                frmStudentPortal.Show()


                'Main_Page.Show()
                Exit For
            End If
            txtUsername.Text = String.Empty
            txtPassword.Text = String.Empty
        Next
        If StudentFound = False Then
            MessageBox.Show("Access Denied")
            lblStudentIDincorrect.Show()
            lblPasswordIncorrect.Show()
        End If
    End Sub
Martijn Pieters
  • 889,049
  • 245
  • 3,507
  • 2,997
Kelan
  • 11
  • 4

0 Answers0