PDF Duo. Net Tutorial: Convert Database table to PDF document

Convert HTML to PDF in ASP.NET
Code Examples C# VB.NET

PDF Duo .Net

Databeam Excel .Net

Databeam Word .Net

PDF Duo .Net

Databeam Excel .Net

Databeam Word .Net

PDF Duo .Net

Databeam Excel .Net

Databeam Word .Net

PDF Duo .Net
On-line documentation

Databeam Excel .Net
On-line documentation

Databeam Word .Net
On-line documentation

About Us

Contact Us

PDF Duo .Net component

» Overview

» Download

» [Purchase]

PDF Duo .Net component Guide

» Getting Started

» History

» Pricing

» Support and Contacts

» [Documentation]

Code Examples

» Create PDF using HTML string

» Can't computer Image Path

» Create PDF from Database Table

Membership

Software Industry Professionals

Organization of Independent Software Vendors

pdf duo 11 pdf duo 20 pdf duo 22

Create the PDF report from Database Table PDF Duo .Net component Tutorial with code example

Task:
Create the Report with data from SQL Database. Represent report as HTML in browser window then save its copy in the server archive as a PDF document.

Directions:
Add PDF Duo .Net component to the project. Initialize the HtmlToPdf instance. Set up the connection with SQL database & select data from the table. Compose HTML page with table that includes values from database. Convert HTML to PDF document with help of the SavePDF function

Source code (ASP.NET + C#):
Download "create pdf from database table .zip"

C# + ASP.NET example

public partial class _Default : System.Web.UI.Page { private SqlConnection con = new SqlConnection( ConfigurationManager.ConnectionStrings["SQLConnection"].ConnectionString); private SqlCommand comm = new SqlCommand(); private SqlDataReader dreader; protected void Page_Load(object sender, EventArgs e) { int total = 0; // read data from data base table comm.Connection = con; comm.CommandText = "select * from Products"; try { con.Open(); dreader = comm.ExecuteReader(); while (dreader.Read()) { TableRow row = new TableRow(); Table1.Rows.Add(row); row.Cells.Add(new TableCell()); row.Cells[0].Text = "id " + dreader["pkey"].ToString(); row.Cells.Add(new TableCell()); row.Cells[1].Text = dreader["product_name"].ToString(); row.Cells.Add(new TableCell()); row.Cells[2].Text = ((DateTime)dreader["date"]).ToShortDateString(); row.Cells.Add(new TableCell()); row.Cells[3].Text = dreader["amount"].ToString(); total += (int)dreader["amount"]; } Label2.Text = total.ToString(); Label3.Text = total.ToString(); con.Close(); } catch { } // get html code of the report StringWriter objStringWriter = new StringWriter(); HtmlTextWriter objHtmlWriter = new HtmlTextWriter(objStringWriter); Panel1.RenderControl(objHtmlWriter); string html_form = objStringWriter.ToString(); // convert to pdf try { DuoDimension.HtmlToPdf conv = new DuoDimension.HtmlToPdf(); conv.OpenHTML(html_form); conv.SavePDF(MapPath("~/Pdf/") + "test.pdf"); } catch {} }


Components News

	December 14, 2011

	PDF Duo .Net component 2.4
	• New algorithm of list rendering at HTML to PDF converting. • Fixed the issue of indent in list writing to PDF.

	November 18, 2011

	PDF Duo .Net component 2.4
	• Improved the CSS parser. • Added the parsing of tabs.

	November 02, 2011

	PDF Duo .Net component 2.4
	• Improved rendering of images in the PDF document. • Fixed issues of image alignment. • Fixed issues of carrying the image over to the next line.

	October 27, 2011

	PDF Duo .Net component 2.4
	• Fixed text alignment in PDF. • Updated the class contening paragraph styles of HTML.

	October 11, 2011

	PDF Duo .Net component 2.4
	• Fixed the converting of tables in Footer/Header. • Fixed issue of cell splitting at rendering PDF file.

	September 23, 2011

	PDF Duo .Net component 2.4
	• Excluded the issue of converting TIFF images to PDF

	September 05, 2011

	PDF Duo .Net component 2.4
	• Fixed center alignment in PDF document. • Fixed issue of underlinestyle in PDF.

	August 22, 2011

	PDF Duo .Net component 2.4
	• Fixed issue of converting GIF files to PDF from HTML. • Optimized functions of PDF writing.

	all news...

Create the PDF report from Database Table

PDF Duo .Net component Tutorial with code example

C# + ASP.NET example