Member Avatar for randomkid73

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!

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.