/// <summary> /// Load the details from Exams table from sql to new grid /// by the parameters: ID, Course Name, Start Time, End Time, Classes, Supervisors, Students enrolled and date /// in adittion design the grid by color blue</summary> private void Students_List_Load() { //Create Columns Students_List.Columns.Add("ID", "ID"); Students_List.Columns.Add("Easement", "Easement"); //Exams_Grid.Columns.Add("Date", "Date"); //Create check box column DataGridViewCheckBoxColumn column = new DataGridViewCheckBoxColumn(); { column.HeaderText = "Check"; column.Name = "check"; column.AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells; column.FlatStyle = FlatStyle.Standard; column.ThreeState = false; column.IndeterminateValue = false; column.CellTemplate = new DataGridViewCheckBoxCell(); } Students_List.Columns.Insert(Students_List.Columns.Count, column); //Paint headers Students_List.EnableHeadersVisualStyles = false; Students_List.GridColor = Color.White; Students_List.ColumnHeadersDefaultCellStyle.BackColor = Utility.HeaderBackColor; Students_List.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; Students_List.AutoResizeColumns(); Students_List.AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.Fill; Students_List.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; }
private void Students_List_Reload() { context = new Entities(); foreach (student s in context.students) { if (studentInCourse(s.ID, getCourseId(Combo_Course_name.Text.Substring(0, Combo_Course_name.Text.Length - 7)))) { Students_List.Rows.Add(s.ID, s.ExtraTime || s.FormulaSheet || s.Laptop); } } Students_List.Refresh(); }