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 such as DataSet, DataTable, Array, and IEnumerable objects.
The data can be set using the following objects in PDF:
Steps to generate a PDF report from a DataTable:
- Create a new console C# application project.
- Install the Syncfusion.Pdf.WinForms NuGet package as a 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 the 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.
Note:
Starting with v16.2.0.x, if you reference Syncfusion® assemblies from a trial setup or from the NuGet feed, include a license key in your projects. Refer to the link to learn about generating and registering the Syncfusion® license key in your application to use the components without a trial message.
Conclusion
I hope you enjoyed learning about how to generate PDF report from datatable in C#, VB.NET.
You can refer to our WinForms PDF’s feature tour page to know about its other groundbreaking feature representations. You can also explore our WinForms PDF documentation to understand how to present and manipulate data.
For current customers, you can check out our WinForms components from the License and Downloads page. If you are new to Syncfusion, you can try our 30-day free trial to check out our WinForms PDF and other WinForms components.
If you have any queries or require clarifications, please let us know in comments below. You can also contact us through our support forums, Direct-Trac, or feedback portal. We are always happy to assist you!