How to add new column to SQL from inside the code

Question

bojomojo 0 Newbie Poster

14 Years Ago

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?

Edited 14 Years Ago by bojomojo because: n/a

2 Contributors
3 Replies
124 Views
6 Hours Discussion Span
Latest Post 14 Years Ago Latest Post by Ramy Mahrous

Ramy Mahrous 401 Postaholic

14 Years Ago

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.

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

bojomojo 0 Newbie Poster · Answer 1 · 2010-09-13T18:05:38+00:00

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 401 Postaholic Featured Poster · Answer 2 · 2010-09-13T18:36:34+00:00

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.