I am developing windows form application usind Sql server 2005 database and VS 2008.

my table has two columns: name and room

name is textbox while rooms are listed in checkedlistBox

now i want to insert these values into my customerTbl:

if i select more than one room, the room in my table will be separted by coma,

if i select more than one rooms.

then in my table it will be likes:

name rooms

Girmay 101,102,103

Mike 103,104,110

Lemlem 101,102



so how would i insert data from checkedListBox into my table?
help me please