Insering Multiple Checkboxlist Values

Hi,

I'm trying to insert multiple checkboxlist values from a databound checkboxlist into a SQL Server Express DB.

I need to insert the values JobID and CategoryID into an intermediate table which is made of two columns, JobID and CategoryID, which form the primary key. I'm using the following code:Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click

Dim insertCommand As SqlCommand

Dim strConnection As String = "Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|ASPNETDB.MDF;Integrated Security=True;User Instance=True"Dim objConnection As New SqlConnection(strConnection)

Try

objConnection.Open()

Dim ctr As Integer

Dim str As StringFor ctr = 0 To CheckBoxList1.Items.Count - 1

If CheckBoxList1.Items(ctr).Selected Then

str = "INSERT INTO CategoryVacancies (JobID, CategoryID) values (@JobID, @CategoryID)"insertCommand = New SqlCommand(str, objConnection)

insertCommand.Parameters.AddWithValue("@CategoryID", CheckBoxList1.SelectedValue)insertCommand.Parameters.AddWithValue("@JobID", JobIDLabel.Text)

insertCommand.ExecuteNonQuery()

End If

Next

objConnection.Close()Catch ex As Exception

errorLabel.Text = "Failed because:" & ex.Message

End Try

End Sub

I get this error: Violation of PRIMARY KEY constraint 'PK_CategoryVacancies'. Cannot insert duplicate key in object 'dbo.CategoryVacancies'. The statement has been terminated.

It always inserts only the first value of the checkboxlist, instead of looping through and inserting all the rows.

Anyone know what's going wrong?

 Many Thanks