Changing column name in Mysql using c# asp.net

Question

I want to give the provision of changing the column name and table name in mysql database using c# asp.net. please help.

Anurag Sarkar · Answer

Thanks i sorted it myself Only.

Vignesh Kumar · Answer

Hi Try this string query =  update orderform set enrolmentexpected =  + textBox2.Text +  stockonhand= + textBox3.Text +  numberrequired =  + textBox4.Text +  where name = ' + textBox1.Text + '; or http://www.ianatkinson.net/computing/mysqlcsharp.htm

Javeed M Shaikh · Answer

I am not sure if you tried this give a shot: MySqlConnection conDatabase = new MySqlConnection(connectionstring); MySqlCommand cmdDatabase = new MySqlCommand(command to change column name; conDatabase); conDatabase.Open(); cmdDatabase.ExecuteNonQuery(); conDatabase.Close();