i am developing windows form application and my database is Sql server 2005.

i know how to insert from textbox into my table, but i got hard how to insert from checkedlistbox into my table.

my table(customerTable) has two columns, customerName, and room.

in my checkedlist box i have 1,2,,3,4,5........30,31,32 rooms list.

i can select one or more rooms at the same time, for example, in the textbox of customerName i insert: Girmay Mekelle

and the checkedlistBox lists: i can choose(tick) rooms: 10,13,18

then click add button,

then i expected the rooms in my table will be 10,13,18 and customerName:Girmay Mekelle.

so how do i insert from checkedlistbox into my table?
my second question is:
if you can solve the above problem then , how do i select rooms from my table so that i can list them in checkedlistBox?

i am a begginer and i tried to google it but i could not get the solution.

so please forward ur help towards me. thanks