private void ViewScore_Click(object sender, EventArgs e) { NotiLabel.Text = ""; EditButton.Enabled = true; Classes.Enabled = true; Subjects.Enabled = true; listViewInfo = ListViewInfo.Scoreboard; _Id.Text = "Student ID"; _Id.Width = 110; _Name.Text = "Student name"; _Name.Width = 190; _Info1.Text = "Class"; _Info1.Width = 90; _Info2.Text = "Subject ID"; _Info2.Width = 110; _Info3.Text = "Mid-term"; _Info3.Width = 80; _Info4.Text = "Final-term"; _Info4.Width = 80; _Info5.Text = "Other score"; _Info5.Width = 80; _Info6.Text = "Final score"; _Info6.Width = 80; _Info7.Text = "Pass"; _Info7.Width = 60; listView.Items.Clear(); listView.Columns.Clear(); listView.Columns.AddRange(new System.Windows.Forms.ColumnHeader[] { _No, _Id, _Name, _Info1, _Info2, _Info3, _Info4, _Info5, _Info6, _Info7 }); try { StudentServices service = new StudentServices(); var Data = service.GetScoreboardFromDB(Classes.SelectedItem.ToString(), Subjects.SelectedItem.ToString()); int pass = 0; foreach (var data in Data) { if (data.Info[6] == "Yes") { pass++; } } BindDataToListView(Data); if (Classes.SelectedItem.ToString() != "All" && Subjects.SelectedItem.ToString() != "All") { NotiLabel.Text = $"There are {pass} student(s) ({((float) pass / (float) Data.Count).ToString("p")}) " + $"of class {Classes.SelectedItem.ToString()} passed this subject."; } } catch (Exception ex) { MessageBox.Show(ex.Message); } if (listView.Items.Count == 0) { NotiLabel.Text = "Nothing is found..."; } listView.View = View.Details; }