Inserting checkbox values into one field

ebosysindia · 05-04-2009, 08:06 AM

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.

zain654321 · 07-09-2009, 06:55 AM

Add a single checked event handler for all check box items. convert the sender to Checkbox. like **CheckBox chk = (CheckBox)sender;** get the item name from the variable chk form the string concatenated with comma's. you may use string.format(); I think this is the way you can find form the string.

05-04-2009, 08:06 AM	#1
ebosysindia Warrior Member Join Date: May 2009 Posts: 2 Thanks: 0 Thanked 0 Times in 0 Posts	Inserting checkbox values into one field 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.
	software application development \| mobile application development \| java game development

07-09-2009, 06:55 AM	#2
zain654321 Active Warrior Join Date: Jul 2009 Posts: 56 Thanks: 2 Thanked 2 Times in 2 Posts	Re: Inserting checkbox values into one field Add a single checked event handler for all check box items. convert the sender to Checkbox. like CheckBox chk = (CheckBox)sender; get the item name from the variable chk form the string concatenated with comma's. you may use string.format(); I think this is the way you can find form the string.