Selected Items to SQL
Posted: Mon Mar 23, 2009 9:38 am
Hello Guys,
I have this dropdown box and a list box.
Now what i want is when a person selects multiple items in the list box.. to go to different different lines in SQL Database.
Like suppose have dropdown box with Red, Blue, Green.
Like my dropdown has Red, Green and Blue as option and my list Menu has Very Dark, Dark, Light and Very Light.
Now what i want if user chooses all four or three options, the data that will be entered into SQL will be:
id | color | Shade
1 | Red | Very Dark
2 | Red | Dark
3 | Red | Light
mainly the options which will be selected will entered as new line in SQL table.
How can i do that?
Thanks and Regards,
Anshu Verma
I have this dropdown box and a list box.
Now what i want is when a person selects multiple items in the list box.. to go to different different lines in SQL Database.
Like suppose have dropdown box with Red, Blue, Green.
Like my dropdown has Red, Green and Blue as option and my list Menu has Very Dark, Dark, Light and Very Light.
Now what i want if user chooses all four or three options, the data that will be entered into SQL will be:
id | color | Shade
1 | Red | Very Dark
2 | Red | Dark
3 | Red | Light
mainly the options which will be selected will entered as new line in SQL table.
How can i do that?
Thanks and Regards,
Anshu Verma