public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { ReserveBill rpt = new ReserveBill(); rpt.Site = this.Site; return(rpt); }
public void btBill_Click(object sender, EventArgs e) { DSReserveBill ds = new DSReserveBill(); ReserveBill rpt = new ReserveBill(); string sql = "select reserveID, employeeName, customerName, reserveDate, reserveComedate, convert(varchar(8),reservecometime, 108) as reserveCometime, boatHOur, foodname, foodamount, unitName, foodPrice, Total from v_reserveBill where reserveID = '" + System.Convert.ToString(dgvReserve.Rows[dgvReserve.CurrentRow.Index].Cells[0].Value) + "'"; SqlCommand cm = default(SqlCommand); SqlDataAdapter da = default(SqlDataAdapter); cm = new SqlCommand(sql, ConstVar.connect.DatabaseConnection(ConstVar.constr)); da = new SqlDataAdapter(cm); da.Fill(ds, "DTReserveBill"); rpt.SetDataSource(ds); frm_ReserveBill.Default.CrystalReportViewer1.ReportSource = rpt; frm_ReserveBill.Default.Show(); //frm_Bill.rp_Bill.ReportSource = rpt //frm_Bill.Show() }