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
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