We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to generate PDF report from datatable in C#, VB.NET

Platform: WinForms |
Control: PDF |
Published Date: August 14, 2018 |
Last Revised Date: May 3, 2019

Syncfusion Essential PDF is a .NET PDF library used to create, read, and edit PDF documents. Using this library, you can generate a PDF report from DataTable in C# and VB.NET.

Essential PDF supports importing data from the data sources from DataSet, DataTable, Array and IEnuemrable objects.

The data can be set using the following objects in PDF:

Steps to generate PDF report from data table:

  1. Create a new console C# application project. Create console application in Visual Studio
  2. Install the  Syncfusion.Pdf.WinForms NuGet package as reference to your .NET Framework applications from NuGet.org. Install nuget packages
  3. Include the following namespaces in Program.cs file for DataTable and PDF usage.

C#

using System.Data;
using Syncfusion.Pdf;
using Syncfusion.Pdf.Grid;
using System.Drawing;
using System;

 

VB.NET

Imports System.Data
Imports Syncfusion.Pdf
Imports Syncfusion.Pdf.Grid
Imports System.Drawing
Imports System

 

  1. Add a new page in PDF document and initialize the PdfGrid object.

C#

//Create a new PDF document
PdfDocument doc = new PdfDocument();
 
//Add a page
PdfPage page = doc.Pages.Add();
 
//Create a PdfGrid
PdfGrid pdfGrid = new PdfGrid();

 

  1. Assign the data table to the DataSource property. Draw the PdfGrid in the PDF document’s page.

C#

//Create a DataTable
DataTable dataTable = GetDataTable();
 
//Assign data source
pdfGrid.DataSource = dataTable;
 
//Draw grid to the page of PDF document
pdfGrid.Draw(page, new PointF(10, 10));

 

Note:

GetDataTable() method returns DataTable of applicable data to import.

 

  1. Use the following code snippet to generate the PDF document from data table.

C#

//Create a new PDF document
PdfDocument doc = new PdfDocument();
 
//Add a page
PdfPage page = doc.Pages.Add();
 
//Create a PdfGrid
PdfGrid pdfGrid = new PdfGrid();
 
//Create a DataTable
DataTable dataTable = GetDataTable();
 
//Assign data source
pdfGrid.DataSource = dataTable;
 
//Initialize grid style.
PdfGridStyle gridStyle = new PdfGridStyle();
 
//Add cell padding.
gridStyle.CellPadding = new PdfPaddings(5, 5, 5, 5);
 
//Apply style to grid.
pdfGrid.Style = gridStyle;
 
//Draw grid to the page of PDF document
pdfGrid.Draw(page, new PointF(10, 10));
 
//Save the document
doc.Save("Output.pdf");
 
//Close the document
doc.Close(true);

 

VB.NET

'Create a new PDF document
Dim doc As PdfDocument = New PdfDocument()
 
'Add a page
Dim page As PdfPage = doc.Pages.Add()
 
'Create a PdfGrid
Dim pdfGrid As PdfGrid = New PdfGrid()
 
'Create a DataTable
Dim dataTable As DataTable = GetDataTable()
 
'Assign data source
pdfGrid.DataSource = dataTable
 
'Initialize grid style.
Dim gridStyle As PdfGridStyle = New PdfGridStyle()
 
'Add cell padding.
gridStyle.CellPadding = New PdfPaddings(5, 5, 5, 5)
 
'Apply style to grid.
PdfGrid.Style = gridStyle
 
'Draw grid to the page of PDF document
pdfGrid.Draw(page, New PointF(10, 10))
 
'Save the document
doc.Save("Output.pdf")
 
'Close the document
doc.Close(True)

 

A complete working sample can be downloaded from Generate-PDF-report-from-DataTable.zip

By executing the program, you will get the PDF document as follows. Genearte PDF report from DataTable

You can go through the documentation, where you will find the importing options available with Essential PDF and the brief details about PdfLighTable, PdfGrid, Pagination, Table customization and more with code examples.

Refer here to explore the rich set of Syncfusion Essential PDF features.

An online sample link to generate PDF from Datatable via PdfLightTable.

Note:

Starting with v16.2.0.x, if you reference Syncfusion assemblies from trial setup or from the NuGet feed, include a license key in your projects. Refer to link to learn about generating and registering Syncfusion license key in your application to use the components without trail message.

 

2X faster development

The ultimate WinForms UI toolkit to boost your development speed.
ADD COMMENT
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Up arrow icon

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile