OL
How do I use O L
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: crBaoCao.cs
Copy
33 public override bool NewGenerator {
34 get {
35 return true;
36 }
37 set {
38 // Do nothing
39 }
40 }
File name: crBaoCao.cs
Copy
108 public virtual bool IsCacheable {
109 get {
110 return true;
111 }
112 set {
113 //
114 }
115 }
File name: crBaoCao.cs
Copy
119 public virtual bool ShareDBLogonInfo {
120 get {
121 return false;
122 }
123 set {
124 //
125 }
126 }
File name: Form9.cs
Copy
121 private void ribbonControl1_SelectedPageChanged(object sender, EventArgs e)
122 {
123 CloseForm("Form9");
124 }
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
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 }
Download file with original file name:OL
OL 133 lượt xem
Gõ tìm kiếm nhanh...