예제 #1
0
        public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            rpDSDV rpt = new rpDSDV();

            rpt.Site = this.Site;
            return(rpt);
        }
예제 #2
0
        private void frmDSDV_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 tblDichVu.PK_iDichVuID, tblDichVu.sTenDV, tblDichVu.fDonGia, tblThongTinChiTietDichVu.iSoLuong from tblDichVu inner join tblThongTinChiTietDichVu on tblDichVu.PK_iDichVuID=tblThongTinChiTietDichVu.PK_iDichVuID");
            rpDSDV rp = new rpDSDV();

            rp.SetDataSource(dt);
            crystalReportViewer1.ReportSource = rp;
        }