Velocity Reviews

Velocity Reviews (http://www.velocityreviews.com/forums/index.php)
-   ASP .Net Web Controls (http://www.velocityreviews.com/forums/f63-asp-net-web-controls.html)
-   -   Checkboxlist and database - Input needed (http://www.velocityreviews.com/forums/t775445-checkboxlist-and-database-input-needed.html)

VK 02-18-2005 01:42 PM

Checkboxlist and database - Input needed
 
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!


All times are GMT. The time now is 09:27 PM.

Powered by vBulletin®. Copyright ©2000 - 2014, vBulletin Solutions, Inc.
SEO by vBSEO ©2010, Crawlability, Inc.