CheckListBox - Check items based on Array value - VB.NET

Question

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.

I get a string from my MySQL database server. I then split the string and put it into an array.

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.

This is somewhat of a template I have and if anyone can help me out with this problem, I would be more than thankful.

    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

Anyone? Please...?

Please post the contents of STRINGRR and the contents of the first 3 items in the clbEmployees — Michael Rodrigues
– Michael Rodrigues, Commented Aug 1, 2012 at 2:06

Samuel Adam · Accepted Answer · 2012-08-01 02:41:27Z

2

I don't know for sure with so little code, but why are you using the same index for your If condition? Then what good does X does?

I think it should be like :

For Each X In NEWSTRINGRR
    For I = 0 To clbEmployees.Items.Count - 1
        If clbEmployees.Items(I).ToString() = X.ToString() Then
           SetItemChecked(I)
        End If
    Next
Next

CMIIW.

edited Aug 1, 2012 at 2:41

answered Aug 1, 2012 at 2:11

Samuel Adam

1,3374 gold badges26 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

paparazzo · Accepted Answer · 2012-08-01 01:55:08Z

0

You do know STRINGRR is only going to have the value of the last row. Add yes you need to post all your code.

answered Aug 1, 2012 at 1:55

paparazzo

45.2k24 gold badges110 silver badges180 bronze badges

2 Comments

user1567271 Over a year ago

STRINGRR contains "Your Name, My Name, Her Name," - NEWSTRINGRR contains this string broken down into an array

paparazzo Over a year ago

Did you debug those values? Where values failed to match that you thought should match?

Collectives™ on Stack Overflow

CheckListBox - Check items based on Array value - VB.NET

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related