Clear

140         private void LoadDataToListView()
141         {
142
143             sqlcmd = new SqlCommand("select cauhoi.mach,cauhoi,a,b,c,d,dapan from cauhoi,dapan where dapan.mach = cauhoi.mach and trinhdo = '" + g_sCapDo + "'", sqlcon);
144             SqlDataReader sqlreader = sqlcmd.ExecuteReader();
145             listView1.Items.Clear();
146             while (sqlreader.Read())
147             {
148                 ListViewItem lvitem = new ListViewItem();
149                 //lvitem.Text = sqlreader["MaCH"].ToString();
150                 //lvitem.SubItems.Add(sqlreader["cauhoi"].ToString());
151
152                 //string sMaCH = sqlreader["mach"].ToString();
153
154                 lvitem.Text = sqlreader["mach"].ToString();
155                 lvitem.SubItems.Add(sqlreader["cauhoi"].ToString().Trim());
156                 lvitem.SubItems.Add(sqlreader["A"].ToString().Trim());
157                 lvitem.SubItems.Add(sqlreader["B"].ToString().Trim());
158                 lvitem.SubItems.Add(sqlreader["C"].ToString().Trim());
159                 lvitem.SubItems.Add(sqlreader["D"].ToString().Trim());
160                 lvitem.SubItems.Add(sqlreader["Dapan"].ToString());
161
162                 //lvitem.SubItems.Add(sqlreader["n"].ToString());
163
164                 listView1.Items.Add(lvitem);
165             }
166             sqlreader.Close();
167
168         }

30              void load()
31         {
32             sqlcmd = new SqlCommand("select * from sinhvien ", sqlcon);
33             SqlDataReader sqlreader = sqlcmd.ExecuteReader();
34             listView1.Items.Clear();
35             while (sqlreader.Read())
36             {
37                 ListViewItem lvitem = new ListViewItem();
38                 //lvitem.Text = sqlreader["MaCH"].ToString();
39                 //lvitem.SubItems.Add(sqlreader["cauhoi"].ToString());
40
41                 //string sMaCH = sqlreader["mach"].ToString();
42
43                 lvitem.Text = sqlreader["mats"].ToString();
44                 lvitem.SubItems.Add(sqlreader["hoten"].ToString());
45                 lvitem.SubItems.Add(sqlreader["ngaysinh"].ToString());
46                 lvitem.SubItems.Add(sqlreader["gioitinh"].ToString());
47                 lvitem.SubItems.Add(sqlreader["quequan"].ToString());
48                 lvitem.SubItems.Add(sqlreader["sodienthoai"].ToString());
49                 lvitem.SubItems.Add(sqlreader["email"].ToString());
50
51                 //lvitem.SubItems.Add(sqlreader["n"].ToString());
52
53                 listView1.Items.Add(lvitem);
54             }
55             sqlreader.Close();
56         }

30         private void txt6_Validating_1(object sender, CancelEventArgs e)
31         {
32             if (string.IsNullOrEmpty(txt6.Text))
33             {
34                 errorProvider1.SetError(txt6, "Bạn phải nhập giá trị vào ô này");
35                 e.Cancel = true;
36             }
37             else
38             {
39                 errorProvider1.Clear();
40             }
41         }

65         private void button2_Click(object sender, EventArgs e)
66         {
67             txt1.Clear();
68             txt2.Clear();
69             txt3.Clear();
70             txt4.Clear();
71             txt5.Clear();
72             txt6.Clear();
73         }

50         void TaoBangRandomCauHoi(DataTable BangQuestion)
51         {
52
53             try
54             {
55                 Random Rnd = new Random();
56                 ArrayList ArrQuestion = new ArrayList();
57
58                 ArrQuestion.Clear();
59                 int x, dem = 0;
60                 int SoCauTrongBangGoc = BangQuestion.Rows.Count;
61                 while (dem < SoCauNgauNhien)
62                 {
63                     x = Rnd.Next(0, SoCauTrongBangGoc);
64                     if (!ArrQuestion.Contains(x))
65                     {
66                         ArrQuestion.Add(x);
67                         dem++;
68                     }
69                 }
70                 for (int j = SoCauTrongBangGoc - 1; j >= 0; j--)
71                     if (!ArrQuestion.Contains(j))
72                         BangQuestion.Rows.RemoveAt(j);
73
74                 BangDeThi = BangQuestion;
75                 BangDeThi.Columns.Add("cauhoi,DAPAN");
76
77             }
78             catch (Exception ex)
79             { MessageBox.Show(ex.Message); }
80
81         }

