Add
How do I use Add
Below are practical examples compiled from projects for learning and reference purposes
Featured Snippets
File name: ClassBLL.cs
Copy
275 public bool Proc_Insert(string proc,string test)
276 {
277 SqlConnection con = da.GetConnect();
278 con.Open();
279 SqlCommand cmd = new SqlCommand(proc, con);
280 cmd.CommandType = CommandType.StoredProcedure;
281 cmd.Parameters.Add("@test", SqlDbType.NVarChar).Value = test;
282 SqlDataReader dr = cmd.ExecuteReader();
283 if (dr.Read())
284 {
285 return false;
286 }
287 return true;
288 }
File name: FormBaoCao.cs
Copy
40 private void btnLoc_Click(object sender, EventArgs e)
41 {
42 SqlConnection con = dal.GetConnect();
43 con.Open();
44 string sql = "select *from SinhVien where MaLop=@MaLop";
45 SqlDataAdapter da = new SqlDataAdapter(sql, con);
46 da.SelectCommand.Parameters.AddWithValue("@MaLop", cmbMaLop.SelectedValue.ToString());
47 DataTable dt = new DataTable();
48 da.Fill(dt);
49 crBaoCao cr = new crBaoCao();
50 ConnectionInfo crConnectionInfo = new ConnectionInfo();
51 crConnectionInfo.ServerName = "Ty-PC";
52 crConnectionInfo.DatabaseName = "CNPM_1";
53 crConnectionInfo.UserID = "sa";
54 crConnectionInfo.Password = "04091990";
55 TableLogOnInfos crTableLogonInfos = new TableLogOnInfos();
56 foreach (CrystalDecisions.CrystalReports.Engine.Table table in cr.Database.Tables)
57 {
58 TableLogOnInfo crTableLogonInfo = new TableLogOnInfo();
59 crTableLogonInfo.TableName = table.Name;
60 crTableLogonInfo.ConnectionInfo = crConnectionInfo;
61 crTableLogonInfos.Add(crTableLogonInfo);
62 table.ApplyLogOnInfo(crTableLogonInfo);
63
64 }
65 crvHocKyHocPhan.LogOnInfo = crTableLogonInfos;
66 cr.SetDataSource(dt);
67 ParameterValues a = new ParameterValues();
68 ParameterDiscreteValue b = new ParameterDiscreteValue();
69 b.Value = cmbMaLop.SelectedValue.ToString();
70 a.Add(b);
71 cr.DataDefinition.ParameterFields["txtMaLop"].ApplyCurrentValues(a);
72 crvHocKyHocPhan.ReportSource = cr;
73 crvHocKyHocPhan.Show();
74 }
File name: FormXemDiem.cs
Copy
85 private void btnXuatRaExcel_Click(object sender, EventArgs e)
86 {
87 try
88 {
89
90 Excel.Application objExcelApp = new Excel.Application();
91 Excel.Workbook objExcelWorkbook = objExcelApp.Workbooks.Add(Excel.XlWBATemplate.xlWBATWorksheet);
92 Excel.Worksheet objSheet = (Excel.Worksheet)objExcelWorkbook.Worksheets[1];
93 //objSheet.Cells.Interior.Color.ToString() = 'blue';
94 objSheet = (Excel.Worksheet)objExcelWorkbook.Sheets[1];
95 objSheet.Cells.HorizontalAlignment = Excel.Constants.xlCenter;
96 objSheet.Cells[2, 5] = "BẢNG ĐIỂM CỦA SINH VIÊN";
97 objSheet.Cells[5, 3] = "Mã Học Phần";
98 objSheet.Cells[5, 4] = "Mã Nhóm Học Phần";
99 objSheet.Cells[5, 5] = "Tên Học Phần";
100 objSheet.Cells[5, 6] = "Điểm Thi";
101 objSheet.Cells[5, 7] = "Điểm Quá Trình";
102 objSheet.Cells[5, 8] = "Điểm Xếp Loại";
103 objSheet.Cells[3, 3] = "Mã Học Kỳ : "+cmbMaHK.SelectedValue.ToString()+"";
104 objSheet.Cells[4, 3] = "Mã SV : " + txtMaSV.Text + "";
105 objSheet.Cells[9,10] = "ĐIỂM TỔNG KẾT";
106 objSheet.Cells[10,10] = "Hệ 10 : "+txtHe10.Text+"";
107 objSheet.Cells[11,10] = "Hệ 4 : "+txtHe4.Text+"";
108 for (int i = 0; i < dgvKetQua.Rows.Count ; i++)
109 {
110 for (int j = 0; j < dgvKetQua.Columns.GetColumnCount(DataGridViewElementStates.Displayed); j++)
111 {
112 objSheet.Cells[i + 6, j + 3] = dgvKetQua.Rows[i].Cells[j].Value.ToString();
113 objSheet.Columns.AutoFit();
114 }
115 }
116 objExcelApp.Visible = true;
117 }
118 catch (Exception ex)
119 {
120 MessageBox.Show(ex.Message);
121 }
122 }
File name: FormXemDiemLop.cs
Copy
77 private void btnXuatRaExcel_Click(object sender, EventArgs e)
78 {
79 try
80 {
81
82 Excel.Application objExcelApp = new Excel.Application();
83 Excel.Workbook objExcelWorkbook = objExcelApp.Workbooks.Add(Excel.XlWBATemplate.xlWBATWorksheet);
84 Excel.Worksheet objSheet = (Excel.Worksheet)objExcelWorkbook.Worksheets[1];
85 //objSheet.Cells.Interior.Color.ToString() = 'blue';
86 objSheet = (Excel.Worksheet)objExcelWorkbook.Sheets[1];
87 objSheet.Cells.HorizontalAlignment = Excel.Constants.xlCenter;
88 objSheet.Cells[2, 5] = "BẢNG ĐIỂM CỦA LỚP";
89 objSheet.Cells[3, 3] = "Mã Học Kỳ : "+cmbMaHK.SelectedValue.ToString()+"";
90 objSheet.Cells[4, 3] = "Mã Lớp : " + cmbMaLop.SelectedValue.ToString() + "";
91 objSheet.Cells[5, 4] = "Mã Sinh Viên";
92 objSheet.Cells[5, 5] = "Tên Sinh Viên";
93 objSheet.Cells[5, 6] = "Điểm Trung Bình";
94 //select sv.MaSV,TenSV,TrungBinhCuoiKyHe10
95
96 for (int i = 0; i < dgvKetQua.Rows.Count ; i++)
97 {
98 for (int j = 0; j < dgvKetQua.Columns.GetColumnCount(DataGridViewElementStates.Displayed); j++)
99 {
100 objSheet.Cells[i + 6, j + 4] = dgvKetQua.Rows[i].Cells[j].Value.ToString();
101 objSheet.Columns.AutoFit();
102 }
103 }
104 objExcelApp.Visible = true;
105 }
106 catch (Exception ex)
107 {
108 MessageBox.Show(ex.Message);
109 }
110 }
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 }
Download file with original file name:Add
Add 125 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
505 lượt xem
Java enum Constructor
481 lượt xem
Toán tử Spread JavaScript
748 lượt xem
LinQ.QLTV.designer.cs.dll
886 lượt xem
QLTV.designer.cs.dll
900 lượt xem