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

add column in database using C# code

Answers (3)