private void frmTHONGKE_Load(object sender, EventArgs e)
{
rptMUONSACH rpt = new rptMUONSACH();
DataSet ds = new DataSet();
string query = " Select b.MaThe, b.TenBanDoc, s.MaSach, b.TuaDe, s.TacGia, NgayMuon, NgayTra "
+ " from (SACH s inner join BANDOC b on m.MaThe = b.MaThe "
+ " where NgayTra is Null ";
SqlDataAdapter da = new SqlDataAdapter(query, XL_BANG.Chuoi_lien_ket);
da.Fill(ds);
rpt.SetDataSource(ds.Tables[0]);
cRPTHONGKE.ReportSource = rpt;
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() {
rptMUONSACH rpt = new rptMUONSACH();
rpt.Site = this.Site;
return rpt;
}
