ROWS
How do I use R O W S
Below are practical examples compiled from projects for learning and reference purposes
Featured Snippets
File name: ClassBLL.cs
Copy
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 }
File name: ClassBLL.cs
Copy
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 }
File name: FormGiangVien.cs
Copy
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 }
File name: FormHeDaoTao.cs
Copy
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 }
File name: FormHocKy.cs
Copy
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 }
File name: FormHocPhan.cs
Copy
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 }
File name: FormKHGD.cs
Copy
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 }
File name: FormKhoiLop.cs
Copy
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 }
File name: FormLop.cs
Copy
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 }
File name: FormNhomHocPhan.cs
Copy
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 }
ROWS 109 lượt xem
Gõ tìm kiếm nhanh...