No display of data in the C# code for pdf generation

Question

0.00/5 (No votes)

See more:

, +

public string HTMLToPdf(_TableProperty ReportProperty, string FilePath,Stream stream)
       {
           string htmlread2 = getReportHTML(ReportProperty, stream);
           Document document = new Document();
           PdfWriter.GetInstance(document, new FileStream(System.Web.HttpContext.Current.Request.PhysicalApplicationPath + "C:\\HRMS OSN\\latest\\HRMS\\admpanel\\myPDF.pdf", FileMode.Create));
           document.Open();
           iTextSharp.text.Image pdfImage = iTextSharp.text.Image.GetInstance(System.Web.HttpContext.Current.Server.MapPath("pdfic.jpg"));

           pdfImage.ScaleToFit(100, 50);

           pdfImage.Alignment = iTextSharp.text.Image.UNDERLYING; pdfImage.SetAbsolutePosition(180, 760);

           document.Add(pdfImage);
           iTextSharp.text.html.simpleparser.StyleSheet styles = new iTextSharp.text.html.simpleparser.StyleSheet();
           iTextSharp.text.html.simpleparser.XHTMLWorker hw = new iTextSharp.text.html.simpleparser.XHTMLWorker(document);
           hw.Parse(new StringReader(htmlread2));
           document.Close();
           ShowPdf("C:\\HRMS OSN\\latest\\HRMS\\admpanel\\myPDF.pdf");
           return htmlread2;
       }

       private void ShowPdf(string s)
       {
           System.Web.HttpContext.Current.Response.ClearContent();
           System.Web.HttpContext.Current.Response.ClearHeaders();
           System.Web.HttpContext.Current.Response.AddHeader("Content-Disposition", "inline;filename=" + s);
           System.Web.HttpContext.Current.Response.ContentType = "application/pdf";
           System.Web.HttpContext.Current.Response.WriteFile(s);
           System.Web.HttpContext.Current.Response.Flush();
           System.Web.HttpContext.Current.Response.Clear();
       }

Posted 9-Jul-13 1:38am

Mausam Bharati

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

**Nirav Prabtani** · Answer 1 · 2013-07-09T01:39:00

Solution 1

try this...:)

Generate PDF Using C#[^]

Posted 9-Jul-13 1:39am

Nirav Prabtani

Comments

Mausam Bharati 9-Jul-13 7:45am

I am sorry but this ain't my problem. The issue is that the pdf page gets generated but no data gets displayed over it. Perhaps it is not reading the table from the database.

Mausam Bharati 9-Jul-13 7:47am

http://www.codeproject.com/Questions/203481/HTML-convert-to-PDF-using-itextsharp

I have taken this code as reference.

Nirav Prabtani 9-Jul-13 7:49am

where did you provide data to make PDF????

Mausam Bharati 9-Jul-13 7:50am

This code is a function of a dll.The string htmlread2 is called from the other function.
using System;
using System.Collections;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections.Generic;
using System.IO;
using iTextSharp.text.html.simpleparser;
using iTextSharp;
using iTextSharp.text.pdf;
using iTextSharp.text;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.SessionState;

namespace ReportLib
{
public class PDFReport
{
public struct _TableProperty
{
public string ReportTable { get; set; }
public Dictionary<string, string=""> Columns;
public string ReportCondition { get; set; }
}

public _TableProperty ReportProperty = new _TableProperty();

public string getReportHTML(_TableProperty tableProperty, Stream stream)
{
string sql = "select ";
string columnAdd="<table><tr>";

foreach (var column in tableProperty.Columns)//emp-Employee,b-2,c-3
{

sql += "["+column.Key+"]" + " as [" + column.Value + "],";
columnAdd += "<th> "+column.Value+" </th>";

}
columnAdd += "</tr>";
sql=sql.TrimEnd(',');
sql += " from " + tableProperty.ReportTable;
sql = sql + " where 1=1 " + (string.IsNullOrEmpty(tableProperty.ReportCondition) ? "" : "and " + tableProperty.ReportCondition);

SqlConnection _con = new SqlConnection(@"server=mausam-pc\sqlexpress;uid=sa;pwd=ngc;initial catalog=HRMSN");
SqlCommand _cmd = new SqlCommand(sql, _con);
_con.Open();
SqlDataReader _reader = _cmd.ExecuteReader();

while (_reader.Read())
{
columnAdd += "<tr>";
foreach (var column in tableProperty.Columns)
{
columnAdd += "<td>" + _reader[_reader.GetOrdinal(column.Value)] + "</td>";
//columnAdd += _reader.GetOrdinal(column.Value);
}
columnAdd += "</tr>";
}
columnAdd += "</table></tr>";
string htmlread = "<html><title>General</title><body>"+ columnAdd +"</body></html>";

if (_reader != null)
{
_reader.Close();
}
_con.Close();
return htmlread;

}

public string HTMLToPdf(_TableProperty ReportProperty, string FilePath,Stream stream)
{
string htmlread2 = getReportHTML(ReportProperty, stream);
Document document = new Document();
PdfWriter.GetInstance(document, new FileStream(System.Web.HttpContext.Current.Request.PhysicalApplicationPath + "\\myPDF.pdf", FileMode.Create));
document.Open();
iTextSharp.text.Image pdfImage = iTextSharp.text.Image.GetInstance(System.Web.HttpContext.Current.Server.MapPath("pdfic.jpg"));

pdfImage.ScaleToFit(100, 50);

pdfImage.Alignment = iTextSharp.text.Image.UNDERLYING; pdfImage.SetAbsolutePosition(180, 760);

document.Add(pdfImage);
iTextSharp.text.html.simpleparser.StyleSheet styles = new iTextSharp.text.html.simpleparser.StyleSheet();
iTextSharp.text.html.simpleparser.XHTMLWorker hw = new iTextSharp.text.html.simpleparser.XHTMLWorker(document);
hw.Parse(new StringReader(htmlread2));
document.Close();
ShowPdf("myPDF.pdf");
return htmlread2;
}

private void ShowPdf(string s)
{
System.Web.HttpContext.Current.Response.ClearContent();
System.Web.HttpContext.Current.Response.ClearHeaders();
System.Web.HttpContext.Current.Response.AddHeader("Content-Disposition", "inline;filename=" + s);

Mausam Bharati 9-Jul-13 7:51am

Excuse any error..I am a beginner. :(

Nirav Prabtani 9-Jul-13 7:55am

what is error generated???

Mausam Bharati 9-Jul-13 7:57am

There is no error.A blank pdf page is generated.

protected void txtPDF_Click(object sender, EventArgs e)
{

PDFReport pdfReport = new PDFReport();
pdfReport.ReportProperty.ReportTable = "Bill";

pdfReport.ReportProperty.Columns = new System.Collections.Generic.Dictionary<string, string="">();

pdfReport.ReportProperty.Columns.Add("Emp Code", "Employee Code");
pdfReport.ReportProperty.Columns.Add("Status", "Employee Status");
pdfReport.ReportProperty.Columns.Add("Bill Type", "Employee BillType");
pdfReport.ReportProperty.Columns.Add("Financial Yr", "Financial Year");
pdfReport.ReportProperty.Columns.Add("Bill Date", "Bill Date From");
pdfReport.ReportProperty.Columns.Add("Approve Date", "Bill Date To");
Literal1.Text = pdfReport.HTMLToPdf(pdfReport.ReportProperty, "C:\\temp.pdf",Response.OutputStream);

}

this is my on button click event.

H.Brydon 9-Jul-13 11:04am

You should ask your question in the questions/remarks section for this project.