How to generate PDF report from datatable in C#, VB.NET?
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:
- Create a new console C# application project.
- Install the Syncfusion.Pdf.WinForms NuGet package as reference to your .NET Framework applications from NuGet.org.
- 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
- 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();
- 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));
GetDataTable() method returns DataTable of applicable data to import.
- 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.
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.
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.