add column in database using C# code

Question

hello there

i want to create a 2 column in an existing table of my database using C# i mean in my window form 2 textbox and one button is there
i enter some text and click on the button
then i creates a column named as i write in textbox
my database is sql server database .mdf file

help me out please

Krishna Rajput Singh · Answer

Hello shivkumar patil thanks for writing blow links i hoe helpful for you...:) http://www.aspforums.net/Threads/120561/Dynamically-Add-Column-to-database-Table-from-code-behind-in-C-Net/ http://www.codeproject.com/Articles/581104/Dynamically-add-access-database-columns-at-runtime http://www.dotnetperls.com/datatable http://www.homeandlearn.co.uk/csharp/csharp_s12p3.html helpful answer please mark as correct answer or accept my answer

Raja T · Answer

Hello Shivkumar try like string constr = ConfigurationSettings.AppSettings[ConnectionString].ToString(); private void button1_Click(object sender EventArgs e) { string query = alter table [ FirstTable ] add  + textBox1.Text+  int NULL  + textBox2.Text + varchar(50) NULL ; SqlConnection con = new SqlConnection(constr); SqlCommand cmd = new SqlCommand(query con); con.Open(); int i = Convert.ToInt32(cmd.ExecuteNonQuery()); con.Close(); }

Amit Singh · Answer

using (DbConnection connection = new SqlConnection(Your connection string)) { connection .Open(); using (DbCommand command = new SqlCommand(alter table [Product] add [ProductId] int default 0 NOT NULL)) { command .Connection = connection; command .ExecuteNonQuery(); } }