Author: lyealain | Posted on: 1/25/2009 12:18:46 AM | Views : 253

hi i want to pull the records from database and bind to the different checkboxlists by using FindByValue:

i have 3 checkboxlist . e.g.  chkSubjects, chkKET, chkPET

for the first checkboxlist - (chkSubjects), i pull the records from database add to the checkboxlist as the code below:
1 'Retrieve all subjects
3 Dim qryGetSubjects As String = "SELECT DISTINCT Subject AS Subject FROM Profiles ORDER BY Subject"
4 Dim dsGetSubjects As New DataSet
6 dsGetSubjects = Database.ODBCExecuteAsDataSet(qryGetSubjects, conn)
7
8 'Add to checkbox
9 Go to the complete details ...