How to generate barcode images using Crystal Reports for .NET in .NET Windows Applications

1. Create a new "Windows Applicaton" project, named "BarcodeforCrystalReports"

1. Add a new item (Crystal Report), named "CustomerReport.rpt" to the project. view image
2. Select Expert as "Mail Label". Click "OK" button. view image
3. In "Mailing Labels Report Creation Wizard", click "Create New Connection", and expand "ADO.NET". view image
4. In "ADO.NET" form, select "CustomerDataSet.xsd" file in your downloaded package, and click "Finish" button. view image
5. In "Mailing Labels Report Creation Wizard", add table "Customer" under "ADO.NET", to selected table. And click "Next" button. view image
6. Add all three fields "ID", "CustomerId", "CustomerName", to "Fields to Display:". Click "Next". view image
7. Select default label "Return Address (Avery 5267)", and click "Finish" button.
8. Now you can view the report template, and find that field "Barcode" not in the report template. view image
9. Re-arrange the report template. view image
10. Drag field "Barcode" to the report template. And Right click "Barcode" object, select "Format Object" menu. view image
11. In "Format Editor" form, check "Can Grow" property.

1. Resize "Form1", and add "CrystalReportViewer" to the form, with the default setting unchanged. view image
2. Add a reference to BarcodeLib.Barcode.dll
3. Add the following code to the Form1.cs file.
   using System.Data.OleDb;
   using System.Drawing.Imaging;
   using BarcodeLib.Barcode.Linear;
   
4. Add the following code to the Form1.cs file.

private void Form1_Load(object sender, EventArgs e)
{
    //create the database connection. Please change to correct data file (BarcodeDemoData.mdb) path.
    OleDbConnection aConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/net_barcode_trial/Reporting/BarcodeDemoData.mdb");
    aConnection.Open();


    OleDbDataAdapter dataAdapter = new OleDbDataAdapter("SELECT * FROM Customer", aConnection);
    DataSet ds = new DataSet();
    dataAdapter.Fill(ds);

    //Add the Barcode column to the DataSet
    ds.Tables[0].Columns.Add(new DataColumn("Barcode", typeof(byte[])));

    //Create an instance of Linear Barcode
    //Use BarcodeLib.Barcode.DataMatrix.DataMatrix for Data Matrix
    //Use BarcodeLib.Barcode.PDF417.PDF417 for PDF417
    //Use BarcodeLib.Barcode.PDF417.MicroPDF417 for MicroPDF417
    BarcodeLib.Barcode.Linear.Linear barcode = new BarcodeLib.Barcode.Linear.Linear();
    //Barcode settings
    barcode.Type = BarcodeLib.Barcode.Linear.BarcodeType.CODE128;
    barcode.BarHeight = 50; //50 pixel
    barcode.Format = ImageFormat.Png;

    foreach (DataRow dr in ds.Tables[0].Rows)
    {
        barcode.Data = (int)dr["CustomerId"] + "";
        byte[] imageData = barcode.drawBarcodeAsBytes();
        dr["Barcode"] = imageData;
    }

    CustomerReport rpt = new CustomerReport();
    rpt.SetDataSource(ds);

    this.crystalReportViewer1.ReportSource = rpt;


    //close the connection Its important.
    aConnection.Close();

}