export gridview to pdf format in asp.net

Question

4.00/5 (2 votes)

See more:

Hi Experts,

I am trying to export the Gridview data into pdf format I am getting this error "Unable to cast object of type 'iTextSharp.text.html.simpleparser.CellWrapper' to type 'iTextSharp.text.Paragraph'" how to solve this issue.

Here is the code I am using.

C#

Response.ContentType = "application/pdf";
                Response.AddHeader("content-disposition",
                                        "attachment;filename=EmpDetails.pdf");
                Response.Cache.SetCacheability(HttpCacheability.NoCache);
                StringWriter sw = new StringWriter();
                HtmlTextWriter hw = new HtmlTextWriter(sw);
                griddetails.AllowPaging = false;
                griddetails.DataBind();
                griddetails.RenderControl(hw);
                griddetails.HeaderRow.Style.Add("width", "15%");
                griddetails.HeaderRow.Style.Add("font-size", "10px");
                griddetails.Style.Add("text-decoration", "none");
                griddetails.Style.Add("font-family", "Arial, Helvetica, sans-serif;");
                griddetails.Style.Add("font-size", "8px");
                StringReader sr = new StringReader(sw.ToString());
                iTextSharp.text.Document pdfDoc =
              new iTextSharp.text.Document(PageSize.A4, 7f, 7f, 7f, 0f);
                iTextSharp.text.html.simpleparser.HTMLWorker htmlparser = new
              iTextSharp.text.html.simpleparser.HTMLWorker(pdfDoc);
                PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
                pdfDoc.Open();
                htmlparser.Parse(sr);// Here I am getting the error
                pdfDoc.Close();
                Response.Write(pdfDoc);
                Response.End();

Kindly Share your thoughts.

Posted 7-Mar-13 22:30pm

krish2013

Updated 8-Mar-13 0:47am

D-Kishore

v8

Add a Solution

Comments

kishore sharma 12-Mar-13 8:05am

why dont you check with jquery datatable tools there you will have client side export to excel,export to pdf also, link is here try this
http://datatables.net/extras/tabletools/

5 solutions

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)

ravi kumar gupta · Answer 1 · 2013-03-08T03:07:00

Solution 1

There are two ways 1) get the result in to crystal report and export to PDF method 2) Use any third party control to export. there is no direct way

Posted 8-Mar-13 3:07am

ravi kumar gupta

Pallavi Waikar · Answer 2 · 2013-03-08T04:12:00

u have to make some changes in code..use following code

Response.ContentType = "application/pdf";
     Response.AddHeader("content-disposition", "attachment;filename=UserDetails.pdf");
     Response.Cache.SetCacheability(HttpCacheability.NoCache);
     StringWriter sw = new StringWriter();
     HtmlTextWriter hw = new HtmlTextWriter(sw);

     gvdetails.AllowPaging = false;
     gvdetails.DataBind();
     gvdetails.RenderBeginTag(hw);
     gvdetails.HeaderRow.RenderControl(hw);
     foreach (GridViewRow row in gvdetails.Rows)
     {
         row.RenderControl(hw);
     }
     gvdetails.FooterRow.RenderControl(hw);
     gvdetails.RenderEndTag(hw);
     gvdetails.Caption = "Your caption";
     gvdetails.HeaderRow.Style.Add("width", "15%");
     gvdetails.HeaderRow.Style.Add("font-size", "10px");
     gvdetails.Style.Add("text-decoration", "none");
     gvdetails.Style.Add("font-family", "Arial, Helvetica, sans-serif;");
     gvdetails.Style.Add("font-size", "8px");
     StringReader sr = new StringReader(sw.ToString());
     Document pdfDoc = new Document(PageSize.A2, 7f, 7f, 7f, 0f);
     HTMLWorker htmlparser = new HTMLWorker(pdfDoc);
     PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
     pdfDoc.Open();
     htmlparser.Parse(sr);
     pdfDoc.Close();
     Response.Write(pdfDoc);
     Response.End();

i have refer answer 5 from following link.
http://stackoverflow.com/questions/6343630/gridview-must-be-placed-inside-a-form-tag-with-runat-server-even-after-the-gri[^]

or in ur code page add following code block and use ur code as it is

C#

public override void VerifyRenderingInServerForm(Control control)
   {
       /* Verifies that the control is rendered */
   }

solanki.net · Answer 3 · 2013-03-10T20:33:00

Try like this :

protected void imgExcel_Click(object sender, ImageClickEventArgs e)
{
gvEmp.AllowPaging = false;
gvEmp.DataBind();
Response.ClearContent();
Response.AddHeader("Content-disposition", string.Format("attachment;filename={0}", "Emp"));
Response.Charset = "";
Response.ContentType = "application/pdf";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
gvEmp.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}

public override void VerifyRenderingInServerForm(Control control)
{
// base.VerifyRenderingInServerForm(control);
}

Hari Krishna Prasad Inakoti · Answer 4 · 2013-05-07T19:41:00

@Krish,
If you have any special symbols in your gridview in that time only we will get error.
@Page Directive u can change some modifications like this

]]>

add EnableEventValidation="false" then only your problem will rectify.Try like this.Hopes it will work to you..

Thanks&Regards
Hari

AnilKumar Kakkerla · Answer 5 · 2013-08-06T21:21:00

Solution 6

StringReader sr = new StringReader(sw.ToString());

replace the code as

StreamReader sr=new StreamReader(new MemoryStream(Encoding.ASCII.GetBytes(sw.ToString())));

Posted 6-Aug-13 21:21pm

AnilKumar Kakkerla

export gridview to pdf format in asp.net

5 solutions

Solution 1

Solution 2

Solution 3

Solution 5

Solution 6

Add your solution here

Preview 0