GetLoad
How do I use Get Load
Below are practical examples compiled from projects for learning and reference purposes
Featured Snippets
| Line | Code | Ex.. |
|---|---|---|
| 230 | newgrade = gradeclass.DataModule.GetLoad(); | 1 |
| 34 | public DataSet GetLoad() | 2 |
| 39 | public DataSet GetLoad(string sortfield) | 3 |
File name: Form1.cs
Copy
228 public void Button5_Click(System.Object sender, System.EventArgs e)
229 {
230 newgrade = gradeclass.DataModule.GetLoad();
231 DataGridView1.DataSource = newgrade;
232 DataGridView1.DataMember = "grade1";
233
234 }
File name: gradeclass.cs
Copy
34 public DataSet GetLoad()
35 {
36 return this.GetLoad("data1");
37 }
File name: gradeclass.cs
Copy
39 public DataSet GetLoad(string sortfield)
40 {
41
42 System.Data.OleDb.OleDbConnection conn = GetConnection();
43 DataSet ds = new DataSet();
44
45 try
46 {
47
48 // Dim sql As String = "SELECT ID data1 as [Firstname],data2 as [Lastname],data3 as [20],data4 as [EG],data5 as [1st-10%],data6 as [50pt],data7 as [EG1],data8 as [2nd-10%],data9 as [50pts],data10 as [EG2],data11 as [20%],data12 as [100pt],data13 as [EG3],data14 as [30%],data15 as [100],data16 as [EG4],data17 as [2nd-30%],data18 as [PrelimGrade],data19 as [Remarks]FROM Table1 order by " + sortfield
49 string sql = "SELECT STUDENTID,data1 AS Firstname, data2 AS Lastname," + "data3 AS 20, data4 AS EG, data5 AS [1st-10%], data6 AS 50pt," + "data7 AS EG1, data8 AS [2nd-10%], data9 AS 50pts, data10 AS EG2," + "data11 AS [20%], data12 AS 100pt, data13 AS EG3, data14 AS [30%]," + "data15 AS 100, data16 AS EG4, data17 AS [2nd-30%], data18 AS PrelimGrade," + "data19 AS Remarks FROM Table1 ORDER BY ID";
50
51 System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter(sql, conn);
52 try
53 {
54 da.Fill(ds, "grade1");
55 }
56 finally
57 {
58 da.Dispose();
59 }
60 return ds;
61 }
62 finally
63 {
64 conn.Close();
65 conn.Dispose();
66 }
67 }
GetLoad 105 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
500 lượt xem
Java enum Constructor
474 lượt xem
Toán tử Spread JavaScript
742 lượt xem
LinQ.QLTV.designer.cs.dll
881 lượt xem
QLTV.designer.cs.dll
895 lượt xem