How to create new table on every drop down list item select

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

I have membership form that includes
Name text box
Amount drop down(1 Lac,2 Lac,3 Lac)
start date text box
end date text box
Address text box
Mobile text box

i have created a table for this in database

but
i want to divide them as groups(or creating new table for every drop down item) based on amount 1 Lac group 2 lac group

because i want to create different columns for 1 lac 2 lac items based on start date end date

for example if i selected 1 lac and start date 1/6/2015 and end date 1/12/2015 , 6 months are duration in these days, i am adding 6 columns extra to the table

otherwise

if i selected 2 lac and start date 1/6/2015 and end date 1/6/2016 , 12 months are duration in these days, i am adding 12 columns extra to the table

i have different columns for 1 Lac 2 Lac 3 Lac

please give me a suggestion or example sir

Posted 23-Jul-15 20:53pm

Member 11382784

Add a Solution

Comments

Herman<T>.Instance 24-Jul-15 2:54am

add an entity column to your table which indicates which lac is involved..

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2015-07-23T21:12:00

I really wouldn't advice you to do this. First of all normally database tables are not created based on selections in user interface. Tables are static in nature.

The second thing is that you're going to create dynamically different amount of columns in the table depending on the amount of months in the selected period. This will make all queries and data manipulation really hard in the long run.

Instead, create a child table where you store the selection (1 lac, 2 lac etc) and aither in the same table or in another child table store the months as rows along with any other data you want to store for the month. Using this kind of approach your table structure stays static while the amount of months still may vary.