Dim chkarray As String(), Chkboxes As String
Dim J, iLoop As Integer
Chkboxes = "chkSubjects,chkKET,chkPET,chkPREFCE,chkFCE,chkCAE"
chkarray = Split(Chkboxes, ",")
Dim TutorID As String = "T234"
lblmsg.Text = ""
For J = 0 To chkarray.Length - 1
Dim chk As New CheckBoxList
chk = DirectCast(Me.FindControl(chkarray(J)), CheckBoxList)
For iLoop = 0 To chk.Items.Count - 1
If chk.Items(iLoop).Selected = True Then
Dim qryInsertSubjects As String = "INSERT INTO Subject (ID, Subject) VALUES ('" & TutorID & "','" & chk.Items(iLoop).Value & "')"
lblmsg.Text += qryInsertSubjects + "
"
End If
Next iLoop
Next J
24 December, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment