Forms Data Controls :: Converting A GridView To Excel Or PDF

I need to open a GridView as either an Excel or a PDF file. The excell prodecure is working fine, but I'm getting a: File does not begin with '%PDF-' error when trying to use the PDF file. The code is as follows:

Protected Sub EMButton_Click(ByVal sender
As Object,
ByVal e As System.Web.UI.ImageClickEventArgs)
Handles EMButton.Click
'Save the table to an excel File
Dim StringWriter
As New System.IO.StringWriter()
Dim html As
New System.Web.UI.HtmlTextWriter(StringWriter)
Dim form As HtmlForm =
New HtmlForm()
Page.Response.ContentType = "application/vnd.ms-excel"
Page.Response.Charset = ""
Page.Response.Cache.SetCacheability(HttpCacheability.NoCache)
Page.Response.AddHeader("content-disposition",
"attachment;filename=FullDateReport.xls")
Page.EnableViewState = False
form.Attributes("runat") =
"server"
Controls.Add(form)
form.Controls.Add(GridView1)
form.RenderControl(html)
Response.Write(StringWriter.ToString())
Response.End()
End Sub
[this doesn't work]
Protected Sub PDButton_Click(ByVal sender
As Object,
ByVal e As System.Web.UI.ImageClickEventArgs)
Handles PDButton.Click
'Save the table to PDF Format
Dim StringWriter
As New System.IO.StringWriter()
Dim html As
New System.Web.UI.HtmlTextWriter(StringWriter)
Dim form As HtmlForm =
New HtmlForm()
Page.Response.ContentType = "application/PDF"
Page.Response.Charset = ""
Page.Response.Cache.SetCacheability(HttpCacheability.NoCache)
Page.Response.AddHeader("content-disposition",
"attachment;filename=FullDateReport.pdf")
Page.EnableViewState = False
form.Attributes("runat") =
"server"
Controls.Add(form)
form.Controls.Add(GridView1)
form.RenderControl(html)
Response.Write(StringWriter.ToString())
Response.End()
End Sub
I've tried using:
Page.Response.Clear()
Page.Response.ContentEncoding = Encoding.Unicode
Page.Response.BinaryWrite(Encoding.Unicode.GetPreamble())
Page.Response.AddHeader("Content-Length", html.ToString().Length.ToString())

With the PDF procedure, but still couldn't get it to work. I've also tried using inline instead of attachment in the header.