Hello,
I'm having an issue with updating a couple list boxes in the form load procedure. I have an array created from a MySQL database, and when I try to add that array to more than one ListBox, I get:
A first chance exception of type 'System.ArgumentNullException' occurred in System.Windows.Forms.dll
Here is the code:
Database_Functions.UpdateNames(Names)
Me.lstRoster_Roster.Items.Clear()
Me.lstRoster_Roster.Items.AddRange(Names)
Me.lstRoster_Home.Items.Clear()
Me.lstRoster_Home.Items.AddRange(Names)
And Database_Functions.UpdateNames:
Public Sub UpdateNames(ByRef Names() As String)
Dim sql As String = "SELECT Name FROM users"
Dim cmd As MySqlCommand = New MySqlCommand(sql, Login.SQLConnection)
Dim reader As MySqlDataReader = cmd.ExecuteReader()
Do While reader.Read()
Static i As Integer = 1
ReDim Preserve Names(i)
Names(i - 1) = reader.GetString(0)
i += 1
Loop
reader.Close()
End Sub
Thanks in advance for your help!