Error updating MySql record in C # from Visual Studio

Question

Good night. Sorry to bother you. I am having a problem that is driving me crazy and I cannot find the fault. Design a program that, among other functions, has one that allows you to generate a receipt for the database and send it automatically by email. The configuration of the email account (address, user, password, host, port, ssl) I have saved in a database table, and every time I give the order to carry out that backup operation, it raises the configuration of the email account from that table. That works perfect. The issue is that I create a form, which upon entering, automatically raises all those settings and displays them in different textboxes. I did this in case at some point I decide to change any of that data (for example, the email or password, from there I can do it), but when I want to update that information with a button so that it is saved in said update in the database data, it throws me an error and automatically sends me to the "Program.cs" configuration and marks the Login form. It should be noted that the code used for this update is the same as that used in another form where it works perfectly (obviously that it changes the names of the fields). I attach the code. THANK YOU.-
private void btnactualizar_Click(object sender, EventArgs e)
{
conexion_email.Open();
string actualizarconfiguracion = "update clientes set idconfiguraciones_email ='" + txtid.Text + "',DIRECCION_EMAIL ='" + txtdireccion.Text + "',USUARIO ='" + txtusuario.Text + "',PASSWORD ='" + txtpassword.Text + "',HOST ='" + txthost.Text + "',PUERTO ='" + txtpuerto.Text + "',SSL ='" + txtssl.Text + "',DIRECCION_RESGUARDO ='" + txtdireccionresguardo.Text + "' where idconfiguraciones_email =" + txtid.Text;
MySqlCommand comando_configuracion = new MySqlCommand(actualizarconfiguracion, conexion_email);
comando_configuracion.ExecuteNonQuery();
conexion_email.Close();
MessageBox.Show("Configuracion Actualizada Correctamente");
}

Rajanikant Hawaldar · Answer

this code is compile time error where idconfiguraciones_email =" + txtid.Text; below is corrected code your missing singlequot, plus and dublequot. where idconfiguraciones_email = ' " + txtid.Text + " ' ;

Rajanikant Hawaldar · Answer

Below highlighted field not needed to update. you should know what we can update in table? you shouldn't try to update primery key or unique key.  "update configuraciones_email set  idconfiguraciones_email ='"  + txtid.Text +  "', DIRECCION_EMAIL ='"  + txtdireccion.Text +  "',USUARIO ='"  + txtusuario.Text +  "',PASSWORD ='"  + txtpassword.Text +  "',HOST ='"  + txthost.Text +  "',PUERTO ='"  + txtpuerto.Text +  "',SSL ='"  + txtssl.Text +  "',DIRECCION_RESGUARDO ='"  + txtdireccionresguardo.Text +  "' where idconfiguraciones_email ='"  + txtid.Text +  "' " ;   post table schema here if still get exception

Fernando Calabro · Answer

How are you Rajanikant? First of all I wanted to thank you very much for your answer.

Regarding my problem, I tell you that I am still the same. I tried what you recommended (which I realized you were right lol). But it didn't work for me either. When I generate the error, it takes me to the "Program.cs" tab and there it gives me the error (I attach a screenshot). I also give you how the code is to see if I did what you told me right (I had to add a quotation mark at the end, before the semicolon to close. Hopefully you can help me. Maybe it's something easy, but it's driving me crazy, and I can't find the fault. As you may have noticed, all this programming I am doing alone, with the help of good people like you who care about each other. The reality is that almost the entire program I did just looking for information on the internet, lol THANK YOU MILLIONS !!!


private void btnactualizar_Click(object sender, EventArgs e)  
      {  
          conexion_email.Open();  
          string actualizarconfiguracion = "update configuraciones_email set idconfiguraciones_email ='" + txtid.Text + "',DIRECCION_EMAIL ='" + txtdireccion.Text + "',USUARIO ='" + txtusuario.Text + "',PASSWORD ='" + txtpassword.Text + "',HOST ='" + txthost.Text + "',PUERTO ='" + txtpuerto.Text + "',SSL ='" + txtssl.Text + "',DIRECCION_RESGUARDO ='" + txtdireccionresguardo.Text + "' where idconfiguraciones_email ='" + txtid.Text + "' ";  
          MySqlCommand comando_configuracion = new MySqlCommand(actualizarconfiguracion, conexion_email);  
          comando_configuracion.ExecuteNonQuery();  
          conexion_email.Close();  
          MessageBox.Show("Configuracion Actualizada Correctamente");  
      }