public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { CrystalReport1indanhsachphongban rpt = new CrystalReport1indanhsachphongban(); rpt.Site = this.Site; return(rpt); }
private void Formfdanhsachphongban_Load(object sender, EventArgs e) { var query = "SELECT PHONGBAN.MAPHG, PHONGBAN.TENPHG, NHANVIEN.HOTENNV, PHONGBAN.NG_NHANCHUCTRP " + "FROM NHANVIEN INNER JOIN " + "PHONGBAN ON NHANVIEN.PHG = PHONGBAN.MAPHG AND NHANVIEN.MANV = PHONGBAN.TRPHG"; SqlDataAdapter da = new SqlDataAdapter(query, Bang.Bang.cnn); SqlCommandBuilder cmm = new SqlCommandBuilder(da); try { DataTable b = new DataTable(); da.Fill(b); CrystalReport1indanhsachphongban rpt = new CrystalReport1indanhsachphongban(); rpt.SetDataSource(b); crystalReportViewer1.ReportSource = rpt; } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }