DISPLAY

27         public void loadCmb()
28         {
29             SqlConnection con = dal.GetConnect();
30             con.Open();
31             SqlCommand cm = new SqlCommand("Select *from Lop", con);
32             SqlDataAdapter da = new SqlDataAdapter(cm);
33             DataTable dt = new DataTable();
34             da.Fill(dt);
35             this.cmbMaLop.DisplayMember = "MaLop";
36             this.cmbMaLop.ValueMember = "MaLop";
37             this.cmbMaLop.DataSource = dt;
38         }

29         public void loadCmbMaNhomHP(string MaHK)
30         {
31             SqlConnection con = dal.GetConnect();
32             con.Open();
33             SqlCommand cm = new SqlCommand("Select MaNhomHP from NhomHocPhan,KeHoachGiangDay where NhomHocPhan.MaKHGD=KeHoachGiangDay.MaKHGD and KeHoachGiangDay.MaHK='"+MaHK+"'", con);
34             SqlDataAdapter da = new SqlDataAdapter(cm);
35             DataTable dt = new DataTable();
36             da.Fill(dt);
37             this.cmbMaNhomHP.DisplayMember = "MaNhomHP";
38             this.cmbMaNhomHP.ValueMember = "MaNhomHP";
39             this.cmbMaNhomHP.DataSource = dt;
40         }

27         public void loadCmbLop()
28         {
29             SqlConnection con = dal.GetConnect();
30             con.Open();
31             SqlCommand cm = new SqlCommand("Select *from Lop", con);
32             SqlDataAdapter da = new SqlDataAdapter(cm);
33             DataTable dt = new DataTable();
34             da.Fill(dt);
35             this.cmbMa.DisplayMember = "MaLop";
36             this.cmbMa.ValueMember = "MaLop";
37             this.cmbMa.DataSource = dt;
38         }

39         public void loadCmbKhoiLop()
40         {
41             SqlConnection con = dal.GetConnect();
42             con.Open();
43             SqlCommand cm = new SqlCommand("Select *from KhoiLop", con);
44             SqlDataAdapter da = new SqlDataAdapter(cm);
45             DataTable dt = new DataTable();
46             da.Fill(dt);
47             this.cmbMa.DisplayMember = "MaKhoiLop";
48             this.cmbMa.ValueMember = "MaKhoiLop";
49             this.cmbMa.DataSource = dt;
50         }

90         public void loadCmbMaHK()
91         {
92             SqlConnection con = dal.GetConnect();
93             con.Open();
94             SqlCommand cm = new SqlCommand("Select *from HocKy", con);
95             SqlDataAdapter da = new SqlDataAdapter(cm);
96             DataTable dt = new DataTable();
97             da.Fill(dt);
98             this.cmbMaHK.DisplayMember = "MaHK";
99             this.cmbMaHK.ValueMember = "MaHK";
100             this.cmbMaHK.DataSource = dt;
101         }

40         public void loadCmbMaHP()
41         {
42             SqlConnection con = dal.GetConnect();
43             con.Open();
44             SqlCommand cm = new SqlCommand("Select *from HocPhan", con);
45             SqlDataAdapter da = new SqlDataAdapter(cm);
46             DataTable dt = new DataTable();
47             da.Fill(dt);
48             this.cmbMaHP.DisplayMember = "TenHP";
49             this.cmbMaHP.ValueMember = "MaHP";
50             this.cmbMaHP.DataSource = dt;
51         }

44         public void loadCmbMaHP()
45         {
46             SqlConnection con = dal.GetConnect();
47             con.Open();
48             SqlCommand cm = new SqlCommand("Select *from HocPhan", con);
49             SqlDataAdapter da = new SqlDataAdapter(cm);
50             DataTable dt = new DataTable();
51             da.Fill(dt);
52             this.cmbMaHP.DisplayMember = "TenHP";
53             this.cmbMaHP.ValueMember = "MaHP";
54             this.cmbMaHP.DataSource = dt;
55         }

85         private void btnXuatRaExcel_Click(object sender, EventArgs e)
86         {
87             try
88             {
89
90                 Excel.Application objExcelApp = new Excel.Application();
91                 Excel.Workbook objExcelWorkbook = objExcelApp.Workbooks.Add(Excel.XlWBATemplate.xlWBATWorksheet);
92                 Excel.Worksheet objSheet = (Excel.Worksheet)objExcelWorkbook.Worksheets[1];
93                 //objSheet.Cells.Interior.Color.ToString() = 'blue';
94                 objSheet = (Excel.Worksheet)objExcelWorkbook.Sheets[1];
95                 objSheet.Cells.HorizontalAlignment = Excel.Constants.xlCenter;
96                 objSheet.Cells[2, 5] = "BẢNG ĐIỂM CỦA SINH VIÊN";
97                 objSheet.Cells[5, 3] = "Mã Học Phần";
98                 objSheet.Cells[5, 4] = "Mã Nhóm Học Phần";
99                 objSheet.Cells[5, 5] = "Tên Học Phần";
100                 objSheet.Cells[5, 6] = "Điểm Thi";
101                 objSheet.Cells[5, 7] = "Điểm Quá Trình";
102                 objSheet.Cells[5, 8] = "Điểm Xếp Loại";
103                 objSheet.Cells[3, 3] = "Mã Học Kỳ : "+cmbMaHK.SelectedValue.ToString()+"";
104                 objSheet.Cells[4, 3] = "Mã SV : " + txtMaSV.Text + "";
105                 objSheet.Cells[9,10] = "ĐIỂM TỔNG KẾT";
106                 objSheet.Cells[10,10] = "Hệ 10 : "+txtHe10.Text+"";
107                 objSheet.Cells[11,10] = "Hệ 4 : "+txtHe4.Text+"";
108                 for (int i = 0; i < dgvKetQua.Rows.Count ; i++)
109                 {
110                     for (int j = 0; j < dgvKetQua.Columns.GetColumnCount(DataGridViewElementStates.Displayed); j++)
111                     {
112                         objSheet.Cells[i + 6, j + 3] = dgvKetQua.Rows[i].Cells[j].Value.ToString();
113                         objSheet.Columns.AutoFit();
114                     }
115                 }
116                 objExcelApp.Visible = true;
117             }
118             catch (Exception ex)
119             {
120                 MessageBox.Show(ex.Message);
121             }
122         }

24         public void loadCmbMaLop()
25         {
26             SqlConnection con = dal.GetConnect();
27             con.Open();
28             SqlCommand cm = new SqlCommand("Select *from Lop", con);
29             SqlDataAdapter da = new SqlDataAdapter(cm);
30             DataTable dt = new DataTable();
31             da.Fill(dt);
32             this.cmbMaLop.DisplayMember = "MaLop";
33             this.cmbMaLop.ValueMember = "MaLop";
34             this.cmbMaLop.DataSource = dt;
35         }

36         public void loadCmbMaHK()
37         {
38             SqlConnection con = dal.GetConnect();
39             con.Open();
40             SqlCommand cm = new SqlCommand("Select *from HocKy", con);
41             SqlDataAdapter da = new SqlDataAdapter(cm);
42             DataTable dt = new DataTable();
43             da.Fill(dt);
44             this.cmbMaHK.DisplayMember = "MaHK";
45             this.cmbMaHK.ValueMember = "MaHK";
46             this.cmbMaHK.DataSource = dt;
47         }