How to Add a Barcode in Crystal Reports using C#

How to Add a Barcode in Crystal Reports using C#

1. Install the Barcode Library.
2. Generate a Barcode image and save it as an image in a database table.
3. Design the layout for the Crystal Report.
4. Establish a connection to the database and select the necessary table.
5. Include a Barcode Image field in the Crystal Report layout.
6. Build and run the project.

Choose a Barcode Library

Before diving into the implementation, it's essential to select a barcode library that supports Crystal Reports and C#. One popular choice is the IronBarcode for .NET.

What is IronBarcode

IronBarcode is a versatile .NET library that simplifies barcode generation and reading. With IronBarcode, you can effortlessly create various barcodes, including Code 128 and QR codes, by specifying the value to encode. It also supports resizing and customization. On the reading side, IronBarcode can extract barcode data from images or PDFs, making it ideal for inventory management and document tracking. Its user-friendly API ensures quick integration into your projects, and cross-platform support allows seamless development across different .NET versions. Whether you’re a seasoned developer or a beginner, IronBarcode empowers you to work with barcodes efficiently.

CREATE DATABASE ProductDB;
USE [ProductDB]
GO
/****** Object:  Table [dbo].[Products]    Script Date: 3/10/2024 2:57:18 PM******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Products](
    [Product_ID] [int] NULL,
    [Product_Name] [varchar](100) NULL,
    [Product_Price] [decimal](18, 0) NULL,
    [Product_Barcode] [image] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

Install IronBarcode Library

To install the IronBarcode library using the NuGet Package Manager Console, follow these steps:

Open the NuGet Package Manager Console. You can find it by going to View -> Other Windows -> Package Manager Console.

In the Package Manager Console, use the following command to install the IronBarcode library:

Install-Package BarCode

Press Enter to execute the command.

Alternatively, you can install IronBarcode library using the Manage NuGet Packages for Solution:

Wait for the NuGet Package Manager to download and install the IronBarcode library and its dependencies. Once the installation is complete, you'll see a confirmation message in the Package Manager Console.

Now, the IronBarcode library is installed in your project, and you can start using its features for barcode generation and reading.

using System;
using System.Data.SqlClient;
using IronBarCode;

class Program
{
    static void Main(string[] args)
    {
        // Create a barcode from a string value using Code128 format.
        var myBarcode = BarcodeWriter.CreateBarcode("77446252", BarcodeWriterEncoding.Code128);
        // Add the barcode value text below the barcode image.
        myBarcode.AddBarcodeValueTextBelowBarcode();
        // Resize the barcode image.
        myBarcode.ResizeTo(600, 300);

        // SQL connection to the SQL Server database.
        using (SqlConnection cn = new SqlConnection("Data Source=localhost\\SQLEXPRESS;Initial Catalog=ProductDB;User ID=sa;Password=123456;Integrated Security=SSPI;"))
        {
            // SQL command to insert the barcode into the Products table.
            SqlCommand cmd = new SqlCommand($"INSERT INTO dbo.Products VALUES (77446252, 'Pine Apple Small', '100', @Barcode)", cn);
            // Add parameter for the barcode binary data.
            cmd.Parameters.AddWithValue("@Barcode", myBarcode.BinaryStream);

            // Open the connection, execute the query, close the connection.
            cn.Open();
            cmd.ExecuteNonQuery();
            cn.Close();
        }
    }
}

using System;
using System.Data.SqlClient;
using IronBarCode;

class Program
{
    static void Main(string[] args)
    {
        // Create a barcode from a string value using Code128 format.
        var myBarcode = BarcodeWriter.CreateBarcode("77446252", BarcodeWriterEncoding.Code128);
        // Add the barcode value text below the barcode image.
        myBarcode.AddBarcodeValueTextBelowBarcode();
        // Resize the barcode image.
        myBarcode.ResizeTo(600, 300);

        // SQL connection to the SQL Server database.
        using (SqlConnection cn = new SqlConnection("Data Source=localhost\\SQLEXPRESS;Initial Catalog=ProductDB;User ID=sa;Password=123456;Integrated Security=SSPI;"))
        {
            // SQL command to insert the barcode into the Products table.
            SqlCommand cmd = new SqlCommand($"INSERT INTO dbo.Products VALUES (77446252, 'Pine Apple Small', '100', @Barcode)", cn);
            // Add parameter for the barcode binary data.
            cmd.Parameters.AddWithValue("@Barcode", myBarcode.BinaryStream);

            // Open the connection, execute the query, close the connection.
            cn.Open();
            cmd.ExecuteNonQuery();
            cn.Close();
        }
    }
}

Imports System
Imports System.Data.SqlClient
Imports IronBarCode

Friend Class Program
	Shared Sub Main(ByVal args() As String)
		' Create a barcode from a string value using Code128 format.
		Dim myBarcode = BarcodeWriter.CreateBarcode("77446252", BarcodeWriterEncoding.Code128)
		' Add the barcode value text below the barcode image.
		myBarcode.AddBarcodeValueTextBelowBarcode()
		' Resize the barcode image.
		myBarcode.ResizeTo(600, 300)

		' SQL connection to the SQL Server database.
		Using cn As New SqlConnection("Data Source=localhost\SQLEXPRESS;Initial Catalog=ProductDB;User ID=sa;Password=123456;Integrated Security=SSPI;")
			' SQL command to insert the barcode into the Products table.
			Dim cmd As New SqlCommand($"INSERT INTO dbo.Products VALUES (77446252, 'Pine Apple Small', '100', @Barcode)", cn)
			' Add parameter for the barcode binary data.
			cmd.Parameters.AddWithValue("@Barcode", myBarcode.BinaryStream)

			' Open the connection, execute the query, close the connection.
			cn.Open()
			cmd.ExecuteNonQuery()
			cn.Close()
		End Using
	End Sub
End Class

Design Your Crystal Reports Barcode generator

Now, design the report layout, add database connections, and arrange the necessary fields. If you're new to this, follow the following steps.

1. Open Field Explorer => Database Field => Database Expert.

   

2. Expand Create a new Connection => OLE DB(ADO) => Make New Connection.

   

3. Select Microsoft OLE DB Data Source for SQL Server and click Next.

   

4. Provide the Server Name, Login Credential, and Database Name as shown below.

   

5. Press the Next button, a new window will appear, and then click Finish.

6. Select the table you want to add. In this case, select the Products table.

   

7. Click on the OK Button.

We have set up a Database Connection. Now, let's set up the Report layout.

Now, I have added a Text Box with the text "Barcode in Crystal report C#". I added a text box, and drag & drop the Product ID, Product Name, Product Price Field, and Product Barcode from the database fields and placed them inside the box as shown below.

See the Crystal Report Preview in Crystal Report Viewer.

Build and run the project. The output is as follows:

I have not downloaded the sample dataset package, ensuring I had the correct data file, and proceeded to create a Crystal Report in C# for comprehensive data visualization.

In this way, we can create a barcode in the Crystal Reports Application without downloading the Barcode Font. Similarly, we can also add a QR Code as per your requirement.

Conclusion

In conclusion, integrating barcodes into Crystal Reports using C# is a powerful way to enhance data representation and management. Choosing a reliable barcode library like IronBarcode streamlines the process, offering versatility and ease of use. IronBarcode, with its support for various barcode types, resizing, and customization features, proves to be a valuable asset in barcode generation and reading tasks. The step-by-step guide provided here ensures a seamless implementation process, from selecting the library to designing the Crystal Report layout.

Moreover, IronBarcode offers developers the opportunity to unlock additional functionalities and support to enhance their barcode integration experience. This flexibility makes IronBarcode a compelling choice for developers, whether they are working on small-scale projects or enterprise-level applications.