title: CheckListBox - Check items based on Array value - VB.NET
body: <p>OK... After many many days of trying to figure it out, I have no option but to ask for help. I have Googled my little heart out and now it has led me here. PLEASE HELP.</p>
  
  <p>I get a string from my MySQL database server. I then split the string and put it into an array.</p>
  
  <p>Than I go through my checklistbox and see if any of the entries in there are equal to an array value. The problem is, it doesn't work and for the life of me I can't get it to work.</p>
  
  <p>This is somewhat of a template I have and if anyone can help me out with this problem, I would be more than thankful.</p>
  
  <pre><code>    Using connection As New MySqlConnection("datasource = " + IPADDRESS + "; username = '" + USERNAME + "'; password='" + PASSWORD + "' ; database = '" + DBASE + "'")
          Using Command As New MySqlCommand("SELECT * FROM hazinc WHERE title = '" + ListBox1.Text + "'", connection)
  
              connection.Open()
  
              'Command.ExecuteReader()
              Using reader As MySqlDataReader = Command.ExecuteReader()
                  While reader.Read()
                      'TextBox2.Text = reader("title")
                      STRINGRR = reader("involved")
  
                  End While
  
                  Dim NEWSTRINGRR As String() = STRINGRR.Split(",")
  
                  Dim CC As Integer
  
                  CC = 0
  
                  For Each X In NEWSTRINGRR
                      For I = 0 To clbEmployees.Items.Count - 1
                          Try
                              If clbEmployees.Items(I).ToString() = NEWSTRINGRR(I).ToString() Then
                                  SetItemChecked(I)
                              End If
                          Catch ex As Exception
                              ' MsgBox(ex.ToString)
                          End Try
  
                      Next
                  Next
  
  
  
              End Using
  
              connection.Close()
  
          End Using
      End Using
  </code></pre>
  
  <p>Anyone? Please...?</p>