private void btnAgregar_Click(object sender, EventArgs e) { MySqlCommand cmd; try { byte[] imageBt = null; FileStream fstream = new FileStream(this.txtImagenPath.Text, FileMode.Open, FileAccess.Read); BinaryReader br = new BinaryReader(fstream); imageBt = br.ReadBytes((int)fstream.Length); MySqlConnection SQL_Conexion = new MySqlConnection(); String connectionString; MySqlCommand SQL_cmd; // cmd = new MySqlCommand(SQL_cmd, SQL_Conexion); wfAdministracion wfAdmin = new wfAdministracion(); String S_cadena = "Server=192.168.1.100;UID= root; Database= bd_turnos; Password=GrupoSGT014;"; SQL_Conexion.ConnectionString = S_cadena; SQL_Conexion.Open(); //SQL_cmd = new MySqlCommand("INSERT INTO tabm_area VALUES ('" + txtNombre.Text + "',@IMG)", SQL_Conexion); SQL_cmd = new MySqlCommand("UPDATE tabm_usuario SET area_nom=\"" + txtNombre.Text + "\" WHERE id_usuario=\"" + txtIdUsuario.Text + "\"", SQL_Conexion); // SQL_cmd.Parameters.Add(new MySqlParameter("@IMG", imageBt)); SQL_cmd.ExecuteNonQuery(); SQL_Conexion.Close(); MessageBox.Show("Area Modificada exitosamente ", "Modificacion Area", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch { MessageBox.Show("Revise sus datos, ingreso no completado ", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void ayudaToolStripMenuItem_Click(object sender, EventArgs e) { wfAdministracion frmadmin = new wfAdministracion(); frmadmin.MdiParent = this; frmadmin.Show(); }
private void btnCancelar_Click(object sender, EventArgs e) { wfAdministracion Admin = new wfAdministracion(); this.Hide(); Admin.Show(); }