public void HienThiDataGridViewComboBoxColumn(DataGridViewComboBoxColumn cmbColumn) { cmbColumn.DataSource = m_HocKyData.LayDsHocKy(); cmbColumn.DisplayMember = "TenHocKy"; cmbColumn.ValueMember = "MaHocKy"; cmbColumn.DataPropertyName = "MaHocKy"; cmbColumn.HeaderText = "Học kỳ"; }
public void HienThiComboBox(ComboBoxEx comboBox) { HocKyData m_HKData = new HocKyData(); comboBox.DataSource = m_HKData.LayDsHocKy(); comboBox.DisplayMember = "TenHocKy"; comboBox.ValueMember = "MaHocKy"; }
public float DiemTrungBinhMonCaNam(String maHocSinh, String maMonHoc, String maNamHoc, String maLop) { DataTable m_DT = new DataTable(); m_DT = m_HocKyData.LayDsHocKy(); float tongDiem = 0; int tongHeSo = 0; foreach (DataRow row in m_DT.Rows) { tongDiem += DiemTrungBinhMonHocKy(maHocSinh, maMonHoc, row["MaHocKy"].ToString(), maNamHoc, maLop) * Convert.ToInt32(row["HeSo"].ToString()); tongHeSo += Convert.ToInt32(row["HeSo"].ToString()); } if (tongHeSo > 0) { return(tongDiem / tongHeSo); } else { return(0); } }