// Print the Order private void btnPrintOrder_Click(object sender, EventArgs e) { if (orderDTO != null || orderDTO.PurchaseOrderID != default) { POdataset ds = new POdataset(); // Create a connection // // cnn.Open(); POdatasetTableAdapters.PurchaseOrder1TableAdapter adapter = new POdatasetTableAdapters.PurchaseOrder1TableAdapter(); POdatasetTableAdapters.EmployeeTableAdapter empAdapter = new POdatasetTableAdapters.EmployeeTableAdapter(); POdatasetTableAdapters.PurchaseLineItemTableAdapter lineAdaper = new POdatasetTableAdapters.PurchaseLineItemTableAdapter(); POdatasetTableAdapters.OrderFeeTableAdapter feeAdapers = new POdatasetTableAdapters.OrderFeeTableAdapter(); POdatasetTableAdapters.SupplierTableAdapter supplierAdapter = new POdatasetTableAdapters.SupplierTableAdapter(); // Hydrate all the internal tables adapter.Fill(ds.PurchaseOrder1, orderDTO.PurchaseOrderID); empAdapter.Fill(ds.Employee, orderDTO.EmployeeID); lineAdaper.Fill(ds.PurchaseLineItem, orderDTO.PurchaseOrderID); feeAdapers.Fill(ds.OrderFee, orderDTO.PurchaseOrderID); supplierAdapter.Fill(ds.Supplier, orderDTO.SupplierID); // PurchaseOrderReport1.SetDataSource(ds); // } PrintOrderForm orderFrom = new PrintOrderForm(ds); orderFrom.Show(); } }
private void OrderHeaderVerticalControl1_OnPrintHandler(object sender, EventArgs e) { if (orderDTO != null || orderDTO.PurchaseOrderID != default) { POdataset ds = new POdataset(); POdatasetTableAdapters.PurchaseOrder1TableAdapter adapter = new POdatasetTableAdapters.PurchaseOrder1TableAdapter(); POdatasetTableAdapters.EmployeeTableAdapter empAdapter = new POdatasetTableAdapters.EmployeeTableAdapter(); POdatasetTableAdapters.PurchaseLineItemTableAdapter lineAdaper = new POdatasetTableAdapters.PurchaseLineItemTableAdapter(); POdatasetTableAdapters.OrderFeeTableAdapter feeAdapers = new POdatasetTableAdapters.OrderFeeTableAdapter(); POdatasetTableAdapters.SupplierTableAdapter supplierAdapter = new POdatasetTableAdapters.SupplierTableAdapter(); // Hydrate all the internal tables adapter.Fill(ds.PurchaseOrder1, orderDTO.PurchaseOrderID); empAdapter.Fill(ds.Employee, orderDTO.EmployeeID); lineAdaper.Fill(ds.PurchaseLineItem, orderDTO.PurchaseOrderID); feeAdapers.Fill(ds.OrderFee, orderDTO.PurchaseOrderID); supplierAdapter.Fill(ds.Supplier, orderDTO.SupplierID); PrintOrderForm orderFrom = new PrintOrderForm(ds); // Show the form with report for printing orderFrom.Show(); } }
public PrintOrderForm(POdataset DS) { InitializeComponent(); // Pass in the loaded Dataset -- ds = DS; }