I am creating a program that will have a database of schools.. Each months the user needs to add a certain data entry for all schools, like each month the user will need to input how each school scored in a monthly competition.
The number of months is not fixed, so I need the program to be able to create a new column in the database then add data to it through the gui.
Right now i have the DB ready and the gui successfuly reads/edits data or rows(schools)..
How can I do that? or do you have any better ideas? like create a separate table for each school?
Can anyone direct me to a good book or tutorial about linking SQL with c# applications or something like that?