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 ...