Submit form to certain table based on user selection

Hayden Meherg

7y830Web Development

I have a form with a drop down list...

-optionA

-optionB

-optionC

-optionD

...each option in the list has it's own table in a database.

-optionA_table

-optionB_table

-optionC_table

-optionD_table

Based on the choice a user selects from the drop-down list, when they submit the form I'd like for corresponding table to be selected within the database so the user just has to hit "Submit" and it posts the data into the corresponding table based on the option they choose in the drop down list. How would you achieve this?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajanikant Hawaldar7y ago
Hi Dear,

if split your combobox item after select you will get table name so that you can pass that string as table to database very simple

Split this _ so you will get your table name

string[] selectedItem= combobox.Text.Split('-') //selected item

string tableName=selectedItem[0];

let me know if not resolved

Thanks
Piyush Pansuriya7y ago
Hello,
Please share your database table structure, so It should be more clear your requirement.