DataSet
How do I use Data Set
Below are practical examples compiled from projects for learning and reference purposes
Featured Snippets
File name: FormKHGD.cs
Copy
20 private void FormKHGD_Load(object sender, EventArgs e)
21 {
22 // TODO: This line of code loads data into the 'cNPM_1DataSet5.KhoiLop' table. You can move, or remove it, as needed.
23 this.khoiLopTableAdapter.Fill(this.cNPM_1DataSet_KhoiLop.KhoiLop);
24 // TODO: This line of code loads data into the 'cNPM_1DataSet4.HocKy' table. You can move, or remove it, as needed.
25 this.hocKyTableAdapter.Fill(this.cNPM_1DataSet_HocKy.HocKy);
26 dgvKHGD.DataSource = business.ShowData("KeHoachGiangDay");
27 }
File name: FormKhoiLop.cs
Copy
20 private void FormKhoiLop_Load(object sender, EventArgs e)
21 {
22 // TODO: This line of code loads data into the 'cNPM_1DataSet3.TrinhDoDaoTao' table. You can move, or remove it, as needed.
23 this.trinhDoDaoTaoTableAdapter.Fill(this.cNPM_1DataSet_TrinhDoDaoTao.TrinhDoDaoTao);
24 // TODO: This line of code loads data into the 'cNPM_1DataSet2.HeDaoTao' table. You can move, or remove it, as needed.
25 this.heDaoTaoTableAdapter.Fill(this.cNPM_1DataSet_HeDaoTao.HeDaoTao);
26 dgvKhoiLop.DataSource = business.ShowData("KhoiLop");
27 }
File name: FormLop.cs
Copy
20 private void FormLop_Load(object sender, EventArgs e)
21 {
22 // TODO: This line of code loads data into the 'cNPM_1DataSet8.GiangVien' table. You can move, or remove it, as needed.
23 this.giangVienTableAdapter.Fill(this.cNPM_1DataSet_GiangVien.GiangVien);
24 // TODO: This line of code loads data into the 'cNPM_1DataSet7.KhoiLop' table. You can move, or remove it, as needed.
25 this.khoiLopTableAdapter.Fill(this.cNPM_1DataSet_KhoiLop.KhoiLop);
26 dgvLop.DataSource = business.ShowData("Lop");
27
28 }
File name: FormNhomHocPhan.cs
Copy
20 private void FormNhomHocPhan_Load(object sender, EventArgs e)
21 {
22 // TODO: This line of code loads data into the 'cNPM_1DataSet11.GiangVien' table. You can move, or remove it, as needed.
23 this.giangVienTableAdapter.Fill(this.cNPM_1DataSet11.GiangVien);
24 // TODO: This line of code loads data into the 'cNPM_1DataSet10.KeHoachGiangDay' table. You can move, or remove it, as needed.
25 this.keHoachGiangDayTableAdapter.Fill(this.cNPM_1DataSet10.KeHoachGiangDay);
26 // TODO: This line of code loads data into the 'cNPM_1DataSet9.HocPhan' table. You can move, or remove it, as needed.
27 this.hocPhanTableAdapter.Fill(this.cNPM_1DataSet9.HocPhan);
28 dgvNhomHocPhan.DataSource= business.ShowData("NhomHocPhan");
29 }
File name: FormQuanLyDiem.cs
Copy
23 private void FormQuanLyDiem_Load(object sender, EventArgs e)
24 {
25 // TODO: This line of code loads data into the 'cNPM_1DataSet4.HocKy' table. You can move, or remove it, as needed.
26 this.hocKyTableAdapter.Fill(this.cNPM_1DataSet4.HocKy);
27
28 }
File name: FormSinhVien.cs
Copy
20 private void FormSinhVien_Load(object sender, EventArgs e)
21 {
22 // TODO: This line of code loads data into the 'cNPM_1DataSet6.Lop' table. You can move, or remove it, as needed.
23 this.lopTableAdapter.Fill(this.cNPM_1DataSet_Lop.Lop);
24 dgvSinhVien.DataSource = business.ShowData("SinhVien");
25 }
File name: FormXemDiem.cs
Copy
21 private void FormXemDiem_Load(object sender, EventArgs e)
22 {
23 // TODO: This line of code loads data into the 'cNPM_1DataSet4.HocKy' table. You can move, or remove it, as needed.
24 this.hocKyTableAdapter.Fill(this.cNPM_1DataSet_HocKy.HocKy);
25
26 }
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 }
File name: gradeclass.cs
Copy
106 public DataSet SaveItem()
107 {
108 return this.SaveItem("data1");
109 }
Download file with original file name:DataSet
DataSet 143 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
495 lượt xem
Java enum Constructor
471 lượt xem
Toán tử Spread JavaScript
738 lượt xem
LinQ.QLTV.designer.cs.dll
878 lượt xem
QLTV.designer.cs.dll
894 lượt xem