public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { crpt_TinhTrang rpt = new crpt_TinhTrang(); rpt.Site = this.Site; return(rpt); }
private void btnsubmit_Click(object sender, EventArgs e) { string tinhtrang = cbbtinhtrang.SelectedItem.ToString(); string chidoan = cbbchidoan.SelectedValue.ToString(); string khoahoc = cbbkhoahoc.SelectedValue.ToString(); Report.crpt_TinhTrang rpt = new Report.crpt_TinhTrang(); conn.Open(); SqlDataAdapter dap = new SqlDataAdapter("SELECT tbl_ChiDoan.MaChiDoan,TenChiDoan,tbl_KhoaHoc.MaKhoaHoc , ThoiGianDaoTao, MaSV, HoTenSV, CONVERT(varchar(50),NgaySinh,103) as NgaySinh , DiaChi, DienThoai, TinhTrang, MaDT, NgayVaoDoan from tbl_ChiDoan, tbl_KhoaHoc, tbl_SINHVIEN where tbl_SINHVIEN.MaChiDoan = '" + chidoan + "' and tbl_KhoaHoc.MaKhoaHoc = '" + khoahoc + "' and tbl_SINHVIEN.MaChiDoan = tbl_ChiDoan.MaChiDoan and tbl_KhoaHoc.MaKhoaHoc = tbl_ChiDoan.MaKhoaHoc and TinhTrang = N'" + tinhtrang + "' ", conn); DataSet ds = new DataSet(); dap.Fill(ds); rpt.SetDataSource(ds.Tables[0]); crystalReportViewer1.ReportSource = rpt; crystalReportViewer1.Refresh(); conn.Close(); }