For each statement

[JJ297]

How do I read through the database to get the items that are checked
to appear on my page? I have a checkboxlist on the page.

I wrote this but it brings back all items checked...

For Each l As ListItem In CheckBoxList1.Items

l.Selected = True

Next

Any suggestions? Thanks!

 

[Juan T. Llibre]

re:
!> For Each l As ListItem In CheckBoxList1.Items
!>
!> l.Selected = True
!>
!> Next

Try adding an if condition and adding code to do something with the selected items :

For Each l As ListItem In CheckBoxList1.Items
IF
l.Selected = True
' do something here
END IF
Next

 

[JJ297]

re:
!> For Each l As ListItem In CheckBoxList1.Items
!>
!> l.Selected = True
!>
!> Next

Try adding an if condition and adding code to do something with the selected items :

For Each l As ListItem In CheckBoxList1.Items
IF
l.Selected = True
' do something here
END IF
Next










- Show quoted text -

I want the items to be checked on the screen so would I do this?

Dim chk = checked

For Each l As ListItem In CheckBoxList1.Items

IF
l.Selected = True

Checkboxlist1.items = chk

END IF

Next