List
How do I use List
Below are practical examples compiled from projects for learning and reference purposes
Featured Snippets
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
132 private void frmCapNhat_Load(object sender, EventArgs e)
133 {
134 LoadDataToListView();
135 comboBox1.SelectedIndex = 0;
136 }
File name: frmCapNhat.cs
Copy
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 }
File name: frmCapNhat.cs
Copy
170 private void button3_Click(object sender, EventArgs e)
171 {
172 LoadDataToListView();
173 Bandau();
174 }
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 }
File name: frmCapNhat.cs
Copy
238 private void button2_Click(object sender, EventArgs e)
239 {
240 if (richTextBox1.Text == "")
241 {
242 MessageBox.Show("Vui lòng chọn câu hỏi", "Thông báo");
243 }
244 else
245 {
246 string sCauHoi = richTextBox1.Text;
247 if (MessageBox.Show("Bạn có muốn xóa câu hỏi" + " " + sCauHoi, "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
248 {
249 string sMaCH = textBox5.Text;
250 sqlcmd = new SqlCommand("delete cauhoi where mach='" + sMaCH + "'", sqlcon);
251 sqlcmd.ExecuteNonQuery();
252 sqlcmd = new SqlCommand("delete dapan where mach='" + sMaCH + "'", sqlcon);
253 sqlcmd.ExecuteNonQuery();
254 LoadDataToListView();
255 }
256 Bandau();
257 }
258 }
File name: frmCapNhat.cs
Copy
311 private void button4_Click(object sender, EventArgs e)
312 {
313 if (richTextBox1.Text == "" || textBox1.Text == "" || textBox2.Text == "" || textBox3.Text == "" || textBox4.Text == "" || (checkBox1.Checked == false && checkBox2.Checked == false && checkBox3.Checked == false && checkBox4.Checked == false))
314 {
315 MessageBox.Show("Bạn chưa thêm đầy đủ thông tin", "Thông báo");
316 }
317 else
318 {
319 try
320 {
321
322 string sCauA = textBox1.Text;
323 string sCauB = textBox2.Text;
324 string sCauC = textBox3.Text;
325 string sCauD = textBox4.Text;
326 string sMaCH = textBox5.Text;
327 string sCauHoi = richTextBox1.Text;
328 string sCauDung = "";
329 string sCauDungLuu = "";
330 string sTrinhDo = comboBox1.Text;
331 if (checkBox1.Checked == true)
332 {
333 sCauDung = "A";
334 sCauDungLuu += sCauDung;
335 }
336 if (checkBox2.Checked == true)
337 {
338 sCauDung = "B";
339 sCauDungLuu += sCauDung;
340 }
341 if (checkBox3.Checked == true)
342 {
343 sCauDung = "C";
344 sCauDungLuu += sCauDung;
345 }
346 if (checkBox4.Checked == true)
347 {
348 sCauDung = "D";
349 sCauDungLuu += sCauDung;
350 }
351
352 sqlcmd = new SqlCommand("insert into dapan values('" + sMaCH + "','" + sCauA + "','" + sCauB + "','" + sCauC + "','" + sCauD + "','" + sCauDungLuu + "') ", sqlcon);
353 sqlcmd.ExecuteNonQuery();
354 sqlcmd = new SqlCommand("insert into cauhoi values('" + sMaCH + "','" + sCauHoi + "','" + sTrinhDo + "') ", sqlcon);
355 sqlcmd.ExecuteNonQuery();
356 LoadDataToListView();
357 button4.Enabled = false;
358 }
359 //roi hen;de bi coi lai thu de cHOAky thu chay thu hen ok
360 catch
361 {
362 MessageBox.Show("Bạn đã thao tác sai");
363 }
364 }
365 }
File name: frmKetQuathuthu.cs
Copy
37 private void listView1_SelectedIndexChanged(object sender, EventArgs e)
38 {
39
40 }
File name: frmQuanLySinhVien.cs
Copy
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 }
File name: frmQuanLySinhVien.cs
Copy
128 private void listView1_SelectedIndexChanged(object sender, EventArgs e)
129 {
130 for (int i = 0; i < listView1.Items.Count; i++)
131 if (listView1.Items[i].Selected)
132 {
133 textBox1.Text = listView1.Items[i].SubItems[0].Text;
134 textBox2.Text = listView1.Items[i].SubItems[1].Text;
135 textBox3.Text = listView1.Items[i].SubItems[2].Text;
136 textBox4.Text = listView1.Items[i].SubItems[3].Text;
137 textBox5.Text = listView1.Items[i].SubItems[4].Text;
138 textBox6.Text = listView1.Items[i].SubItems[5].Text;
139 textBox7.Text = listView1.Items[i].SubItems[6].Text;
140
141 }
142 }
Download file with original file name:List
List 129 lượt xem
Gõ tìm kiếm nhanh...