problem on checkboxlist

[biswa47]

hello frndz. thanks for ur reply n solution to my query. here another small query for you. i have a checkboxlistitem.where let say A,B,C,D,E are the items in that control. i am able to store the mulitiple value of the checkbxlist item .(by taking a string and storing the multiple value by "," operator). now my problem is that when i am retriving the value from the db ,am not able to retrive the value of the lsitboxitems. (suppose in emp_id "1" i have stored the values of A,C,D from checkboxlist,when i retrive the record having emp id1. i want to retrive its value i.e A,C,D and the corresponding checkbox of the values to be checked in the front end.) what will be code in vb.net

[Panchal Hardik]

first u can splite the result row with 'A,C,D' with ",". now u have the array of the all checkbox which need to select. now with checkboxlist you can find the ur checkbox by text or value and give the property selected

Hardik Panchal

[biswa47]

can u write the code for it. actully i have tried this logic but may be with wrong code. so asking you to write the code for it in vb.net

[Panchal Hardik]

For Each dr As DataRow In checkboxlist.Items if dr(columnname) = 'A' then checkboxlist.Items.checked = true end if Next

Hardik Panchal

[John ph]

Here is the code you asked for...

            Dim lstItem As New ListItem
            Dim lstItems() As String = Value.Split(",")  'Value = "A,B,C"

            For Each lstItem In chklstItem.Items
                For I As Int16 = 0 To lstItems.Length - 1
                    If lstItems(I) = lstItem.Value Then
                        lstItem.Selected = True
                    End If
                Next
            Next

I suggest you to write a property procedure which will GET and SET the values of the CheckBoxList...

---

Regards
John

---