How To Use C# To Print Invoice

// If you are using SQL Server, please replace previous lines with the following:
string strCon = @"provider=sqloledb;Data Source=PC;Initial Catalog=" +
                "Northwind;Integrated Security=SSPI" + ";";
// Replace 'Data Source=PC' with the name of your system
try
{
    // Get data from tables: Orders, Customers, Employees, Products, Order Details:
    string InvSql = "SELECT Customers.CompanyName, Customers.City, " +
                    "Employees.FirstName + Space(1) + Employees.LastName AS Salesperson, " +
                    "Orders.OrderID, Orders.OrderDate, " +
                    "[Order Details].ProductID, Products.ProductName, [Order Details].UnitPrice, " 
                    "[Order Details].Quantity, [Order Details].Discount, " +
                    "CCur([Order Details].UnitPrice * [Quantity] * (1 - [Discount]) / 100) * 100 AS ExtendedPrice, " +
                    "Orders.Freight " +
                    "FROM Products " +
                    "INNER JOIN ((Employees INNER JOIN " +
                    "ON Employees.EmployeeID = Orders.EmployeeID) " +
                    "INNER JOIN [Order Details] ON Orders.OrderID = [Order Details].OrderID) " +
                    "ON Products.ProductID = [Order Details].ProductID;";
    // Create an OleDbDataAdapter
    OleDbDataAdapter datAdp = new OleDbDataAdapter(InvSql, strCon);
    // Create a command builder
    OleDbCommandBuilder cBuilder = new OleDbCommandBuilder(datAdp);
    // Create a DataTable to hold the query results
    DataTable dTable = new DataTable();
    // Fill the DataTable
    datAdp.Fill(dTable);
    // Set DataSource of DataGrid
    datGrid.DataSource = dTable;
}
catch (Exception e)
{
    MessageBox.Show(e.ToString());
}

// Declare 'InvoiceOrder' in 'clsGlobal' class, 'InvoiceOrder' is the number of Order which you select:
int intOrder = int.Parse(clsGlobal.InvoiceOrder);
string MyDataFile = Application.StartupPath + @"\DataFile\Northwind.mdb";
string MyPass = "";
string strCon = "provider=microsoft.jet.oledb.4.0;data source=" +
                MyDataFile + ";" + "Jet OLEDB:Database Password=" + MyPass + ";";
try
{
    // Get Invoice Data:
    InvSql = "SELECT [Order Details].ProductID, " +
             "Products.ProductName, [Order Details].UnitPrice, " +
             "[Order Details].Quantity, [Order Details].Discount, " +
             "CCur([Order Details].UnitPrice*[Quantity]*(1-[Discount])/100)*100 " +
             "AS ExtendedPrice " +
             "FROM Products INNER JOIN [Order Details] " +
             "ON Products.ProductID=[Order Details].ProductID " +
             "WHERE [Order Details].OrderID = " + intOrder;
    // Create an OleDbDataAdapter
    OleDbDataAdapter datAdp = new OleDbDataAdapter(InvSql, strCon);
    // Create a command builder
    OleDbCommandBuilder cBuilder = new OleDbCommandBuilder(datAdp);
    // Create a DataTable to hold the query results
    DataTable dTable = new DataTable();
    // Fill the DataTable
    datAdp.Fill(dTable);
    // Create a TableStyle to format Datagrid columns.
    ordGrid.TableStyles.Clear();
    DataGridTableStyle tableStyle = new DataGridTableStyle();
    foreach (DataColumn dc in dTable.Columns)
    {
        DataGridTextBoxColumn txtColumn = new DataGridTextBoxColumn();
        txtColumn.MappingName = dc.ColumnName;
        txtColumn.HeaderText = dc.Caption;
        switch (dc.ColumnName.ToString())
        {
            case "ProductID": // Product ID 
                txtColumn.HeaderText = "Product ID";
                txtColumn.Width = 60;
                break;
            case "ProductName": // Product Name 
                txtColumn.HeaderText = "Product Name";
                txtColumn.Width = 110;
                break;
            case "UnitPrice": // Unit Price 
                txtColumn.HeaderText = "Unit Price";
                txtColumn.Format = "0.00";
                txtColumn.Alignment = HorizontalAlignment.Right;
                txtColumn.Width = 60;
                break;
            case "Discount": // Discount 
                txtColumn.HeaderText = "Discount";
                txtColumn.Format = "p"; // percent
                txtColumn.Alignment = HorizontalAlignment.Right;
                txtColumn.Width = 60;
                break;
            case "Quantity": // Quantity 
                txtColumn.HeaderText = "Quantity";
                txtColumn.Alignment = HorizontalAlignment.Right;
                txtColumn.Width = 50;
                break;
            case "ExtendedPrice": // Extended Price 
                txtColumn.HeaderText = "Extended Price";
                txtColumn.Format = "0.00";
                txtColumn.Alignment = HorizontalAlignment.Right;
                txtColumn.Width = 90;
                break;
        }
        tableStyle.GridColumnStyles.Add(txtColumn);
    }
    tableStyle.MappingName = dTable.TableName;
    ordGrid.TableStyles.Add(tableStyle);
    // Set DataSource of DataGrid 
    ordGrid.DataSource = dTable.DefaultView;
}
catch (Exception e)
{
    MessageBox.Show(e.ToString());
}

Declare and initialize three instances for printing

In C#, you can declare and initialize instances of classes or objects to perform various tasks, including printing information to the console. In this article, we'll demonstrate how to declare and initialize three instances for printing.

Here is the code below that initializes three instances for printing.

private System.Windows.Forms.PrintDialog prnDialog;
private System.Windows.Forms.PrintPreviewDialog prnPreview;
private System.Drawing.Printing.PrintDocument prnDocument;
this.prnDialog = new System.Windows.Forms.PrintDialog();
this.prnPreview = new System.Windows.Forms.PrintPreviewDialog();
this.prnDocument = new System.Drawing.Printing.PrintDocument();
// The Event of 'PrintPage'
prnDocument.PrintPage += new System.Drawing.Printing.PrintPageEventHandler(prnDocument_PrintPage);

To draw something on the report (as a line or text)

When creating reports, it's often necessary to add various elements like lines, text, shapes, or images to convey information effectively. Most reporting tools and frameworks provide features for drawing and adding elements to your reports. In this guide, we'll explore how to draw something on a report, be it a line or text, using a hypothetical reporting tool called "ReportBuilder."

Here is the code below To draw something on the report (as a line or text).

// Result of the Event 'PrintPage'
private void prnDocument_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e)
{
    leftMargin = (int)e.MarginBounds.Left;  // leftMargin, rightMargin, ... Declared before
    rightMargin = (int)e.MarginBounds.Right;
    topMargin = (int)e.MarginBounds.Top;
    bottomMargin = (int)e.MarginBounds.Bottom;
    InvoiceWidth = (int)e.MarginBounds.Width;
    InvoiceHeight = (int)e.MarginBounds.Height;
    // Draw Invoice Head
    SetInvoiceHead(e.Graphics);
}

Font InvTitleFont = new Font("Arial", 24, FontStyle.Regular);
SolidBrush HeadBrush = new SolidBrush(Color.Blue);

private void SetInvoiceHead(Graphics g)
{
    // Invoice title:
    string InvTitle = "International Food Company";
    // Title Font:
    Font InvTitleFont = new Font("Arial", 24, FontStyle.Regular);
    // Title Color:
    SolidBrush HeadBrush = new SolidBrush(Color.Blue);
    // Title Height:
    int InvTitleHeight = (int)(InvTitleFont.GetHeight(g));
    // Title Length:
    int lenInvTitle = (int)g.MeasureString(InvTitle, InvTitleFont).Width;
    // Coordinate:
    int CurrentX = leftMargin + (InvoiceWidth - lenInvTitle) / 2; // to set the title in the center
    int CurrentY = topMargin + InvTitleHeight;
    // Draw the title:
    g.DrawString(InvTitle, InvTitleFont, HeadBrush, CurrentX, CurrentY);
}

• Get Left Margin, Right Margin, Top Margin, Bottom Margin, Report Width and Report Height.
• Set Font and Color.
• Set the Font Height and Font Width and coordinate, then use the DrawString method.

The project has several pieces of code in three forms; please read the code, then run the program to see the result.