82         void TaoBangRandomCauTraLoi()
83         {
84             try
85             {
86                 SoCauHoi = BangDeThi.Rows.Count;
87                 string DapAnDung = "";
88                 string A, B, C, D;
89                 int DapAn;
90                 Random Rnd = new Random();
91                 ArrayList ArrDapAn = new ArrayList();
92                 for (int i = 0; i < SoCauHoi; i++)
93                 {
94                     A = "";
95                     B = "";
96                     C = "";
97                     D = "";
98                     DapAnDung = "";
99                     DapAn = 0;
100                     ArrDapAn.Clear();
101                     ArrDapAn.Add(2);
102                     ArrDapAn.Add(3);
103                     ArrDapAn.Add(4);
104                     ArrDapAn.Add(5);
105
106                     DapAn = Rnd.Next(ArrDapAn.Count);
107                     A = BangDeThi.Rows[i][(int)ArrDapAn[DapAn]].ToString();
108                     if ((BangDeThi.Rows[i][6].ToString().ToUpper().Contains("A") && (int)ArrDapAn[DapAn] == 2) || (BangDeThi.Rows[i][6].ToString().ToUpper().Contains("B") && (int)ArrDapAn[DapAn] == 3) || (BangDeThi.Rows[i][6].ToString().ToUpper().Contains("C") && (int)ArrDapAn[DapAn] == 4) || (BangDeThi.Rows[i][6].ToString().ToUpper().Contains("D") && (int)ArrDapAn[DapAn] == 5))
109                         DapAnDung += "A";
110                     ArrDapAn.RemoveAt(DapAn);
111                     DapAn = Rnd.Next(ArrDapAn.Count);
112                     B = BangDeThi.Rows[i][(int)ArrDapAn[DapAn]].ToString();
113                     if ((BangDeThi.Rows[i][6].ToString().ToUpper().Contains("A") && (int)ArrDapAn[DapAn] == 2) || (BangDeThi.Rows[i][6].ToString().ToUpper().Contains("B") && (int)ArrDapAn[DapAn] == 3) || (BangDeThi.Rows[i][6].ToString().ToUpper().Contains("C") && (int)ArrDapAn[DapAn] == 4) || (BangDeThi.Rows[i][6].ToString().ToUpper().Contains("D") && (int)ArrDapAn[DapAn] == 5))
114                         DapAnDung += "B";
115                     ArrDapAn.RemoveAt(DapAn);
116                     DapAn = Rnd.Next(ArrDapAn.Count);
117                     C = BangDeThi.Rows[i][(int)ArrDapAn[DapAn]].ToString();
118                     if ((BangDeThi.Rows[i][6].ToString().ToUpper().Contains("A") && (int)ArrDapAn[DapAn] == 2) || (BangDeThi.Rows[i][6].ToString().ToUpper().Contains("B") && (int)ArrDapAn[DapAn] == 3) || (BangDeThi.Rows[i][6].ToString().ToUpper().Contains("C") && (int)ArrDapAn[DapAn] == 4) || (BangDeThi.Rows[i][6].ToString().ToUpper().Contains("D") && (int)ArrDapAn[DapAn] == 5))
119                         DapAnDung += "C";
120                     ArrDapAn.RemoveAt(DapAn);
121                     DapAn = Rnd.Next(ArrDapAn.Count);
122                     D = BangDeThi.Rows[i][(int)ArrDapAn[DapAn]].ToString();
123                     if ((BangDeThi.Rows[i][6].ToString().ToUpper().Contains("A") && (int)ArrDapAn[DapAn] == 2) || (BangDeThi.Rows[i][6].ToString().ToUpper().Contains("B") && (int)ArrDapAn[DapAn] == 3) || (BangDeThi.Rows[i][6].ToString().ToUpper().Contains("C") && (int)ArrDapAn[DapAn] == 4) || (BangDeThi.Rows[i][6].ToString().ToUpper().Contains("D") && (int)ArrDapAn[DapAn] == 5))
124                         DapAnDung += "D";
125                     BangDeThi.Rows[i][2] = A;
126                     BangDeThi.Rows[i][3] = B;
127                     BangDeThi.Rows[i][4] = C;
128                     BangDeThi.Rows[i][5] = D;
129                     BangDeThi.Rows[i][6] = DapAnDung;
130                 }
131             }
132             catch (Exception ex)
133             { MessageBox.Show(ex.Message); }
134         }

26         private void timkiemtheodiemcaoanhat()
27         {
28             try
29             {
30                 sqlcmd = new SqlCommand("select ketqua.mats,HOTEN,NGAYTHI,SOCAUDUNG,SOCAUSAI,DIEM FROM THISINHTHI,KETQUA WHERE THISINHTHI.MATS=KETQUA.MATS and ketqua.diem=(select max(diem) from ketqua)", sqlcon);
31                 SqlDataReader sqlreader = sqlcmd.ExecuteReader();
32                 listView1.Items.Clear();
33                 while (sqlreader.Read())
34                 {
35                     ListViewItem lvitem = new ListViewItem();
36                     lvitem.Text = sqlreader["MATS"].ToString();
37                     lvitem.SubItems.Add(sqlreader["HOTEN"].ToString().Trim());
38                     lvitem.SubItems.Add(sqlreader["NGAYTHI"].ToString().Trim());
39                     lvitem.SubItems.Add(sqlreader["SOCAUDUNG"].ToString().Trim());
40                     lvitem.SubItems.Add(sqlreader["SOCAUSAI"].ToString().Trim());
41                     lvitem.SubItems.Add(sqlreader["DIEM"].ToString().Trim());
42                     listView1.Items.Add(lvitem);
43                 }
44                 sqlreader.Close();
45             }
46             catch
47             {
48                 MessageBox.Show("Bạn làm sai thao tác");
49
50             }
51
52
53         }

55         private void timkiemtheongay()
56         {
57             if (tbngaythang.Text == "")
58             {
59                 rdb1.Checked = false;
60                 MessageBox.Show("Bạn điền ngày tháng năm vao trước, theo dạng tháng / ngày / năm", "Có lỗi", MessageBoxButtons.OK, MessageBoxIcon.Warning);
61                 tbngaythang.Enabled = true;
62             }
63             else
64             {
65
66                 Sngay = tbngaythang.Text;
67                 try
68                 {
69
70
71                         sqlcmd = new SqlCommand("select thisinhthi.mats,HOTEN,NGAYTHI,SOCAUDUNG,SOCAUSAI,DIEM FROM THISINHTHI,KETQUA WHERE THISINHTHI.MATS=KETQUA.MATS and ngaythi='" + Sngay + "'", sqlcon);
72                         SqlDataReader sqlreader = sqlcmd.ExecuteReader();
73                         listView1.Items.Clear();
74                         while (sqlreader.Read())
75                         {
76                             ListViewItem lvitem = new ListViewItem();
77                             lvitem.Text = sqlreader["MATS"].ToString();
78                             lvitem.SubItems.Add(sqlreader["HOTEN"].ToString().Trim());
79                             lvitem.SubItems.Add(sqlreader["NGAYTHI"].ToString().Trim());
80                             lvitem.SubItems.Add(sqlreader["SOCAUDUNG"].ToString().Trim());
81                             lvitem.SubItems.Add(sqlreader["SOCAUSAI"].ToString().Trim());
82                             lvitem.SubItems.Add(sqlreader["DIEM"].ToString().Trim());
83                             listView1.Items.Add(lvitem);
84                         }
85                         sqlreader.Close();
86
87                 }
88                 catch
89                 {
90                     MessageBox.Show("Không có ai thi ngày này '" + Sngay + "'");
91                     tbngaythang.Text = "";
92
93
94                 }
95             }
96         }

97         void timkiemtheodiemthapnhat()
98         {
99             try
100             {
101                 sqlcmd = new SqlCommand("select ketqua.mats,HOTEN,NGAYTHI,SOCAUDUNG,SOCAUSAI,DIEM FROM THISINHTHI,KETQUA WHERE THISINHTHI.MATS=KETQUA.MATS and ketqua.diem=(select min(diem) from ketqua)", sqlcon);
102                 SqlDataReader sqlreader = sqlcmd.ExecuteReader();
103                 listView1.Items.Clear();
104                 while (sqlreader.Read())
105                 {
106                     ListViewItem lvitem = new ListViewItem();
107                     lvitem.Text = sqlreader["MATS"].ToString();
108                     lvitem.SubItems.Add(sqlreader["HOTEN"].ToString().Trim());
109                     lvitem.SubItems.Add(sqlreader["NGAYTHI"].ToString().Trim());
110                     lvitem.SubItems.Add(sqlreader["SOCAUDUNG"].ToString().Trim());
111                     lvitem.SubItems.Add(sqlreader["SOCAUSAI"].ToString().Trim());
112                     lvitem.SubItems.Add(sqlreader["DIEM"].ToString().Trim());
113                     listView1.Items.Add(lvitem);
114                 }
115                 sqlreader.Close();
116             }
117             catch
118             {
119                 MessageBox.Show("Bạn làm sai thao tác");
120
121             }
122         }

123         void loadtatca()
124         {
125             try
126             {
127                 sqlcmd = new SqlCommand("select thisinhthi.mats,HOTEN,NGAYTHI,SOCAUDUNG,SOCAUSAI,DIEM FROM THISINHTHI,KETQUA WHERE THISINHTHI.MATS=KETQUA.MATS", sqlcon);
128                 SqlDataReader sqlreader = sqlcmd.ExecuteReader();
129                 listView1.Items.Clear();
130                 while (sqlreader.Read())
131                 {
132                     ListViewItem lvitem = new ListViewItem();
133                     lvitem.Text = sqlreader["MATS"].ToString();
134                     lvitem.SubItems.Add(sqlreader["HOTEN"].ToString().Trim());
135                     lvitem.SubItems.Add(sqlreader["NGAYTHI"].ToString().Trim());
136                     lvitem.SubItems.Add(sqlreader["SOCAUDUNG"].ToString().Trim());
137                     lvitem.SubItems.Add(sqlreader["SOCAUSAI"].ToString().Trim());
138                     lvitem.SubItems.Add(sqlreader["DIEM"].ToString().Trim());
139                     listView1.Items.Add(lvitem);
140                 }
141                 sqlreader.Close();
142             }
143             catch
144             {
145
146                 MessageBox.Show("Dữ liệu trống");
147                 return;
148             }
149         }