Extracting gridview to pdf file.

rmuscare...

SOLVED CLOSED ACTIVE ANSWERED
User: rmuscarell
Posted: on Dec 14, 2011 10:20 PM
Forum: ASP.Net Web Forms
Answer: 3
Views: 10546

I referenced this page to get an idea of how to extract data from a gridview on a webpage.

http://www.aspsnippets.com/Articles/Export-GridView-To-Word-Excel-PDF-CSV-Formats-in-ASP.Net.aspx

I can extract to a Word, Excel and CSV but I can't to a pdf file. I get the following error:

Server Error in '/' Application.

Security Exception

Description: The application attempted to perform an operation not allowed by the security policy. To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file. Exception Details: System.Security.SecurityException: That assembly does not allow partially trusted callers. Source Error:

Line 135:        Response.Write(pdfDoc);
Line 136:        Response.End();  
Line 137: } Line 138:    
Line 139:    protected void btnExportCSV_Click(object sender, EventArgs e)

Source File: d:\hosting\7650435\html\admin\extractdata.cs Line: 137 Stack Trace:

[SecurityException: That assembly does not allow partially trusted callers.]
   CSharp.btnExportPDF_Click(Object sender, EventArgs e) in d:\hosting\7650435\html\admin\extractdata.cs:137
   System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) +115
   System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) +120
   System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +8431
   System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +253
   System.Web.UI.Page.ProcessRequest() +78
   System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) +21
   System.Web.UI.Page.ProcessRequest(HttpContext context) +49
   ASP.admin_insurancereport_aspx.ProcessRequest(HttpContext context) in App_Web_pscrvj2f.1.cs:0
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +100
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1

Mudassar

0 1

Reply
ANSWER
User: Mudassar
Replied: on Dec 14, 2011 10:29 PM
Report

Two ways

1. Allow Full Trust in Web.Config http://msdn.microsoft.com/en-us/library/wyts434y.aspx

2. If above is not possible then you will need to download Itextsharp source and recompile the dll by adding the following code to AssemblyInfo.cs file

using System.Security;
 using System.Security.Permissions;
[assembly: AllowPartiallyTrustedCallers]

rmuscare...

0 2

Reply
User: rmuscarell
Replied: on Dec 16, 2011 07:08 AM
Report

I used option 2 and it worked for me. One thing I did notice is if you Enable Sorting and export to PDF you end up getting an error but Word, Excel, and CSV work fine.

Unable to cast object of type 'iTextSharp.text.html.simpleparser.CellWrapper' to type 'iTextSharp.text.Paragraph'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.InvalidCastException: Unable to cast object of type 'iTextSharp.text.html.simpleparser.CellWrapper' to type 'iTextSharp.text.Paragraph'. Source Error:

Line 138:        PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
Line 139:        pdfDoc.Open();
Line 140: htmlparser.Parse(sr); Line 141:        pdfDoc.Close();
Line 142:        Response.Write(pdfDoc);

Source File: d:\hosting\7650435\html\admin\extractdata.cs Line: 140 Stack Trace:

[InvalidCastException: Unable to cast object of type 'iTextSharp.text.html.simpleparser.CellWrapper' to type 'iTextSharp.text.Paragraph'.]
   iTextSharp.text.html.simpleparser.HTMLWorker.ProcessLink() +672
   iTextSharp.text.html.simpleparser.HTMLTagProcessor_A.EndElement(HTMLWorker worker, String tag) +37
   iTextSharp.text.html.simpleparser.HTMLWorker.EndElement(String tag) +102
   iTextSharp.text.xml.simpleparser.SimpleXMLParser.ProcessTag(Boolean start) +176
   iTextSharp.text.xml.simpleparser.SimpleXMLParser.Go(TextReader reader) +2530
   iTextSharp.text.xml.simpleparser.SimpleXMLParser.Parse(ISimpleXMLDocHandler doc, ISimpleXMLDocHandlerComment comment, TextReader r, Boolean html) +84
   iTextSharp.text.html.simpleparser.HTMLWorker.Parse(TextReader reader) +61
   CSharp.btnExportPDF_Click(Object sender, EventArgs e) in d:\hosting\7650435\html\admin\extractdata.cs:140
   System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) +115
   System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) +120
   System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5563

Mudassar

0 3

Reply
ANSWER
User: Mudassar
Replied: on Dec 16, 2011 07:09 AM
Report

ITextSharp is still under development and it is yet to support many HTML and CSS properties.

There is no relation between (Word or Excel) and Itextsharp and both use different libraries

Adnaan

0 4

Reply
ANSWER
User: Adnaan
Replied: on Dec 16, 2011 07:31 AM
Report

Disable Sorting before exporting. Itextsharp does not support complex HTML and CSS. Use some other third party tool but I doubt there isn't any that's free

Extracting gridview to pdf file.

Server Error in '/' Application.

Security Exception

Unable to cast object of type 'iTextSharp.text.html.simpleparser.CellWrapper' to type 'iTextSharp.text.Paragraph'.

Company

Explore

Follow us

Contact Us