Inserting checkbox values into one field

[ebosysindia]

hi

I have a checkboxes on my page (.aspx) like

checkbox1 - item1
checkbox2 - item2
checkbox3 - item3
etc

what i want is that when a user selects certain checkboxes
they should be inserted into a table called
customer which has fields (customer id and actions)

the data should be inserted as

customerid actions
1 item1,item2,item3
2 item1,item3
3 etc..

i.e all the values should be inserted into database into one field separated by commas.

Thanks

 

[SubSpace]

This is not really the forum to ask questions, but just concatenate the strings and update the database in one of the many ways ADO.NET offers you

...however. Depending on what you're trying to accomplish, it's not a good idea to put these values into a single field at all. It would probably be better to store them in a second table and have a one-to-many relation between those two tables. Moreover, you might want to put the actions themselves into the database as well.

This would be the way to go if you actually had to do stuff with the information Putting all the values into a single text field makes it harder to work with when you want to retrieve information. Not only that, your queries will be much slower than they could have been with the right table structure, indexes and statistics.

It wasn't my intention to confuse you or anything, but I think it would be good to find some basic database and ADO.NET tutorials to get you started. And if you were thinking about it, forget about Microsoft Access and skip straight to MS SQL Server