0

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!

2
Contributors
1
Reply
2
Views
5 Years
Discussion Span
Last Post by Smith5646
0

I think you have a problem with the build of your names array. See if the value of the last entry in it is NOTHING.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.