0

System.NullReferenceException: 'Object reference not set to an instance of an object.' ( the error is marked here :If conn.State = ConnectionState.Closed Then)

this module name is dbconnection

Imports MySql.Data.MySqlClient
Imports System.IO

Module dbconnection
    Dim result As Boolean
    Public conn As MySqlConnection
    Public cmd As MySqlCommand
    Public da As MySqlDataAdapter
    Public dt As DataTable
    Public dr As MySqlDataReader
    Public i As Integer

    Public Function dbconn() As Boolean
        Try
            If conn.State = ConnectionState.Closed Then
                conn.ConnectionString = "server=localhost;user=root;password=;port=3306;database=election_db"
                result = True
            End If
        Catch ex As Exception
            result = False
            MsgBox("Server Not Connected!", vbExclamation)
        End Try
        Return result
    End Function

End Module

this is my other file : frm_manageUsers

Imports MySql.Data.MySqlClient
Imports System.IO
Public Class frm_ManageUsers
    Private Sub ManageUsers_Load(sender As Object, e As EventArgs) Handles MyBase.Load
        dbconn()
    End Sub

    Private Sub Pic_Close_Click(sender As Object, e As EventArgs) Handles Pic_Close.Click
        Me.Close()
    End Sub
End Class
Elie
  • 3
  • 3

0 Answers0