Check
How do I use Check
Below are practical examples compiled from projects for learning and reference purposes
Featured Snippets
File name: ClassBLL.cs
Copy
191 public int CheckLogin(string name, string pass)
192 {
193 SqlConnection con = da.GetConnect();
194 SqlCommand cmd = new SqlCommand("select *from Users Where Username='"+name+"' and Password='"+pass+"'",con);
195 con.Open();
196 SqlDataReader dr = cmd.ExecuteReader();
197 if (dr.Read())
198 {
199 if (dr[2].ToString() == "admin")
200 {
201 return 1;
202 }
203 else
204 {
205 return 2;
206 }
207 }
208 else
209 {
210 return -1;
211 }
212 }
File name: FormDangNhap.cs
Copy
30 private void btnDangNhap_Click(object sender, EventArgs e)
31 {
32 int quyen=business.CheckLogin(txtTenDangNhap.Text, txtMatKhau.Text);
33 if (quyen != -1)
34 {
35 Form9.quyen = quyen;
36 Form9 f = (Form9)this.MdiParent;
37 f.PhanQuyenMenu();
38 this.Close();
39 }
40 else
41 {
42 MessageBox.Show("Sai Tên Đăng Nhập Hoặc Mật Khẩu !!");
43 }
44 }
File name: FormXemDiem.cs
Copy
32 private void btnXem_Click(object sender, EventArgs e)
33 {
34 string sql1 = "select TenSV from SinhVien where MaSV='" + txtMaSV.Text + "'";
35 if (business.ShowData_where(sql1).Rows.Count!=0)
36 {
37 lblTenSV.Text= business.ShowData_where(sql1).Rows[0][0].ToString();
38 lblTenSV.Visible = true;
39 }
40 if (chbXemTatCaHocKy.Checked == true)
41 {
42 string sql = "select HocPhan.MaHP,NhomHocPhan.MaNhomHP,HocPhan.TenHP,KetQua.DiemQT,KetQua.DiemThi,KetQua.DiemXepLoai " +
43 " From KetQua,HocPhan,NhomHocPhan,KeHoachGiangDay " +
44 " Where KetQua.MaSV='" + txtMaSV.Text + "' " +
45 " and KetQua.MaNhomHP=NhomHocPhan.MaNhomHP " +
46 " and NhomHocPhan.MaHP=HocPhan.MaHP " +
47 " and NhomHocPhan.MaKHGD=KeHoachGiangDay.MaKHGD ";
48 dgvKetQua.DataSource = business.ShowData_where(sql);
49 if (dgvKetQua.RowCount > 0)
50 {
51 string test = business.TinhDiemTB(txtMaSV.Text);
52 txtHe10.Text = test.Split(',')[0];
53 txtHe4.Text = test.Split(',')[1];
54 }
55 else
56 {
57 txtHe10.Text = "";
58 txtHe4.Text = "";
59 }
60 }
61 else
62 {
63 string sql = "select HocPhan.MaHP,NhomHocPhan.MaNhomHP,HocPhan.TenHP,KetQua.DiemQT,KetQua.DiemThi,KetQua.DiemXepLoai " +
64 " From KetQua,HocPhan,NhomHocPhan,KeHoachGiangDay " +
65 " Where KetQua.MaSV='" + txtMaSV.Text + "' " +
66 " and KetQua.MaNhomHP=NhomHocPhan.MaNhomHP " +
67 " and NhomHocPhan.MaHP=HocPhan.MaHP " +
68 " and NhomHocPhan.MaKHGD=KeHoachGiangDay.MaKHGD " +
69 " and KeHoachGiangDay.MaHK='" + cmbMaHK.SelectedValue.ToString() + "'";
70 dgvKetQua.DataSource = business.ShowData_where(sql);
71 if (dgvKetQua.RowCount > 0)
72 {
73 string test = business.TinhDiemTB(txtMaSV.Text, cmbMaHK.SelectedValue.ToString());
74 txtHe10.Text = test.Split(',')[0];
75 txtHe4.Text = test.Split(',')[1];
76 }
77 else
78 {
79 txtHe10.Text = "";
80 txtHe4.Text = "";
81 }
82 }
83 }
File name: FormXemDiem.cs
Copy
130 private void chbXemTatCaHocKy_CheckedChanged(object sender, EventArgs e)
131 {
132 int i = -1;
133 i = i * j;
134 if (i == 1)
135 {
136 cmbMaHK.Enabled = false;
137 }
138 else
139 {
140 cmbMaHK.Enabled = true;
141 }
142 j = -j;
143 }
File name: FormXemDiemLop.cs
Copy
59 private void btnXem_Click(object sender, EventArgs e)
60 {
61 if (chbXemTatCa.Checked == true)
62 {
63 if (Convert.ToInt32(cmbMaLop.SelectedIndex) != -1)
64 {
65 dgvKetQua.DataSource = business.XemDiemLop(cmbMaLop.SelectedValue.ToString());
66 }
67 }
68 else
69 {
70 if (Convert.ToInt32(cmbMaLop.SelectedIndex) != -1 && Convert.ToInt32(cmbMaHK.SelectedIndex) != -1)
71 {
72 dgvKetQua.DataSource = business.XemDiemLop(cmbMaHK.SelectedValue.ToString(), cmbMaLop.SelectedValue.ToString());
73 }
74 }
75 }
File name: FormXemDiemLop.cs
Copy
112 private void chbXemTatCa_CheckedChanged(object sender, EventArgs e)
113 {
114 int i = -1;
115 i = i * j;
116 if (i == 1)
117 {
118 cmbMaHK.Enabled = false;
119 }
120 else
121 {
122 cmbMaHK.Enabled = true;
123 }
124 j = -j;
125 }
File name: frmCapNhat.cs
Copy
30 private void Macdinh()
31 {
32 checkBox1.Checked = false;
33 checkBox2.Checked = false;
34 checkBox3.Checked = false;
35 checkBox4.Checked = false;
36 }
File name: frmCapNhat.cs
Copy
38 private void Bandau()
39 {
40 checkBox1.Checked = false;
41 checkBox2.Checked = false;
42 checkBox3.Checked = false;
43 checkBox4.Checked = false;
44 textBox1.Text = "";
45 textBox2.Text = "";
46 textBox3.Text = "";
47 textBox4.Text = "";
48 textBox5.Text = "";
49 richTextBox1.Text = "";
50 }
File name: frmCapNhat.cs
Copy
54 private void listView1_SelectedIndexChanged(object sender, EventArgs e)
55 {
56 bool bdapan = false;
57 for (int i = 0; i < listView1.Items.Count; i++)
58 {
59 if (listView1.Items[i].Selected)
60 {
61 textBox5.Text = listView1.Items[i].SubItems[0].Text;
62 textBox1.Text = listView1.Items[i].SubItems[2].Text;
63 textBox2.Text = listView1.Items[i].SubItems[3].Text;
64 textBox3.Text = listView1.Items[i].SubItems[4].Text;
65 textBox4.Text = listView1.Items[i].SubItems[5].Text;
66 richTextBox1.Text = listView1.Items[i].SubItems[1].Text;
67 string t = listView1.Items[i].SubItems[6].Text.ToString().Trim();
68 if (t.Length >= 2)
69 {
70 for (int ii = 0; ii < t.Length; ii++)
71 {
72 t2 = t[0].ToString();
73 if (t[1].ToString() == "")
74 {
75 t1 = "NULL";
76 }
77 else
78 {
79 t1 = t[1].ToString();
80 }
81 }
82 }
83 else
84 {
85 t2 = t;
86 t1 = "NULL";
87 }
88 Macdinh();
89 if (t1 == "A")
90 {
91 checkBox1.Checked = true;
92 }
93 if (t1 == "B")
94 {
95 checkBox2.Checked = true;
96 }
97 if (t1 == "C")
98 {
99 checkBox3.Checked = true;
100 }
101 if (t1 == "D")
102 {
103 checkBox4.Checked = true;
104 }
105
106 if (t2 == "A")
107 {
108 checkBox1.Checked = true;
109 }
110 if (t2 == "B")
111 {
112 checkBox2.Checked = true;
113 }
114 if (t2 == "C")
115 {
116 checkBox3.Checked = true;
117 }
118 if (t2 == "D")
119 {
120 checkBox4.Checked = true;
121 }
122 bdapan = true;
123 }
124 if (bdapan == false)
125 {
126 Bandau();
127 }
128 }
129
130 }
File name: frmCapNhat.cs
Copy
183 private void button1_Click_1(object sender, EventArgs e)
184 {
185 try
186 {
187 string sCauA = textBox1.Text;
188 string sCauB = textBox2.Text;
189 string sCauC = textBox3.Text;
190 string sCauD = textBox4.Text;
191 string sMaCH = textBox5.Text;
192 string sCauHoi = richTextBox1.Text;
193 string sCauDung = "";
194 string sCauDungLuu = "";
195 string sTrinhDo = comboBox1.Text;
196 if (richTextBox1.Text.ToString().Trim() == "" || textBox1.Text == "" || textBox2.Text == "" || textBox3.Text == "" || textBox4.Text == "" || (checkBox1.Checked == false && checkBox2.Checked == false && checkBox3.Checked == false && checkBox4.Checked == false))
197 {
198 MessageBox.Show("Bạn đã sai làm thao tác", "Thông báo");
199 }
200 else
201 {
202 if (checkBox1.Checked == true)
203 {
204 sCauDung = "A";
205 sCauDungLuu += sCauDung;
206 }
207 if (checkBox2.Checked == true)
208 {
209 sCauDung = "B";
210 sCauDungLuu += sCauDung;
211 }
212 if (checkBox3.Checked == true)
213 {
214 sCauDung = "C";
215 sCauDungLuu += sCauDung;
216 }
217 if (checkBox4.Checked == true)
218 {
219 sCauDung = "D";
220 sCauDungLuu += sCauDung;
221 }
222
223 sqlcmd = new SqlCommand("update dapan set A='" + sCauA + "',B='" + sCauB + "',C='" + sCauC + "',D='" + sCauD + "',dapan='" + sCauDungLuu + "' where mach='" + sMaCH + "'", sqlcon);
224 sqlcmd.ExecuteNonQuery();
225 sqlcmd = new SqlCommand("update cauhoi set cauhoi='" + sCauHoi + "', trinhdo='" + sTrinhDo + "' where mach='" + sMaCH + "'", sqlcon);
226 sqlcmd.ExecuteNonQuery();
227 LoadDataToListView();
228 Bandau();
229 }
230 }
231
232 catch
233 {
234 MessageBox.Show("Bạn đã sai làm thao tác", "Thông báo");
235 }
236 }
Download file with original file name:Check
Check 104 lượt xem
Gõ tìm kiếm nhanh...
Dự án liên quan!
Cách sửa bàn phím laptop bị liệt hiệu quả 170k
507 lượt xem
Java enum Constructor
483 lượt xem
Toán tử Spread JavaScript
750 lượt xem
LinQ.QLTV.designer.cs.dll
888 lượt xem
QLTV.designer.cs.dll
901 lượt xem