Checkboxlist and database - Input needed

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: VK (vk_at_vk.com)
Date: 02/18/05 

Date: Fri, 18 Feb 2005 05:42:37 -0800

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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!