コード例 #1
0
ファイル: alumnos.cs プロジェクト: Rasec19/Linq_SQL_Escuela
        private void btnActualizar_Click(object sender, EventArgs e)
        {
            int    id   = Convert.ToInt32(dgAlumno.CurrentRow.Cells[0].Value);
            string name = txtNombre.Text;

            cbCarrera.ValueMember = "ID_Carrera";
            int carr = Convert.ToInt32(cbCarrera.SelectedValue);

            btnActualizar.Enabled = false;
            btnEliminar.Enabled   = false;
            btnCancelar.Enabled   = false;
            btnAgregar.Enabled    = true;

            txtNombre.Enabled = false;
            cbCarrera.Enabled = false;


            if (MessageBox.Show("¿Desea cambiar los datos " + dgAlumno.CurrentRow.Cells[1].Value.ToString() + "?", "Cambio", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
            {
                try
                {
                    alumnos_Query a = new alumnos_Query();
                    a.Actualizar(id, name, carr);
                    dgAlumno.DataSource = null;

                    txtNombre.Text = "";
                    cbCarrera.Text = "";
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }
        }
コード例 #2
0
ファイル: alumnos.cs プロジェクト: Rasec19/Linq_SQL_Escuela
        private void btnEliminar_Click(object sender, EventArgs e)
        {
            btnActualizar.Enabled = false;
            btnEliminar.Enabled   = false;
            btnCancelar.Enabled   = false;
            btnAgregar.Enabled    = true;

            txtNombre.Enabled = false;
            cbCarrera.Enabled = false;
            cbCarrera.Text    = "";
            txtNombre.Text    = "";

            if (MessageBox.Show("¿Desea Eliminar al alumno " + dgAlumno.CurrentRow.Cells[1].Value.ToString() + "?", "Eliminar alumno", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
            {
                int id = Convert.ToInt32(dgAlumno.CurrentRow.Cells[0].Value);
                try
                {
                    alumnos_Query a = new alumnos_Query();
                    a.Eliminar(id);
                    dgAlumno.DataSource = null;
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }
        }
コード例 #3
0
ファイル: alumnos.cs プロジェクト: Rasec19/Linq_SQL_Escuela
        private void btnGuardar_Click(object sender, EventArgs e)
        {
            string name = txtNombre.Text;

            cbCarrera.ValueMember = "ID_Carrera";
            int carr = Convert.ToInt32(cbCarrera.SelectedValue);

            try
            {
                alumnos_Query a = new alumnos_Query();
                a.GuardarAlumno(name, carr);

                txtNombre.Text    = "";
                txtNombre.Enabled = false;
                cbCarrera.Text    = "";
                cbCarrera.Enabled = false;

                btnGuardar.Enabled  = false;
                btnCancelar.Enabled = false;
                btnAgregar.Enabled  = true;
                dgAlumno.DataSource = null;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }