.NET Create Table in Web App

[pfiske]

Hello,

I am a new Web Developer, and am using Visual Studio 2010 Ultimate and programming in C#. I am interested in creating a web app that will allow me to create and link sql tables from the finished web app. I know I can create tables from the Server explorer, etc. But I want users to be able to go in and as they use the app, tables are created to help manage the information that they contribute. Does Visual Studio have a built in tool to accomplish this, or is there a way to code it in? Ideally I'm just going to make a wizard that asks them what columns they want in the table, and then they click finish and it creates the table, then they can start adding information to the table they created, all being stored on the SQL server. Thanks for your help!

[ssystems]

It's the same as any existing application out there that does that.

using (SqlCommand command = connection.CreateCommand())
{
command.CommandText = ''; /* Build your SQL */
command.ExecuteNonQuery();
}