Getting a little annoyed. I've successfully bound a checkboxlist control to a sql server table to populate the list - now I want to take the user's selections and store each checkbox in the list's input in a different field in the database. No idea how to do this, and I can't find any samples online. I'm pretty sure I need to write some looping code using "For each", but don't know how to implement..anyone with ideas?

You get the left paddle and I'll get the right.

http://p2p.wrox.com/topic.asp?TOPIC_ID=9689

Here is an example straight from MSDN. This code applies to "ListBox, DropDownList, CheckBoxList, and RadioButtonList". I think it is what you are looking for:

' Visual Basic
Public Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
   Dim msg As String
   Dim li As ListItem
   msg = ""
   For Each li In ListBox1.Items
      If li.Selected = True Then
         msg = msg & "<BR>" & li.Text & " selected."
      End If
   Next
   Label1.Text = msg
End Sub


It is under "Determining the Selection in a List Web Server Control". This should give you a base to work from. Replace the code between the "If" statement with your code to update the fields in your database.

Hope this helps.

J

Thanks - just need to figure out the database code, which'll be a lil' tricky, since the order of the checkboxlist is going to change repeatedly - but that's a good start! Appreciated.