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();
}
