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();
}