mysql and c#

Question

how i can rename mysql table using textbox in c#?

Raja T · Answer

Hello Rami Try like befor you need add mysql dll in you project.Now i am show using sqlserver protected void Button1_Click(object sender EventArgs e) { SqlConnection con = new SqlConnection(Data Source= localhost ;Initial Catalog= yourdb ;User Id= urdb_uname ;Password= urdb_pwd ); SqlCommand cmd = new SqlCommand(sp_rename ' + txt_oldtblname.Text.Trim() + '' + txt_newtblname.Text.Trim() + ' con); con.Open(); cmd.ExecuteNonQuery(); con.Close(); }