VB 2005 .Net + Connector/Net + MySql + CheckedListBox
 

I am having trouble getting the CheckedListBox to Check items, which the user has Checked before and which have been stored in a MySql-Database.

All the CheckedListBox items have been loaded from database and all have an indentifier which is the ValueMember.

How do I make the damn CheckedListBox to check items where the CheckedListBox.ValueMember is the same as what I get from the user checkeditems in Database?

In a loop? Yes! But how?

This is in free form (I am not at my project computer)

for each item in Checkedlistbox.items
if Checkedlistbox.selectedvalue(item) = mysqldatareader.item("id") then
checkedlistbox.getitemchecked(item)
else : mysqldatareader.nextresult()
End If
next

It goes something like that...anyone?

The problem with your current code is that you're trying to loop through the items, and not the SQL. What you want to do is loop through the SQL, and then match up your Checkbox ListItem ( checkedlistbox.FindByValue( mysqldatareader.Item("id") ), and then set the .Checked property to the value of what you get out of the database.