protected void btnGeneratePDFClickobject sender EventArgs e try string sess Session34LogId34ToString sqlCon new SqlConnectionconString sqlCom new SqlCommand34uspInvoiceMaster34 sqlCon sqlComCommandType CommandTypeStoredProcedure sqlComParametersAddWithValue34Type34 34PDF34 sqlComParametersAddWithValue34I

iTextSharp: How to convert HTML Table string to PDF using C# .Net

Hadees

SOLVED CLOSED ACTIVE ANSWERED
User: Hadees
Posted: on May 21, 2014 01:51 AM
Forum: ASP.Net Thirdparty controls
Answer: 1
Views: 43522

 protected void btnGeneratePDF_Click(object sender, EventArgs e)
        {
            try
            {
                string sess = Session["LogId"].ToString();
                sqlCon = new SqlConnection(conString);
                sqlCom = new SqlCommand("usp_Invoice_Master", sqlCon);
                sqlCom.CommandType = CommandType.StoredProcedure;
                sqlCom.Parameters.AddWithValue("@Type", "PDF");
                //sqlCom.Parameters.AddWithValue("@Inv_No",ViewState["Invoice"].ToString());
                if (sqlCon.State == ConnectionState.Broken || sqlCon.State == ConnectionState.Closed)
                    sqlCon.Open();
                SqlDataAdapter da = new SqlDataAdapter(sqlCom);
                sqlCon.Close();
                DataTable dt = new DataTable();
                da.Fill(dt);
                string msg = string.Empty;
                if (dt.Rows.Count > 0)
                {

                    msg += "<p style=\"font-family:verdana; font-size:13px; color:#161616;\">Artha Travels</p>";
                    msg += "<p>Invoice</p>";

                    msg += "<table width='600px' cellspacing='0' cellpadding='5' border='1'> ";
                    msg += "This is testing";
                    msg += "<tr>";
                    msg += "<td>" + dt.Rows[0]["Invoice No"].ToString() + "</td>";
                    msg += "<td>" + dt.Rows[0]["Client Name"].ToString() + "</td>";
                    msg += "<td>" + dt.Rows[0]["Trip Id"].ToString() + "</td>";
                    msg += "<td>" + dt.Rows[0]["Trip Type"].ToString() + "</td>";
                    msg += "<td>" + dt.Rows[0]["Trip Details"].ToString() + "</td>";
                    msg += "<td>" + dt.Rows[0]["Car Details"].ToString() + "</td>";
                    msg += "<td>" + dt.Rows[0]["Total Ammount"].ToString() + "</td>";
                    msg += "<td>" + dt.Rows[0]["Balance Ammount"].ToString() + "</td>";
                    msg += "</tr>";


                    msg += "</table>";
                    msg += "<p></p>";

                    var doc1 = new iTextSharp.text.Document();

                    string path = Server.MapPath("~/Invoices/Pdf");

                    string pdffilename = "Invoice " + dt.Rows[0]["Invoice No"] + "(" + DateTime.Now.ToString("dd-MM-yyyy") + ")" + ".pdf";

                    PdfWriter.GetInstance(doc1, new FileStream(path + "/" + pdffilename, FileMode.Create));

                    doc1.Open();


                    iTextSharp.text.html.simpleparser.StyleSheet styles = new iTextSharp.text.html.simpleparser.StyleSheet();

                    iTextSharp.text.html.simpleparser.HTMLWorker hw = new iTextSharp.text.html.simpleparser.HTMLWorker(doc1);


                    //  hw.Parse(new StringReader(msg));

                    doc1.Close();
     }




            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString());
            }
            finally
            {
                if (sqlCon.State == ConnectionState.Open)
                {
                    sqlCon.Close();
                }
            }
        }

i am getting error "input string was not in correct format" plz help

as i visited a lot of site but not useful for me thank you

Download FREE API for Word, Excel and PDF in ASP.Net

Mudassar

0 5

Reply
ANSWER
User: Mudassar
Replied: on May 22, 2014 06:54 AM
Report

You will need to make use of PdfPTable class of iTextSharp as iTextSharp does not support HTML Table. I have created a small sample to explain.

HTML

<asp:Button  runat="server" Text="String to PDF" OnClick="StringToPdf" />

Namespace

using System.Data;
using System.IO;
using iTextSharp.text;
using iTextSharp.text.html.simpleparser;
using iTextSharp.text.pdf;

protected void StringToPdf(object sender, EventArgs e)
{
    //Dummy DataTable
    DataTable dt = new DataTable();
    dt.Columns.AddRange(new DataColumn[3] { new DataColumn("Id", typeof(int)),
                        new DataColumn("Name", typeof(string)),
                        new DataColumn("Country",typeof(string)) });
    dt.Rows.Add(1, "John Hammond", "United States");
    dt.Rows.Add(2, "Mudassar Khan", "India");
    dt.Rows.Add(3, "Suzanne Mathews", "France");
    dt.Rows.Add(4, "Robert Schidner", "Russia");

    string html = string.Empty;
    html += "<p style='font-family:verdana; font-size:23px; color:#FF0000'>ASPForums.Net Sample</p>";
    html += "<br />";

    //Creating iTextSharp Table from the DataTable data
    PdfPTable pdfTable = new PdfPTable(dt.Columns.Count);
    pdfTable.DefaultCell.Padding = 3;
    pdfTable.WidthPercentage = 30;
    pdfTable.HorizontalAlignment = Element.ALIGN_LEFT;
    pdfTable.DefaultCell.BorderWidth = 1;

    //Adding Header Row
    foreach (DataColumn column in dt.Columns)
    {
        PdfPCell cell = new PdfPCell(new Phrase(column.ColumnName));
        cell.BackgroundColor = Color.YELLOW;
        pdfTable.AddCell(cell);
    }
        
    //Adding Data Rows
    foreach (DataColumn column in dt.Columns)
    {
        foreach (DataRow row in dt.Rows)
        {
            pdfTable.AddCell(row[column.ColumnName].ToString());
        }
    }        

    using (StringWriter sw = new StringWriter())
    {
        using (HtmlTextWriter hw = new HtmlTextWriter(sw))
        {
            StringReader sr = new StringReader(html);
            Document pdfDoc = new Document(PageSize.A2, 10f, 10f, 10f, 0f);
            HTMLWorker htmlparser = new HTMLWorker(pdfDoc);
            PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
            pdfDoc.Open();
            htmlparser.Parse(sr);
            pdfDoc.Add(pdfTable);
            pdfDoc.Close();
            Response.ContentType = "application/pdf";
            Response.AddHeader("content-disposition", "attachment;filename=HTMLExport.pdf");
            Response.Cache.SetCacheability(HttpCacheability.NoCache);
            Response.Write(pdfDoc);
            Response.End();
        }
    }
}

Screenshot

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

iTextSharp: How to convert HTML Table string to PDF using C# .Net

Company

Explore

Follow us

Contact Us