vb.net insert into database from checked list box

Question

I have a checked list box with 6 items . i use the designer to set the binding source to the coulm in my data base named "Gad" the problem is when i select 2 or 3 items from checked list the coulm "gad" on my database get the first selected only .. i want the all selected items saved in this this coulm separated by dashes like item1 - item2 - item 3

Answer 1

Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
    Dim bob As New System.Text.StringBuilder

    For Each item As String In CheckedListBox1.CheckedItems
        bob.Append(item)
        bob.Append(" - ")
    Next

    MessageBox.Show(bob.ToString)
End Sub