private void frmReportViewer_Load(object sender, EventArgs e) { try { string que = "SELECT * FROM Customer_Order where Customer_Id = " + customer_id; Order ord = new OrderManager().GetAllData(que); string que1 = "SELECT * FROM Customer_Details where customer_Id = " + customer_id; Customer cus = new CustomerManager().GetAllCustData(que1); DataSet ds = new DataSet(); ds.Tables.Add("Customer_Details"); ds.Tables["Customer_Details"].Columns.Add("customer_id"); ds.Tables["Customer_Details"].Columns.Add("first_name"); ds.Tables["Customer_Details"].Columns.Add("last_name"); ds.Tables["Customer_Details"].Columns.Add("address"); ds.Tables["Customer_Details"].Columns.Add("name_of_com"); ds.Tables["Customer_Details"].Columns.Add("contact_no"); ds.Tables["Customer_Details"].Columns.Add("mobile"); ds.Tables["Customer_Details"].Columns.Add("email_id"); ds.Tables["Customer_Details"].Rows.Add(); ds.Tables["Customer_Details"].Rows[0]["customer_id"] = customer_id; ds.Tables["Customer_Details"].Rows[0]["first_name"] = cus.Name.ToString(); ds.Tables["Customer_Details"].Rows[0]["last_name"] = cus.Surname.ToString(); ds.Tables["Customer_Details"].Rows[0]["address"] = "---"; ds.Tables["Customer_Details"].Rows[0]["name_of_com"] = cus.NameOfCom.ToString(); ds.Tables["Customer_Details"].Rows[0]["contact_no"] = "---"; ds.Tables["Customer_Details"].Rows[0]["mobile"] = cus.Mobile.ToString(); ds.Tables["Customer_Details"].Rows[0]["email_id"] = "--"; ds.Tables.Add("Customer_Order"); ds.Tables["Customer_Order"].Columns.Add("User_id"); ds.Tables["Customer_Order"].Columns.Add("order_no"); ds.Tables["Customer_Order"].Columns.Add("date"); ds.Tables["Customer_Order"].Columns.Add("type_of_work"); ds.Tables["Customer_Order"].Columns.Add("no_of_copies"); ds.Tables["Customer_Order"].Columns.Add("rate"); ds.Tables["Customer_Order"].Columns.Add("total"); ds.Tables["Customer_Order"].Columns.Add("Customer_Id"); ds.Tables["Customer_Order"].Rows.Add(); ds.Tables["Customer_Order"].Rows[0]["User_id"] = ord.ID; ds.Tables["Customer_Order"].Rows[0]["order_no"] = ord.OrderNo; ds.Tables["Customer_Order"].Rows[0]["date"] = ord.Date; ds.Tables["Customer_Order"].Rows[0]["type_of_work"] = ord.TypeOfWork.ToString(); ds.Tables["Customer_Order"].Rows[0]["no_of_copies"] = ord.NOC.ToString(); ds.Tables["Customer_Order"].Rows[0]["rate"] = ord.Rate.ToString(); ds.Tables["Customer_Order"].Rows[0]["total"] = ord.Total.ToString(); ds.Tables["Customer_Order"].Rows[0]["Customer_Id"] = customer_id; rptMyReport rpt = new rptMyReport(); rpt.SetDataSource(ds); crystalReportViewer1.ReportSource = rpt; } catch { } }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { rptMyReport rpt = new rptMyReport(); rpt.Site = this.Site; return(rpt); }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { rptMyReport rpt = new rptMyReport(); rpt.Site = this.Site; return rpt; }