How to create a sql table during runtime with dynamic colums

Hi Satya,

Have you worked with ado before? how about sql scripts? Sample code below will create a PayType table in your Northwind database. You just have to make the PayType table name dynamic.

private void CreateTable()
{

SqlCommand sqlCommand = new SqlCommand();
SqlConnection sqlConnection = new SqlConnection("Data Source=localhost;Database=Northwind;Integrated Security=SSPI");

string createTableQuery = "CREATE TABLE [dbo].[PayType] (" +

"[PayType] [varchar] (3) COLLATE Arabic_CI_AS NOT NULL ," +
"[PayDesc] [varchar] (35) COLLATE Arabic_CI_AS NOT NULL" +

") ON [PRIMARY]";

sqlCommand.CommandType = CommandType.Text;
sqlCommand.CommandText = createTableQuery;
sqlCommand.Connection = sqlConnection;

sqlConnection.Open();
sqlCommand.ExecuteNonQuery();
sqlConnection.Close();

}