public List <BaoCaoTongKetHocKy> GetAllBaoCaoTongKetHocKy() { OpenConnection(); List <BaoCaoTongKetHocKy> listBaoCaoTongKetHocKy = new List <BaoCaoTongKetHocKy>(); SqlCommand com = new SqlCommand(); com.CommandType = CommandType.Text; com.CommandText = "Select * from BaoCaoTongKetHocKy"; com.Connection = conn; SqlDataReader reader = com.ExecuteReader(); while (reader.Read()) { string MaHocKy = reader.GetString(0); string MaNamHoc = reader.GetString(1); string MaLop = reader.GetString(2); int SoLuongDat = reader.GetInt32(3); float Tile = reader.GetFloat(4); BaoCaoTongKetHocKy baoCaoTongKetHocKy = new BaoCaoTongKetHocKy(MaHocKy, MaNamHoc, MaLop, SoLuongDat, Tile); listBaoCaoTongKetHocKy.Add(baoCaoTongKetHocKy); } reader.Close(); CloseConnection(); return(listBaoCaoTongKetHocKy); }
private void BtnTongKetHocKy_Click(object sender, EventArgs e) { Form frm = new BaoCaoTongKetHocKy(); frm.Show(); }