Data Presentation Controls

Re: export gridview to pdf

karanpaul — Sat, 23 Aug 2008 07:35:29 GMT

hi Quin Dian Tang,,

Thanks a lot for help in conversion to pdf.

Did u get solution for the the following doubt :

"This code opens de PDF document in a window. What do i have to do to "save the document" automatically to the client? (i mean asking the user if he wants to save, etc)"

if at all ur success with that can u please help me out

Thanks

Paul

Re: export gridview to pdf

RutuPrash — Tue, 22 Jul 2008 13:28:35 GMT

Hi WOP_NUNO,

I am too stuck on export gridview to PDF. can u pl post ur relevant code of exporting gridview to pdf . Well I have used some of ur code but still something is missing so pl post ur working code. that will really help me my project work going on.

Thanks,

Prashant V.

Re: export gridview to pdf

wop_nuno — Thu, 12 Jun 2008 09:18:50 GMT

Hi Quin Dian Tang,

It's now working. Thanks for all you're help!!!

Thanks very much.

Nuno

Re: export gridview to pdf

Qin Dian Tang - MSFT — Thu, 12 Jun 2008 03:10:59 GMT

Hi wop_nuno,

Add this line:

HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;FileName=" + filename + ".pdf")

You have to give the file name (string).

Thanks,

Re: export gridview to pdf

wop_nuno — Wed, 11 Jun 2008 12:16:20 GMT

Hi all,

I've found a way to get this working. I have to add two things.

First this code:

The code for the VerifyRenderingInServerForm is just this:

Public Overrides Sub VerifyRenderingInServerForm(ByVal control As Control)
Return

End Sub

Second: i had to EnableEventValidation = "false"

Now i have one more question:

1) This code opens de PDF document in a window. What do i have to do to "save the document" automatically to the client? (i mean asking the user if he wants to save, etc)

Thanks.

Re: export gridview to pdf

wop_nuno — Wed, 11 Jun 2008 10:28:39 GMT

I've added the namespace but i still getone error. My code is this:

    Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click

        'Get the HTML from GridView1
        Dim sw As New IO.StringWriter()
        Dim htw As New HtmlTextWriter(sw)
        GridView1.RenderControl(htw)
        Dim html As String = "<html><body>" + sw.ToString() + "</body></html>"

        'Set up the response
        Response.Clear()
        Response.ContentType = "application/pdf"

        'Create pdf document
        Dim document As New iTextSharp.text.Document(PageSize.A4, 80, 50, 30, 65)

        'Create pdf writer, output directly to OutputStream
        Dim writer As iTextSharp.text.pdf.PdfWriter = PdfWriter.GetInstance(document, Response.OutputStream)
        Document.Open()
        'Create tempfile to hold the HTML:
        Dim tempFile As String = Path.GetTempFileName()
        Using tempwriter As New IO.StreamWriter(tempFile, False)
            tempwriter.Write(html)
        End Using

        'Parse the HTML into the document
        HtmlParser.Parse(Document, tempFile)

        'Cleanup
        Document.Close()
        writer.Close()

        'Delete the tempfile:
        File.Delete(tempFile)

        writer = Nothing
        Document = Nothing
        Response.[End]()

End Sub

The error is this:

Control 'GridView1' of type 'GridView' must be placed inside a form tag with runat=server.

On this line

GridView1.RenderControl(htw)

What else do you suggest?

Thanks for all the help.

Re: export gridview to pdf

Qin Dian Tang - MSFT — Wed, 11 Jun 2008 09:40:06 GMT

Hi wop_nuno,

Add namespace "iTextSharp.Text.Html" into your application.

Thanks,

Re: export gridview to pdf

wop_nuno — Wed, 11 Jun 2008 09:07:54 GMT

Hi Qin Dian Tang

Yes i've put the dll in the bin folder. I've downloaded the dll from here http://itextsharp.sourceforge.net/

Now i only have 2 errors:

Response.ContentType = "application/pdf"

        'Create pdf document
        Dim document As New iTextSharp.text.Document(PageSize.A4, 80, 50, 30, 65)

        'Create pdf writer, output directly to OutputStream
        Dim writer As iTextSharp.text.pdf.PdfWriter = PdfWriter.GetInstance(document, Response.OutputStream)
        document.Open()
        'Create tempfile to hold the HTML:
        Dim tempFile As String = Path.GetTempFileName()
        Using tempwriter As New IO.StreamWriter(tempFile, False)
            tempwriter.Write(html) --> 'iTextSharp.text.html' is a namespace and cannot be used as an expression
        End Using

        'Parse the HTML into the document
        HtmlParser.Parse(document, tempFile) --> Name 'HtmlParser' is not declared.

        'Cleanup
        document.Close()
        writer.Close()

        'Delete the tempfile:
        File.Delete(tempFile)

        writer = Nothing
        document = Nothing
        Response.[End]()

Does any one knows why i'm having this errors?

Thanks.

Re: export gridview to pdf

Qin Dian Tang - MSFT — Wed, 11 Jun 2008 01:31:01 GMT

Hi wop_nuno,

Have you put dll file into bin folder in your web application? Based on my knowledge if you do everything I told you, it should work fine. You can check whether you download the right version of itextsharp.

Thanks,

Re: export gridview to pdf

wop_nuno — Tue, 10 Jun 2008 12:15:05 GMT

Hi Qin Dian Tang,

thanks for the reply, but like i said in my previous post i've already done that (even with the VB code) and still doesn't work.

So your post didn't solve my problem, therefore it's not an answer.

Thanks.

Re: export gridview to pdf

Qin Dian Tang - MSFT — Tue, 10 Jun 2008 02:34:04 GMT

Hi wop_nuno,

You use vb code, so it should be:

Imports System.IO
Imports iTextSharp
Imports iTextSharp.text
Imports iTextSharp.text.pdf

Make sure you have added ITextSharp.DLL as a reference as HeartattacK and blurearc said in above replies.

Thanks,

Re: export gridview to pdf

wop_nuno — Tue, 10 Jun 2008 02:22:47 GMT

Hi Qin Dian Tang,

I've done what you said and i always get the same error messages.

Do you know what else could be causing this error?

Thanks.

Nuno

Re: export gridview to pdf

Qin Dian Tang - MSFT — Tue, 10 Jun 2008 01:51:04 GMT

Hi wop_nuno,

Like adding a general namespace you just need to do this:

using System.IO;
using iTextSharp;
using iTextSharp.text;
using iTextSharp.text.pdf;

Thanks,

Re: export gridview to pdf

wop_nuno — Mon, 09 Jun 2008 09:02:20 GMT

Hi Qin Dian Tang,

Thanks for the reply, but can you explain in detail what you want me to do?

I'm quiet new to all this thing, so if you could explain it to me, i would really appreciate.

Thanks.

Re: export gridview to pdf

Qin Dian Tang - MSFT — Mon, 09 Jun 2008 02:33:44 GMT

Hi wop_nuno,

Please add namespace of this third party component into your application.

Thanks,