add column in database using C# code

shivkumar patil

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Krishna Rajput Singh10y ago
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 T10y ago
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 Singh10y ago

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