Checked items in diff fields in db

tiffany

Well-known member
Joined
Aug 7, 2005
Messages
57
Programming Experience
1-3
hi, i had create a checkbox list with three items. Once i checked on thw two items among the three, it will then saved in the db as follows:

Field1 Field2
data1 data2

That means the each of the checked item will be saved in different field in db.

i wrote this statment but it only just store one checked item in one field in db:
INSERT INTO movieDet ([Title], [des], [Year], [actor1], [actor2], [actor3], [actor4], [branch], [section], [category], [type], [pic]) VALUES('" & tb_title.Text & "','" & tb_des.Text & "','" & tb_year.Text & "','" & tb_actor1.Text & "','" & tb_actor2.Text & "','" & tb_actor3.Text & "','" & tb_actor4.Text & "','" & CheckBoxList1.SelectedValue & "','" & cl_sec.SelectedValue & "','" & RadioButtonList2.SelectedValue & "','" & RadioButtonList3.SelectedValue & "','" & Image1.ImageUrl & "')

Sorry i know the codes are little messy, please bear with it. thnk. How can i improve the codes to the requirement i want?

thnk
Regards,
tiffany
 
Back
Top