private void gridStudents_CellValueChanged(object sender, DataGridViewCellEventArgs e) { DataGridViewRow row = gridStudents.SelectedRows[0]; int studentId = Convert.ToInt32(row.Cells["StudentId"].Value); int year = Convert.ToInt32(row.Cells["StudyYear"].Value); String name = row.Cells["StudentName"].Value.ToString(); String surname = row.Cells["StudentSurname"].Value.ToString(); String group = row.Cells["StudyGroup"].Value.ToString(); String set = row.Cells["StudySet"].Value.ToString(); BLAdmin bl = new BLAdmin(); bl.UpdateStudent(studentId, name, surname, year, group, set); gridStudents.Rows.Clear(); gridStudents.Columns.Clear(); List <StudentsModel> studentsModels = bl.GetStudents(txtNameFilter.Text, txtSurnameFilter.Text, txtGroupFilter.Text); gridStudents.Columns.Add("StudentId", "StudentId"); gridStudents.Columns.Add("StudentName", "Nume"); gridStudents.Columns.Add("StudentSurname", "Prenume"); gridStudents.Columns.Add("StudyYear", "An"); gridStudents.Columns.Add("StudyGroup", "Grupa"); gridStudents.Columns.Add("StudySet", "Seria"); gridStudents.Columns[0].Visible = false; foreach (StudentsModel student in studentsModels) { gridStudents.Rows.Add(student.StudentId, student.StudentName, student.StudentSurname, student.StudyYear, student.StudyGroup, student.StudySet); } }
private void EditStudentsForm_Load(object sender, EventArgs e) { gridStudents.BorderStyle = BorderStyle.None; gridStudents.AlternatingRowsDefaultCellStyle.BackColor = Color.FromArgb(168, 218, 220); gridStudents.CellBorderStyle = DataGridViewCellBorderStyle.SingleHorizontal; gridStudents.DefaultCellStyle.SelectionBackColor = Color.FromArgb(29, 53, 87); gridStudents.DefaultCellStyle.SelectionForeColor = Color.WhiteSmoke; gridStudents.BackgroundColor = Color.FromArgb(3, 56, 125); gridStudents.DefaultCellStyle.BackColor = Color.FromArgb(241, 250, 238); gridStudents.DefaultCellStyle.Font = new Font("Microsoft Tai Le", 10); gridStudents.AlternatingRowsDefaultCellStyle.Font = new Font("Microsoft Tai Le", 10); gridStudents.ColumnHeadersDefaultCellStyle.Font = new Font("Microsoft Tai Le", 11); gridStudents.EnableHeadersVisualStyles = false; gridStudents.ColumnHeadersBorderStyle = DataGridViewHeaderBorderStyle.None; gridStudents.ColumnHeadersDefaultCellStyle.BackColor = Color.FromArgb(20, 25, 72); gridStudents.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; gridStudents.RowHeadersDefaultCellStyle.BackColor = Color.FromArgb(241, 250, 238); BLAdmin bl = new BLAdmin(); List <StudentsModel> studentsModels = bl.GetStudents("", "", ""); gridStudents.Columns.Add("StudentId", "StudentId"); gridStudents.Columns.Add("StudentName", "Nume"); gridStudents.Columns.Add("StudentSurname", "Prenume"); gridStudents.Columns.Add("StudyYear", "An"); gridStudents.Columns.Add("StudyGroup", "Grupa"); gridStudents.Columns.Add("StudySet", "Seria"); gridStudents.Columns[0].Visible = false; foreach (StudentsModel student in studentsModels) { gridStudents.Rows.Add(student.StudentId, student.StudentName, student.StudentSurname, student.StudyYear, student.StudyGroup, student.StudySet); } gridStudents.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; }
private void txtNameFilter_TextChanged(object sender, EventArgs e) { BLAdmin bl = new BLAdmin(); gridStudents.Rows.Clear(); gridStudents.Columns.Clear(); List <StudentsModel> studentsModels = bl.GetStudents(txtNameFilter.Text, txtSurnameFilter.Text, txtGroupFilter.Text); gridStudents.Columns.Add("StudentId", "StudentId"); gridStudents.Columns.Add("StudentName", "Nume"); gridStudents.Columns.Add("StudentSurname", "Prenume"); gridStudents.Columns.Add("StudyYear", "An"); gridStudents.Columns.Add("StudyGroup", "Grupa"); gridStudents.Columns.Add("StudySet", "Seria"); gridStudents.Columns[0].Visible = false; foreach (StudentsModel student in studentsModels) { gridStudents.Rows.Add(student.StudentId, student.StudentName, student.StudentSurname, student.StudyYear, student.StudyGroup, student.StudySet); } }