Export DetailsView to Excel in ASP.Net

Question

I want to dowload my detail view form it is on my database when i select the key from it turns to my detail view page n i want to download that detail view form how can i do this

Pradip · Accepted Answer

Try This ResponseClear            ResponseCharset  3434            ResponseAddHeader34contentdisposition34 34attachmentfilenamereportxls34            ResponseContentType  34applicationvndxls34            ResponseCacheSetCacheabilityHttpCacheabilityNoCache            Dim stringWrite As New SystemIOStringWriter            Dim htmlWrite As SystemWebUIHtmlTextWriter  New HtmlTextWriterstringWrite            ExcelWorddetailsviewRenderControlhtmlWrite            ResponseWritestringWriteToString            ResponseEnd          Catch ex As Exception

saifali · Answer

Ya i do this but it give me error that it must be placed inside the form tag but i have one form tag on my master page so m not able to apply form tag here Server Error in  ApplicationControl MainContentDetailsView1 of type DetailsView must be placed inside a form tag with runatserverDescription 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 SystemWebHttpException Control MainContentDetailsView1 of type DetailsView must be placed inside a form tag with runatserverSource Error Line 38             DetailsView1AllowPaging  falseLine 39             DetailsView1DataBindLine 40 DetailsView1RenderControlhw Line 41             ResponseOutputWriteswToStringLine 42             ResponseFlush

Pradip · Answer

Add This public override void VerifyRenderingInServerFormControl control Verifies that the control is rendered

saifali · Answer

I have done this now different error occur something like that belowRegisterForEventValidation can only be called during RenderDescription 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 SystemInvalidOperationException RegisterForEventValidation can only be called during RenderSource Error Line 38             DetailsView1AllowPaging  falseLine 39             DetailsView1DataBindLine 40 DetailsView1RenderControlhw Line 41             ResponseOutputWriteswToStringLine 42             ResponseFlush

Pradip · Answer

This error occurs whenever we are trying to render control to response To solve this problem I have added EnableEventValidationfalse to Page directive of aspx page that should be just like this lt Page Language34C34 AutoEventWireup34true34 CodeFile34ExportGridviewtoExcelaspxcs34 Inherits34ExportGridviewtoExcel34 EnableEventValidation34false34gtBy Setting EnableEventValidationfalse property to Page directive of aspx page the problem has solved automatically

Export DetailsView to Excel in ASP.Net

Company

Explore

Follow us

Contact Us