Your database design is not efficient. If you manage to put all that into one column while saving, it is still a trouble for you to extract when you retrieve data. Change your database table to have multiple column. One to represent 1) Friends, 2) Dating,
3) Business and 4) Activity Partners. Populate all with 0. If the checkbox is checked, turn appropriate column (for particular row) to 1.
Please click 'Mark as Answer' if my reply has assisted you
kaiclassic
Member
541 Points
196 Posts
Re: How to store multiple values of CheckBoxList into Database
Apr 26, 2011 07:38 AM|LINK
Your database design is not efficient. If you manage to put all that into one column while saving, it is still a trouble for you to extract when you retrieve data. Change your database table to have multiple column. One to represent 1) Friends, 2) Dating, 3) Business and 4) Activity Partners. Populate all with 0. If the checkbox is checked, turn appropriate column (for particular row) to 1.