private void RenaPrecio() { MySqlConnection con = BDConexicon.RenaOpen(); try { double Precio1 = Convert.ToDouble(tbPrecio1.Text); double Precio2 = Convert.ToDouble(tbPrecio2.Text); Precio1 = Precio1 / 1.16; Precio2 = Precio2 / 1.16; MySqlCommand cmdoo = new MySqlCommand("UPDATE prods SET precio1=?precio1,precio2=?precio2 WHERE articulo=?articulo", con); cmdoo.Parameters.Add("?precio1", MySqlDbType.VarChar).Value = Precio1; cmdoo.Parameters.Add("?precio2", MySqlDbType.VarChar).Value = Precio2; cmdoo.Parameters.Add("?articulo", MySqlDbType.VarChar).Value = TB_articulo.Text; MySqlDataReader mdrr; mdrr = cmdoo.ExecuteReader(); mdrr.Close(); lblRePre.Text = "OK"; lblRePre.ForeColor = Color.DarkGreen; } catch (Exception e) { lblRePre.Text = "N/A"; lblRePre.ForeColor = Color.Red; } BDConexicon.RenaClose(); }