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

Eyes Dropper

PDF Duo .Net

Databeam Excel .Net

Databeam Word .Net

Eyes Dropper

PDF Duo .Net

Databeam Excel .Net

Databeam Word .Net

Eyes Dropper

PDF Duo .Net
On-line documentation

Databeam Excel .Net
On-line documentation

Databeam Word .Net
On-line documentation

Eyes Dropper
On-line documentation

About Us

Contact Us

PDF Duo .Net component

» Overview

» Download

» [Purchase]

PDF Duo .Net component Guid

» 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

The association of development high-quality ASP.NET components

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 07, 2009

	PDF Duo .Net component 2.3
	• Changed the parsing algorithms for Header/Footer.

	November 15, 2009

	PDF Duo .Net component 2.3
	• Component update - fixed table borders and its colors.

	November 02, 2009

	PDF Duo .Net component 2.3
	• Improved translation of tables from HTML into PDF document.

	October 19, 2009

	PDF Duo .Net component 2.3
	• Fixed parsing of special symbols from HTML. • Completed dividing of HTML text on pages in PDF document.

	October 05, 2009

	PDF Duo .Net component 2.3
	• New features of changing text attribute of entire PDF.

	September 11, 2009

	PDF Duo .Net component 2.3
	• New version! • New properties HEADER/FOOTER.

	September 01, 2009

	PDF Duo .Net component 2.2
	• Improved the algorithm of the stream compilation.

	August 15, 2009

	PDF Duo .Net component 2.2
	• Changed the calculation of the line height. • Fixed problem with big pictures.

	August 02, 2009

	PDF Duo .Net component 2.2
	• Corrected the converting of attribute height

	all news...

Create the PDF report from Database Table

PDF Duo .Net component Tutorial with code example

C# + ASP.NET example