Click here to Skip to main content
13,041,692 members (62,880 online)
Click here to Skip to main content
Add your own
alternative version


30 bookmarked
Posted 27 Mar 2012

Exporting a DataTable to PDF

, 27 Mar 2012
Rate this:
Please Sign up or sign in to vote.
Using MigraDoc as an open source .NET library to export a DataTable to PDF.



MigraDoc Foundation is an Open Source .NET library that easily creates documents based on an object model with paragraphs, tables, styles, etc. and renders them into PDF, XPS, or RTF. A new feature I have added is when you provide a datatable (.NET) it will be easily converted to a PDF file.

Using the code

The zip file is a Visual Studio 2010 solution. PdfForm.cs has the functionality for converting a datatable to PDF and the remaining work is done using code inside the Default.aspx file.

public Document CreateDocument()
    // Create a new MigraDoc document
    this.document = new Document();
    this.document.Info.Title = "";
    this.document.Info.Subject = "";
    this.document.Info.Author = "Aftab";

    return this.document;

Here, CreateDocument() in PDFform.cs creates a new MigraDoc. Take a look at the three functions called for creating style and page and fill the content of the tables.

void DefineStyles()
    // Get the predefined style Normal.
    Style style = this.document.Styles["Normal"];
    // Because all styles are derived from Normal, the next line changes the 
    // font of the whole document. Or, more exactly, it changes the font of
    // all styles and paragraphs that do not redefine the font.
    style.Font.Name = "Verdana";

    style = this.document.Styles[StyleNames.Header];
    style.ParagraphFormat.AddTabStop("16cm", TabAlignment.Right);

    style = this.document.Styles[StyleNames.Footer];
    style.ParagraphFormat.AddTabStop("8cm", TabAlignment.Center);

    // Create a new style called Table based on style Normal
    style = this.document.Styles.AddStyle("Table", "Normal");
    style.Font.Name = "Verdana";
    style.Font.Name = "Times New Roman";
    style.Font.Size = 9;

    // Create a new style called Reference based on style Normal
    style = this.document.Styles.AddStyle("Reference", "Normal");
    style.ParagraphFormat.SpaceBefore = "5mm";
    style.ParagraphFormat.SpaceAfter = "5mm";
    style.ParagraphFormat.TabStops.AddTabStop("16cm", TabAlignment.Right);

DefineStyles() does the job of styling the document:

void CreatePage()
    // Each MigraDoc document needs at least one section.
    Section section = this.document.AddSection();
    // Put a logo in the header
    Image image= section.AddImage(path);

    image.Top = ShapePosition.Top;
    image.Left = ShapePosition.Left;
    image.WrapFormat.Style = WrapStyle.Through;
    // Create footer
    Paragraph paragraph = section.Footers.Primary.AddParagraph();
    paragraph.AddText("Health And Social Services.");
    paragraph.Format.Font.Size = 9;
    paragraph.Format.Alignment = ParagraphAlignment.Center;


    // Create the item table
    this.table = section.AddTable();
    this.table.Style = "Table";
    this.table.Borders.Color = TableBorder;
    this.table.Borders.Width = 0.25;
    this.table.Borders.Left.Width = 0.5;
    this.table.Borders.Right.Width = 0.5;
    this.table.Rows.LeftIndent = 0;

    // Before you can add a row, you must define the columns
    Column column;
    foreach (DataColumn col in dt.Columns)
        column = this.table.AddColumn(Unit.FromCentimeter(3));
        column.Format.Alignment = ParagraphAlignment.Center;

    // Create the header of the table
    Row row = table.AddRow();
    row.HeadingFormat = true;
    row.Format.Alignment = ParagraphAlignment.Center;
    row.Format.Font.Bold = true;
    row.Shading.Color = TableBlue;

    for (int i = 0; i < dt.Columns.Count; i++)
        row.Cells[i].Format.Font.Bold = false;
        row.Cells[i].Format.Alignment = ParagraphAlignment.Left;
        row.Cells[i].VerticalAlignment = VerticalAlignment.Bottom;
    this.table.SetEdge(0, 0, dt.Columns.Count, 1, Edge.Box, 
         BorderStyle.Single, 0.75, Color.Empty);

Here CreatePage() adds a header, footer, and different sections into the document and then the table is created to display the records. Columns from the datatable are added into the table inside the document and then a header row that contains the column names is added.

column = this.table.AddColumn(Unit.FromCentimeter(3)); 
//creates a new column and width of the column is passed as a parameter.

Row row = table.AddRow();
//A new header row is created  

//this will add the column name to header of the row.

this.table.SetEdge(0, 0, dt.Columns.Count, 1, Edge.Box, 
           BorderStyle.Single, 0.75, Color.Empty);
//sets the border of the row

void FillContent()

    Row row1;
    for (int i = 0; i < dt.Rows.Count; i++)

        row1 = this.table.AddRow();
        row1.TopPadding = 1.5;

        for (int j = 0; j < dt.Columns.Count; j++)
            row1.Cells[j].Shading.Color = TableGray;
            row1.Cells[j].VerticalAlignment = VerticalAlignment.Center;
            row1.Cells[j].Format.Alignment = ParagraphAlignment.Left;
            row1.Cells[j].Format.FirstLineIndent = 1;

            this.table.SetEdge(0, this.table.Rows.Count - 2, dt.Columns.Count, 1, 
                 Edge.Box, BorderStyle.Single, 0.75);



FillContent() fills the rows from the datatable into the table inside the document:

//adds the value of column into the table row

The Default.aspx file contains the code for generating the PDF:

using MigraDoc.DocumentObjectModel;
using MigraDoc.Rendering;
using System.Diagnostics;

MigraDoc libraries are used for generating PDF documents, and System.Diagnostics for starting a PDF Viewer:

PDFform pdfForm = new PDFform(GetTable(), Server.MapPath("img2.gif"));

// Create a MigraDoc document
Document document = pdfForm.CreateDocument();
document.UseCmykColor = true;

// Create a renderer for PDF that uses Unicode font encoding
PdfDocumentRenderer pdfRenderer = new PdfDocumentRenderer(true);

// Set the MigraDoc document
pdfRenderer.Document = document;

// Create the PDF document

// Save the PDF document...
string filename = "PatientsDetail.pdf";

// ...and start a viewer.

The PdfForm object is created and using it, a new MigraDoc is generated. PdfDocumentRenderer renders the PDF document and then saves it. Process.Start(filename) starts a PDF viewer to open the PDF file created using MigraDoc.


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Pakistan Pakistan
No Biography provided

You may also be interested in...

Comments and Discussions

Member 842699112-Jun-13 19:14
memberMember 842699112-Jun-13 19:14 
GeneralMy vote of 5 Pin
Member 842699112-Jun-13 19:13
memberMember 842699112-Jun-13 19:13 
QuestionHow I can manage table content Pin
Member 100195416-May-13 1:05
memberMember 100195416-May-13 1:05 
Questionmultiple pages based on datatable Pin
pic-a5-Apr-13 5:03
memberpic-a5-Apr-13 5:03 
hi. i was wondering if the datatable that is supplied will generate a new page once the page can't handle all data?
AnswerRe: multiple pages based on datatable Pin
M.AFTAB.ALAM9-Apr-13 21:32
memberM.AFTAB.ALAM9-Apr-13 21:32 
QuestionExport unicode Pin
vhdysf10-Mar-13 20:40
membervhdysf10-Mar-13 20:40 
GeneralMy vote of 5 Pin
Shahan Ayyub6-Nov-12 23:32
memberShahan Ayyub6-Nov-12 23:32 
QuestionTable width Pin
Mike Fed27-Sep-12 10:39
memberMike Fed27-Sep-12 10:39 
AnswerRe: Table width Pin
M.AFTAB.ALAM27-Sep-12 21:14
memberM.AFTAB.ALAM27-Sep-12 21:14 
AnswerRe: Table width Pin
M.AFTAB.ALAM3-Oct-12 20:11
memberM.AFTAB.ALAM3-Oct-12 20:11 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web01 | 2.8.170713.1 | Last Updated 27 Mar 2012
Article Copyright 2012 by M.AFTAB.ALAM
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid