How to add new column to SQL from inside the code

[bojomojo]

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?

Edit:
Can anyone direct me to a good book or tutorial about linking SQL with c# applications or something like that?

[Ramy Mahrous]

Using SMO library you can modify your database objects, here's a sample http://www.codeproject.com/Tips/43900/Creating-SQL-Server-Login-programmatically.aspx but to do something a bit different but I'm sure you'll get it.

I believe there's something in your design to avoid redesign everytime, be sure your system is scalable enough and try another database design.

[bojomojo]

I am very new to databases, so i think i should give it more study.. do you recommend any resource for sql with c#?

[Ramy Mahrous]

You don't need C# right now, just concerntate on datbase design and concepts read more about database normalization and how to make your desing more efficient. I don't have specific resources use Google\Bing you'll read posts about each topic.