Row

15         public void ChuanBi3Table(string MaHK)
16         {
17             //Table 1
18             string sql1 = " select MaSV,'sotinchi'=sum(SoTC) " +
19                        " from KetQua kq,HocPhan hp,NhomHocPhan nhp,KeHoachGiangDay khgd " +
20                        " where kq.MaNhomHP=nhp.MaNhomHP and nhp.MaHP=hp.MaHP and khgd.MaKHGD=nhp.MaKHGD and MaHK='" + MaHK + "' " +
21                        " group by MaSV ";
22             DataTable dt1 = da.GetTable(sql1);
23             for (int i = 0; i < dt1.Rows.Count; i++)
24             {
25                 string sql_1 = "Insert into Loptc values('" + dt1.Rows[i][0] + "'," + dt1.Rows[i][1] + ")";
26                 da.ExcuteNonQuery(sql_1);
27             }
28             //Table 2
29             string sql2 = "select MaSV,'cuoiky'=sum(DiemTk10*SoTC) " +
30                            " from KetQua kq,NhomHocPhan nhp,HocPhan hp,KeHoachGiangDay khdt " +
31                            " where kq.MaNhomHP=nhp.MaNhomHP and nhp.MaHP=hp.MaHP and khdt.MaKHGD=nhp.MaKHGD and MaHK='" + MaHK + "' " +
32                            " group by MaSV ";
33             DataTable dt2 = da.GetTable(sql2);
34             for (int i = 0; i < dt2.Rows.Count; i++)
35             {
36                 string sql_2 = "Insert into Lopdiem10 values('" + dt2.Rows[i][0] + "'," + dt2.Rows[i][1] + ")";
37                 da.ExcuteNonQuery(sql_2);
38             }
39             //Table 3
40             string sql3 = " select Lopdiem10.MaSV,'TrungBinhCuoiKyHe10'=cuoiky/sotinchi " +
41                            " from Lopdiem10 left join Loptc on Loptc.MaSV=Lopdiem10.MaSV";
42             DataTable dt3 = da.GetTable(sql3);
43             for (int i = 0; i < dt3.Rows.Count; i++)
44             {
45                 string sql_3 = "Insert into DTB values('" + dt3.Rows[i][0] + "'," + dt3.Rows[i][1] + ")";
46                 da.ExcuteNonQuery(sql_3);
47             }
48         }

49         public void ChuanBi3Table()
50         {
51             //Table 1
52             string sql1 = " select MaSV,'sotinchi'=sum(SoTC) " +
53                        " from KetQua kq,HocPhan hp,NhomHocPhan nhp,KeHoachGiangDay khgd " +
54                        " where kq.MaNhomHP=nhp.MaNhomHP and nhp.MaHP=hp.MaHP and khgd.MaKHGD=nhp.MaKHGD " +
55                        " group by MaSV ";
56             DataTable dt1 = da.GetTable(sql1);
57             for (int i = 0; i < dt1.Rows.Count; i++)
58             {
59                 string sql_1 = "Insert into Loptc values('" + dt1.Rows[i][0] + "'," + dt1.Rows[i][1] + ")";
60                 da.ExcuteNonQuery(sql_1);
61             }
62             //Table 2
63             string sql2 = "select MaSV,'cuoiky'=sum(DiemTk10*SoTC) " +
64                            " from KetQua kq,NhomHocPhan nhp,HocPhan hp,KeHoachGiangDay khdt " +
65                            " where kq.MaNhomHP=nhp.MaNhomHP and nhp.MaHP=hp.MaHP and khdt.MaKHGD=nhp.MaKHGD " +
66                            " group by MaSV ";
67             DataTable dt2 = da.GetTable(sql2);
68             for (int i = 0; i < dt2.Rows.Count; i++)
69             {
70                 string sql_2 = "Insert into Lopdiem10 values('" + dt2.Rows[i][0] + "'," + dt2.Rows[i][1] + ")";
71                 da.ExcuteNonQuery(sql_2);
72             }
73             //Table 3
74             string sql3 = " select Lopdiem10.MaSV,'TrungBinhCuoiKyHe10'=cuoiky/sotinchi " +
75                            " from Lopdiem10 left join Loptc on Loptc.MaSV=Lopdiem10.MaSV";
76             DataTable dt3 = da.GetTable(sql3);
77             for (int i = 0; i < dt3.Rows.Count; i++)
78             {
79                 string sql_3 = "Insert into DTB values('" + dt3.Rows[i][0] + "'," + dt3.Rows[i][1] + ")";
80                 da.ExcuteNonQuery(sql_3);
81             }
82         }

