private void VerCalificacionesForm_Load(object sender, EventArgs e) { DataBaseControl DBControl = new DataBaseControl(DataBaseControl.cPath, "ProjectDataBase.mdf"); BindingSource CalSource = new BindingSource(); CalSource.DataSource = DBControl.ObtenerTabla("Select * from Calificaciones"); DGVCalificacion.DataSource = CalSource; DGVCalificacion.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; DGVCalificacion.ReadOnly = true; }
private void VerAlumnosForm_Load_1(object sender, EventArgs e) { DataBaseControl DBControl = new DataBaseControl(DataBaseControl.cPath, "ProjectDataBase.mdf"); BindingSource AlumnSource = new BindingSource(); AlumnSource.DataSource = DBControl.ObtenerTabla("Select * from Alumnos"); DGVAlumno.DataSource = AlumnSource; DGVAlumno.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; DGVAlumno.ReadOnly = true; }
private void VerMateriasForm_Load(object sender, EventArgs e) { DataBaseControl DBControl = new DataBaseControl(DataBaseControl.cPath, "ProjectDataBase.mdf"); BindingSource MatSource = new BindingSource(); MatSource.DataSource = DBControl.ObtenerTabla("Select * from Materias"); DGVMaterias.DataSource = MatSource; DGVMaterias.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; DGVMaterias.ReadOnly = true; }
private void TxtBuscar_TextChanged(object sender, EventArgs e) { DataBaseControl DBControl = new DataBaseControl(DataBaseControl.cPath, "ProjectDataBase.mdf"); BindingSource AlmSource = new BindingSource(); string[] parameters = { "@word" }; string[] value = { TxtBuscar.Text }; AlmSource.DataSource = DBControl.ObtenerTabla("Select * from Alumnos where [Nombre] like '%'+@word+'%' or [ID] like '%'+@word+'%' ", parameters, value); DGVAlumnos.DataSource = AlmSource; DGVAlumnos.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; DGVAlumnos.ReadOnly = true; }