Saving in particular table based on dropdown item selection

Question

i am having three categories in drop-down and separate three tables for each category,

for example,

Animals, Vegetables, Human categories  in drop-down.

when i select Vegetables category (item) from drop-down list,

and fill all the remaining details and when i click the submit/save button

the data in that page has to be saved in that particular Vegetables table in database.

 

 

if someone has  understood my question, please help with it, if possible with exact code

please 

Answer 1

Hi check the link

http://www.aspsnippets.com/Articles/Create-and-Drop-SQL-Server-Table-programmatically-using-ADONet-C-and-VBNet.aspx

For insert record in table

http://www.aspsnippets.com/Articles/Using-SqlBulkCopy-to-import-Excel-SpreadSheet-data-into-SQL-Server-in-ASPNet-using-C-and-VBNet.aspx

Answer 2

Hi,

Its just the idea, try to use the import functionality of SQL server.

Hope it helps.

Thanks.