31         private void dgvGiangVien_RowEnter(object sender, DataGridViewCellEventArgs e)
32         {
33             dong = e.RowIndex;
34             txtMaGV.Text = dgvGiangVien.Rows[dong].Cells[0].Value.ToString();
35             txtTenGV.Text = dgvGiangVien.Rows[dong].Cells[1].Value.ToString();
36             dtpNamSinh.Text = dgvGiangVien.Rows[dong].Cells[2].Value.ToString();
37             txtDiaChi.Text = dgvGiangVien.Rows[dong].Cells[3].Value.ToString();
38         }

30         private void dgvHeDaoTao_RowEnter(object sender, DataGridViewCellEventArgs e)
31         {
32             dong = e.RowIndex;
33             txtMaHeDT.Text = dgvHeDaoTao.Rows[dong].Cells[0].Value.ToString();
34             txtTenHeDT.Text = dgvHeDaoTao.Rows[dong].Cells[1].Value.ToString();
35         }

30         private void dgvHocKy_RowEnter(object sender, DataGridViewCellEventArgs e)
31         {
32             dong = e.RowIndex;
33             txtMaHocKy.Text = dgvHocKy.Rows[dong].Cells[0].Value.ToString();
34             txtTenHocKy.Text = dgvHocKy.Rows[dong].Cells[1].Value.ToString();
35             txtNamHoc.Text = dgvHocKy.Rows[dong].Cells[2].Value.ToString();
36             dtpBatDau.Text = dgvHocKy.Rows[dong].Cells[3].Value.ToString();
37             dtpKetThuc.Text = dgvHocKy.Rows[dong].Cells[4].Value.ToString();
38         }

65         private void dgvHocPhan_RowEnter(object sender, DataGridViewCellEventArgs e)
66         {
67             dong = e.RowIndex;
68             txtMaHP.Text = dgvHocPhan.Rows[dong].Cells[0].Value.ToString();
69             txtTenHP.Text = dgvHocPhan.Rows[dong].Cells[1].Value.ToString();
70             txtSoTC.Text = dgvHocPhan.Rows[dong].Cells[2].Value.ToString();
71             txtSoTietTH.Text=dgvHocPhan.Rows[dong].Cells[3].Value.ToString();
72             txtSoTietLT.Text = dgvHocPhan.Rows[dong].Cells[4].Value.ToString();
73             txtPhanTramDQT.Text = dgvHocPhan.Rows[dong].Cells[5].Value.ToString();
74             txtPhanTramDT.Text = dgvHocPhan.Rows[dong].Cells[6].Value.ToString();
75         }

70         private void dgvKHGD_RowEnter(object sender, DataGridViewCellEventArgs e)
71         {
72             dong = e.RowIndex;
73             txtMaKHGD.Text = dgvKHGD.Rows[dong].Cells[0].Value.ToString();
74             cmbMahocKy.SelectedValue = dgvKHGD.Rows[dong].Cells[1].Value.ToString();
75             cmbMaKhoiLop.SelectedValue = dgvKHGD.Rows[dong].Cells[2].Value.ToString();
76         }

34         private void dgvKhoiLop_RowEnter(object sender, DataGridViewCellEventArgs e)
35         {
36             dong = e.RowIndex;
37             txtMaKhoiLop.Text = dgvKhoiLop.Rows[dong].Cells[0].Value.ToString();
38             txtTenKhoiLop.Text = dgvKhoiLop.Rows[dong].Cells[1].Value.ToString();
39             cmbMaHeDT.SelectedValue = dgvKhoiLop.Rows[dong].Cells[2].Value.ToString();
40             cmbMaTDDT.SelectedValue = dgvKhoiLop.Rows[dong].Cells[3].Value.ToString();
41         }

30         private void dataGridView1_RowEnter(object sender, DataGridViewCellEventArgs e)
31         {
32             dong = e.RowIndex;
33             txtMaLop.Text=dgvLop.Rows[dong].Cells[0].Value.ToString();
34             txtTenLop.Text = dgvLop.Rows[dong].Cells[1].Value.ToString();
35             cmbMaKhoiLop.SelectedValue = dgvLop.Rows[dong].Cells[2].Value.ToString();
36             cmbMaGV.SelectedValue = dgvLop.Rows[dong].Cells[3].Value.ToString();
37         }

31         private void dgvNhomHocPhan_RowEnter(object sender, DataGridViewCellEventArgs e)
32         {
33             dong = e.RowIndex;
34             txtMaNhomHP.Text = dgvNhomHocPhan.Rows[dong].Cells[0].Value.ToString();
35             txtTenNhomHP.Text = dgvNhomHocPhan.Rows[dong].Cells[1].Value.ToString();
36             cmbMaHP.SelectedValue = dgvNhomHocPhan.Rows[dong].Cells[2].Value.ToString();
37             cmbMaKHGD.SelectedValue = dgvNhomHocPhan.Rows[dong].Cells[3].Value.ToString();
38             cmbMaGV.SelectedValue = dgvNhomHocPhan.Rows[dong].Cells[4].Value.ToString();
39         }