Visual Basic

<br />
Dim i As Integer <br />
Dim dt As New DataTable() <br />
Dim dr As DataRow <br />
Dim userID As Integer <br />
<br />
dt.Columns.Add("UserID") <br />
dt.Columns.Add("GroupID") <br />
For i = 0 To Me.chkLstSecurityRoles.CheckedItems.Count - 1 <br />
dr = dt.NewRow() <br />
dr("UserID") = userID <br />
dr("GroupID") = 'The index number of the checked item that have been clicked<br />
Next<br />

Private Sub loadGroups()<br />
        Dim objGetGroups As New BL_Groups()<br />
        Dim ds As New DataSet()<br />
        ds = objGetGroups.getAllGroups()<br />
        Dim dt As New DataTable()<br />
        Dim i As Integer<br />
        dt = ds.Tables(0)<br />
<br />
        Try<br />
            For i = 0 To ds.Tables(0).Rows.Count - 1<br />
                Me.chkLstSecurityRoles.Items.Add(dt.Rows(i).Item("Privilege")).ToString()<br />
            Next<br />
        Catch ex As Exception<br />
            MessageBox.Show(ex.Message)<br />
        End Try<br />
<br />
    End Sub<CODE><br />
Is it good to put them in to an array and them to a store procedure. <br />
<br />
If the user clicks 20 items, then I would have to do 20 inserts. That doesn't sound too efficient. <br />
<br />
The code I have for finding the checked items is below<br />
<CODE> Dim i As Integer<br />
        Dim strChecked As String<br />
<br />
        For i = 0 To Me.chkLstSecurityRoles.CheckedItems.Count - 1<br />
<br />
            strChecked = Me.chkLstSecurityRoles.CheckedItems(i).ToString()<br />
        Next