how to store checkboxlist data into database

Question

how to store checkboxlist data into database using asp.net...

For example i have under hobbies list: music,reading,watchingTV,playing,chatting,singing,cooking,dancing

In this list If i select music,reading and playing from the checkboxlist and click button the items selected should to be stored in backend table how to do this ...Please Explain me with an example

Kirtan Patel · Answer

Hi Here is Solution to your Problem dont Forget to mark  Do you like answer  please it will give me some Credits :) You can Store These Type of Data in Bit DataType of SQL Server Store Them Separately in Database Another Solution ---------------------- Store Them All in One Field Called hobbies(varchar) and Store their Check Box States like (0101110) and While Retriving That String Split it and Display them in CheckListBox .