public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CRBenhNhanTheoKhoa rpt = new CRBenhNhanTheoKhoa();
rpt.Site = this.Site;
return(rpt);
}
private void frmDSBenhNhanTheoKhoa_Load(object sender, EventArgs e)
{
DataTable dt = new DataTable();
KetNoi kn = new KetNoi();
// dt = kn.laybang("SELECT tblBenhnhan.PK_iBenhnhanID, tblBenhnhan.sHoten, tblBenhnhan.bGioitinh, tblBenhnhan.sDiachi, tblBenhnhan.iSDT, tblBenhnhan.dNgaysinh, tblKhoa.PK_iKhoaID, tblKhoa.sTenKhoa FROM tblBenhnhan INNER JOIN tblKhoa ON tblBenhnhan.PK_iBenhnhanID = tblKhoa.PK_iBenhNhanID");
dt = kn.laybang("SELECT tblBenhNhan.PK_iBenhNhanID, tblBenhNhan.sHoTen, tblBenhNhan.bGioiTinh, tblBenhNhan.sDiaChi, tblBenhNhan.sSDT, tblBenhNhan.dNgaySinh, tblKhoa.PK_iKhoaID, tblKhoa.sTenKhoa FROM tblBenhNhan INNER JOIN tblKhoa ON tblBenhNhan.PK_iKhoaID = tblKhoa.PK_iKhoaID");
CRBenhNhanTheoKhoa rp = new CRBenhNhanTheoKhoa();
rp.SetDataSource(dt);
rpdsBNtheoKhoa.ReportSource = rp;
}
