System.Nullable<>
using CrystalDecisions.CrystalReports.Engine; using CrystalDecisions.Shared; public partial class admin_adminreports : System.Web.UI.Page { DataClassesDataContext db = new DataClassesDataContext(); protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { CrystalReportViewer1.Visible = true; var query = (from s in db.Books join d in db.Bookings on s.bookid equals d.bookid orderby s.bookid select new { s.bookid, s.Screen_id, s.Movie_id, s.Show_id, s.Fare_id, s.tickets, s.total, s.bookdate, d.userid, d.Seat_id }).ToList(); ReportDocument report = new ReportDocument(); report.FileName = Server.MapPath("CrystalReport.rpt"); report.SetDataSource(query); CrystalReportViewer1.ReportSource = report; } } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)