View Single Post
Old 09-06-2005, 01:00 AM   #1 (permalink)
Tapsa84
Upright
 
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?
Tapsa84 is offline  
 

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37