Click here to Skip to main content
Click here to Skip to main content

Exporting a DataTable to PDF

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

pdf

Introduction

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";

    DefineStyles();
    CreatePage();
    FillContent();
    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].AddParagraph(dt.Columns[i].ColumnName);
        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  

row.Cells[i].AddParagraph(dt.Columns[i].ColumnName);
//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;
            row1.Cells[j].AddParagraph(dt.Rows[i][j].ToString());

            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:

row1.Cells[j].AddParagraph(dt.Rows[i][j].ToString());
//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
pdfRenderer.RenderDocument();

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

pdfRenderer.Save(filename);
// ...and start a viewer.
Process.Start(filename);

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.

License

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

Share

About the Author

M.AFTAB.ALAM

Pakistan Pakistan
No Biography provided

Comments and Discussions

 
Questionpdf creator PinmemberMember 1078543516-May-14 22:17 
QuestionException PinmemberMember 99199115-Mar-14 3:21 
QuestionUsing a Dataset PinmemberMember 99199115-Mar-14 1:08 
Questioncreate password to PDF file PinmemberIshaqSalam10-Dec-13 21:25 
AnswerRe: create password to PDF file PinmemberHeeut21-Apr-14 22:28 
QuestionExporting a DataTable to PDF (VB.net) PinmemberIshaqSalam8-Dec-13 22:14 
AnswerRe: Exporting a DataTable to PDF (VB.net) Pinmemberhongdida9-Dec-13 16:59 
QuestionNICE ARTICLE PinmemberMember 842699112-Jun-13 19:14 
AnswerMessage Removed PinmemberMember 842699112-Jun-13 19:15 
GeneralMy vote of 5 PinmemberMember 842699112-Jun-13 19:13 
VERY GREAT WOW
QuestionHow I can manage table content PinmemberMember 100195416-May-13 1:05 
Questionmultiple pages based on datatable Pinmemberpic-a5-Apr-13 5:03 
AnswerRe: multiple pages based on datatable PinmemberM.AFTAB.ALAM9-Apr-13 21:32 
QuestionExport unicode Pinmembervhdysf10-Mar-13 20:40 
GeneralMy vote of 5 PinmemberShahan Ayyub6-Nov-12 23:32 
QuestionTable width PinmemberMike Fed27-Sep-12 10:39 
AnswerRe: Table width PinmemberM.AFTAB.ALAM27-Sep-12 21:14 
AnswerRe: Table width [modified] PinmemberM.AFTAB.ALAM3-Oct-12 20:11 
QuestionPortrait vs Lanscape PinmemberMike Fed25-Sep-12 9:05 
AnswerRe: Portrait vs Lanscape PinmemberM.AFTAB.ALAM25-Sep-12 20:16 
GeneralRe: Portrait vs Lanscape PinmemberMike Fed27-Sep-12 9:47 
GeneralGood Project~ can export to PDF with more than 1 pages? [modified] PinmemberHT Ng23-Jul-12 21:59 
GeneralRe: Good Project~ can export to PDF with more than 1 pages? PinmemberM.AFTAB.ALAM23-Jul-12 23:50 
GeneralRe: Good Project~ can export to PDF with more than 1 pages? [modified] PinmemberHT Ng23-Jul-12 23:54 
GeneralRe: Good Project~ can export to PDF with more than 1 pages? PinmemberM.AFTAB.ALAM24-Jul-12 18:24 

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

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

| Advertise | Privacy | Mobile
Web03 | 2.8.141022.2 | Last Updated 27 Mar 2012
Article Copyright 2012 by M.AFTAB.ALAM
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid