Error loading small Access table into an array.
Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim strConn As String = "DSN=BattleTide;UID=;Password=;"
Dim myConn As New Odbc.OdbcConnection(strConn)
Dim myadapter As New OdbcDataAdapter
Dim mydataset As New DataSet
Dim myquery As String = "SELECT * FROM base_unit_data"
Dim mycommand As New OdbcCommand(myquery, myConn)
Dim myreader As OdbcDataReader
Dim p1Array(300) As Unit
Dim counter, i As Integer
myConn.Open()
'myadapter.SelectCommand = New Odbc.OdbcCommand(myselect, myConn)
'myadapter.Fill(mydataset)
myreader = mycommand.ExecuteReader
If myreader.HasRows Then
counter = 0
While myreader.Read()
MsgBox(myreader.GetString(1))
p1Array(counter).Unit_Name = myreader.GetString(1)
counter = counter + 1
End While
End If
End Sub
When it reaches the line "p1Array(counter).Unit_Name = myreader.GetString(1), I receive the error:
NULL Reference Exception was unhandled: Object reference not set to an instance of an object.
The line right before it - "MsgBox(myreader.GetString(1))", returns a proper string, so why would I be getting a null reference error?
John
