V
VK
Hi:
Would this work: Trying to insert selected checkboxlist values into
database.
For iBio = 0 To CheckBoxList1.Items.Count - 1
If CheckBoxList1.Items(iBio).Selected Then
sqlinsert = "INSERT INTO tProposal_x_manager (doc_num, manager_id)
VALUES("
sqlinsert = sqlinsert & doc_num & ","
sqlinsert = sqlinsert & CheckBoxList1.Items(iBio).Value & ")"
myComm1.ExecuteNonQuery()
End If
Next iBio
Would this work - or would these values have to be stored as string and
parsed and inserted into database?
many thanks
Would this work: Trying to insert selected checkboxlist values into
database.
For iBio = 0 To CheckBoxList1.Items.Count - 1
If CheckBoxList1.Items(iBio).Selected Then
sqlinsert = "INSERT INTO tProposal_x_manager (doc_num, manager_id)
VALUES("
sqlinsert = sqlinsert & doc_num & ","
sqlinsert = sqlinsert & CheckBoxList1.Items(iBio).Value & ")"
myComm1.ExecuteNonQuery()
End If
Next iBio
Would this work - or would these values have to be stored as string and
parsed and inserted into database?
many thanks