Prelim
How do I use Prelim
Below are practical examples compiled from projects for learning and reference purposes
Featured Snippets
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 }
File name: gradeclass.cs
Copy
68 public void RefreshDGV()
69 {
70
71 System.Data.OleDb.OleDbConnection conn = GetConnection();
72 string sql = default(string);
73 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";
74
75 System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter(sql, conn);
76 DataTable dt = new DataTable("grade1");
77 da.Fill(dt);
78 Form1.Default.DataGridView1.DataSource = dt;
79 }
Prelim 114 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
498 lượt xem
Java enum Constructor
473 lượt xem
Toán tử Spread JavaScript
739 lượt xem
LinQ.QLTV.designer.cs.dll
880 lượt xem
QLTV.designer.cs.dll
895 lượt xem