How to create a sql table during runtime with dynamic colums

Question

Please tell me the code for creating a table during runtime table name will be defined at runtime. only

Jan Montano · Answer

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(); }