private void PictureBox3_Click(object sender, EventArgs e) { try { if (txtc.Text.Trim() != "" && txtn.Text.Trim() != "" && txta.Text.Trim() != "" && txtce.Text.Trim() != "" && txtu.Text.Trim() != "" && txtcl.Text.Trim() != "") { Conection.Conectar(); string eliminar = "DELETE FROM Administradores WHERE Codigo_administrador=@c"; SqlCommand cmd3 = new SqlCommand(eliminar, Conection.Conectar()); cmd3.Parameters.AddWithValue("@c", txtc.Text); cmd3.ExecuteNonQuery(); MessageBox.Show("Registro eliminado", "HECHO", MessageBoxButtons.OK, MessageBoxIcon.Information); limpiar(); dgv.DataSource = llenar_grid(); } else { MessageBox.Show("Campos Vacios", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception error) { MessageBox.Show("Algo salio mal", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void PictureBox1_Click(object sender, EventArgs e) { try { if (txtc.Text.Trim() != "" && txtn.Text.Trim() != "" && cmb1.Text.Trim() != "" && cmb2.Text.Trim() != "") { Conection.Conectar(); string insertar = "INSERT INTO Grados(Codigo_grado, Nombre_grado, Codigo_maestro, Carnet) VALUES (@c, @n, @m, @a)"; SqlCommand cmd1 = new SqlCommand(insertar, Conection.Conectar()); cmd1.Parameters.AddWithValue("@c", txtc.Text); cmd1.Parameters.AddWithValue("@n", txtn.Text); cmd1.Parameters.AddWithValue("@m", cmb1.Text); cmd1.Parameters.AddWithValue("@a", cmb2.Text); cmd1.ExecuteNonQuery(); MessageBox.Show("Registro agregado", "HECHO", MessageBoxButtons.OK, MessageBoxIcon.Information); limpiar(); dgv.DataSource = llenar_grid(); } else { MessageBox.Show("Campos Vacios", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception error) { MessageBox.Show("Algo salio mal", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void PictureBox2_Click(object sender, EventArgs e) { try { if (txtc.Text.Trim() != "" && txtn.Text.Trim() != "" && txta.Text.Trim() != "" && txtce.Text.Trim() != "" && txtu.Text.Trim() != "" && txtcl.Text.Trim() != "") { Conection.Conectar(); string actualizar = "UPDATE Administradores SET Codigo_administrador=@c, Nombre_administrador=@n, Apellido_administrador=@a, Correo_administrador=@ce, Alias_administrador=@u, Clave_administrador=@cl WHERE Codigo_administrador=@c"; SqlCommand cmd2 = new SqlCommand(actualizar, Conection.Conectar()); cmd2.Parameters.AddWithValue("@c", txtc.Text); cmd2.Parameters.AddWithValue("@n", txtn.Text); cmd2.Parameters.AddWithValue("@a", txta.Text); cmd2.Parameters.AddWithValue("@ce", txtce.Text); cmd2.Parameters.AddWithValue("@u", txtu.Text); cmd2.Parameters.AddWithValue("@cl", txtcl.Text); cmd2.ExecuteNonQuery(); MessageBox.Show("Registro modificdo", "HECHO", MessageBoxButtons.OK, MessageBoxIcon.Information); limpiar(); dgv.DataSource = llenar_grid(); } else { MessageBox.Show("Campos Vacios", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception error) { MessageBox.Show("Algo salio mal", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void PictureBox2_Click(object sender, EventArgs e) { try { if (txtc.Text.Trim() != "" && txtn.Text.Trim() != "" && cmb1.Text.Trim() != "" && cmb2.Text.Trim() != "") { Conection.Conectar(); string actualizar = "UPDATE Grados SET Codigo_grado=@c, Nombre_grado=@n, Codigo_maestro=@m, Carnet=@a WHERE Codigo_grado=@c"; SqlCommand cmd2 = new SqlCommand(actualizar, Conection.Conectar()); cmd2.Parameters.AddWithValue("@c", txtc.Text); cmd2.Parameters.AddWithValue("@n", txtn.Text); cmd2.Parameters.AddWithValue("@m", cmb1.Text); cmd2.Parameters.AddWithValue("@a", cmb2.Text); cmd2.ExecuteNonQuery(); MessageBox.Show("Registro modificdo", "HECHO", MessageBoxButtons.OK, MessageBoxIcon.Information); limpiar(); dgv.DataSource = llenar_grid(); } else { MessageBox.Show("Campos Vacios", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception error) { MessageBox.Show("Algo salio mal", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void PictureBox1_Click(object sender, EventArgs e) { try { if (txtc.Text.Trim() != "" && txtn.Text.Trim() != "" && txta.Text.Trim() != "" && dtp.Text.Trim() != "") { Conection.Conectar(); string insertar = "INSERT INTO Alumnos(Carnet, Nombre_alumno, Apellido_alumno, Fecha_nacimineto) VALUES (@c, @n, @a, @f)"; SqlCommand cmd1 = new SqlCommand(insertar, Conection.Conectar()); cmd1.Parameters.AddWithValue("@c", txtc.Text); cmd1.Parameters.AddWithValue("@n", txtn.Text); cmd1.Parameters.AddWithValue("@a", txta.Text); cmd1.Parameters.Add(new SqlParameter("@f", SqlDbType.Date)); cmd1.Parameters["@f"].Value = dtp.Text; cmd1.ExecuteNonQuery(); MessageBox.Show("Registro agregado", "HECHO", MessageBoxButtons.OK, MessageBoxIcon.Information); limpiar(); dgv.DataSource = llenar_grid(); } else { MessageBox.Show("Campos Vacios", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception error) { MessageBox.Show("Algo salio mal", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void PictureBox2_Click(object sender, EventArgs e) { try { if (txtc.Text.Trim() != "" && txtn.Text.Trim() != "" && txta.Text.Trim() != "" && dtp.Text.Trim() != "") { Conection.Conectar(); string actualizar = "UPDATE Alumnos SET Carnet=@c, Nombre_alumno=@n, Apellido_alumno=@a, Fecha_nacimineto=@f WHERE Carnet=@c"; SqlCommand cmd2 = new SqlCommand(actualizar, Conection.Conectar()); cmd2.Parameters.AddWithValue("@c", txtc.Text); cmd2.Parameters.AddWithValue("@n", txtn.Text); cmd2.Parameters.AddWithValue("@a", txta.Text); cmd2.Parameters.Add(new SqlParameter("@f", SqlDbType.Date)); cmd2.Parameters["@f"].Value = dtp.Text; cmd2.ExecuteNonQuery(); MessageBox.Show("Registro modificdo", "HECHO", MessageBoxButtons.OK, MessageBoxIcon.Information); limpiar(); dgv.DataSource = llenar_grid(); } else { MessageBox.Show("Campos Vacios", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception error) { MessageBox.Show("Algo salio mal", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void PictureBox1_Click(object sender, EventArgs e) { try { if (txtc.Text.Trim() != "" && dtp.Text.Trim() != "" && cmb1.Text.Trim() != "" && cmb3.Text.Trim() != "" && cmb4.Text.Trim() != "") { Conection.Conectar(); string insertar = "INSERT INTO Asistencias(Codigo_asistencia, Fecha_asistencia, Codigo_grado, Carnet, Control_asistencia) VALUES (@c, @f, @g, @a, @ca)"; SqlCommand cmd1 = new SqlCommand(insertar, Conection.Conectar()); cmd1.Parameters.AddWithValue("@c", txtc.Text); cmd1.Parameters.Add(new SqlParameter("@f", SqlDbType.Date)); cmd1.Parameters["@f"].Value = dtp.Text; cmd1.Parameters.AddWithValue("@g", cmb1.Text); cmd1.Parameters.AddWithValue("@a", cmb3.Text); cmd1.Parameters.AddWithValue("@ca", cmb4.Text); cmd1.ExecuteNonQuery(); MessageBox.Show("Registro agregado", "HECHO", MessageBoxButtons.OK, MessageBoxIcon.Information); limpiar(); dgv.DataSource = llenar_grid(); } else { MessageBox.Show("Campos Vacios", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception error) { MessageBox.Show("Algo salio mal", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void PictureBox2_Click(object sender, EventArgs e) { try { if (txtc.Text.Trim() != "" && dtp.Text.Trim() != "" && cmb1.Text.Trim() != "" && cmb3.Text.Trim() != "" && cmb4.Text.Trim() != "") { Conection.Conectar(); string actualizar = "UPDATE Asistencias SET Codigo_asistencia=@c, Fecha_asistencia=@f, Codigo_grado=@g, Carnet=@a, Control_asistencia=@ca WHERE Codigo_asistencia=@c"; SqlCommand cmd2 = new SqlCommand(actualizar, Conection.Conectar()); cmd2.Parameters.AddWithValue("@c", txtc.Text); cmd2.Parameters.Add(new SqlParameter("@f", SqlDbType.Date)); cmd2.Parameters["@f"].Value = dtp.Text; cmd2.Parameters.AddWithValue("@g", cmb1.Text); cmd2.Parameters.AddWithValue("@a", cmb3.Text); cmd2.Parameters.AddWithValue("@ca", cmb4.Text); cmd2.ExecuteNonQuery(); MessageBox.Show("Registro modificdo", "HECHO", MessageBoxButtons.OK, MessageBoxIcon.Information); limpiar(); dgv.DataSource = llenar_grid(); } else { MessageBox.Show("Campos Vacios", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception error) { MessageBox.Show("Algo salio mal", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public DataTable llenar_grid() { Conection.Conectar(); DataTable dt = new DataTable(); string Consulta = "SELECT * FROM Administradores"; SqlCommand cmd = new SqlCommand(Consulta, Conection.Conectar()); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); return(dt); }
private void PictureBox1_Click(object sender, EventArgs e) { try { if (txtc.Text.Trim() != "" && txtn.Text.Trim() != "" && txta.Text.Trim() != "" && txtce.Text.Trim() != "" && txtu.Text.Trim() != "" && txtcl.Text.Trim() != "") { if (email_bien_escrito(txtce.Text)) { Conection.Conectar(); string insertar = "INSERT INTO Administradores(Codigo_administrador, Nombre_administrador, Apellido_administrador, Correo_administrador, Alias_administrador, Clave_administrador) VALUES (@c, @n, @a, @ce, @u, @cl)"; SqlCommand cmd1 = new SqlCommand(insertar, Conection.Conectar()); cmd1.Parameters.AddWithValue("@c", txtc.Text); cmd1.Parameters.AddWithValue("@n", txtn.Text); cmd1.Parameters.AddWithValue("@a", txta.Text); cmd1.Parameters.AddWithValue("@ce", txtce.Text); cmd1.Parameters.AddWithValue("@u", txtu.Text); cmd1.Parameters.AddWithValue("@cl", txtcl.Text); cmd1.ExecuteNonQuery(); MessageBox.Show("Registro agregado", "HECHO", MessageBoxButtons.OK, MessageBoxIcon.Information); limpiar(); dgv.DataSource = llenar_grid(); } else { MessageBox.Show("Ingrese un correo electronico valido", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Campos Vacios", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception error) { MessageBox.Show("Algo salio mal", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); } }