Hi, I have store some value in database. Eg Sales. I have a checkboxlist contains items populate from the database. I want to select the checkbox item if the value matches.

   For i = 0 To products.Items.Count - 1

'How should i do the For Loop comparing the values?

                    Exit For
                End If
            Next
        Next

Please advise, thanks alot

You have to pull the values into a datatable or dataset and loop through the table and and table then compre values and set the selected property as needed.

I store the value that i retrieve from the database in "mycode". When I try to start the page it gives me error. Is my coding wrong?

        Dim mycode As String()
        Dim i As Integer
        Dim currentcheckbox As ListItem

        mycode = activate.showAllRequestCode(sfID)

        For i = 0 To cbl_Codes.Items.Count - 1

            currentcheckbox = cbl_Codes.Items.FindByValue(Convert.ToString(mycod e))

            If Not (currentcheckbox Is Nothing) Then
                currentcheckbox.Selected = True
            End If
        Next

what is the error and on what line?

It ok jbenson001, I resolve it already. Thanks for your help :)

ok

What did you do to fix it? What was the problem? Maybe we all could learn something.