Beispiel #1
0
        public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            DSSP rpt = new DSSP();

            rpt.Site = this.Site;
            return(rpt);
        }
Beispiel #2
0
        private void MH_In_DSSP_Load(object sender, EventArgs e)
        {
            cnn = new SqlConnection("Data Source=DESKTOP-GQ9H33C\\NGUYENLINH;Initial Catalog=QLVanPhongPham;Integrated Security=True");
            //
            da = new SqlDataAdapter("SELECT  SANPHAM.MaSP, SANPHAM.TenSP, SANPHAM.SoLuong, SANPHAM.DonVi, SANPHAM.DonGia, NSX.TenNSX, LOAI.TenLoai "
                                    + "FROM   SANPHAM INNER JOIN "
                                    + "NSX ON SANPHAM.MaNSX = NSX.MaNSX INNER JOIN "
                                    + "LOAI ON SANPHAM.MaLoai = LOAI.MaLoai", cnn);

            dt_SanPham = new System.Data.DataTable();
            da.Fill(dt_SanPham);

            DSSP rpt = new DSSP();

            rpt.SetDataSource(dt_SanPham.DefaultView);
            crvBaoCao.ReportSource = rpt;
        }