ASP.NET Error

Question

Hi, I have written this piece of code to export grid data to excel. And I get this error on debugging.

Sanjeeb Lenka · Answer

hi , i checked your code just check you forgot to add this in both BSP and APP: for Bsp: function popwin(OutageTicket) { var nw = window.open("BSPInput.aspx?lblOutageTicket=" + OutageTicket + "&Edit=True"); return false; } for APP: function popwin(OutageTicket) { var nw = window.open("ApplicationGroupAdmin.aspx?lblOutageTicket=" + OutageTicket + "&Edit=True"); return false; } .btnStyle { margin-left: 46px; } .style1 { width: 727px; }

Sanjeeb Lenka · Answer

did you write this code : public override void VerifyRenderingInServerForm( Control control) { /* Verifies that the control is rendered */ } if not just copy and paste it within your code. In your code: protected void Button2_Click(object sender, ImageClickEventArgs e ) // Wrong { Response.ClearContent(); Response.Buffer = true; Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "Customers.xls")); Response.ContentType = "application/ms-excel"; StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); GridView1.AllowPaging = false; GridView1.DataBind(); GridView1.RenderControl(htw); Response.Write(sw.ToString()); Response.End(); } just change it to this: protected void Button2_Click(object sender, EventArgs e) { Response.ClearContent(); Response.Buffer = true; Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "Customers.xls")); Response.ContentType = "application/ms-excel"; StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); GridView1.AllowPaging = false; GridView1.DataBind(); GridView1.RenderControl(htw); Response.Write(sw.ToString()); Response.End(); } if any problem reply

Sanjeeb Lenka · Answer

yes, just try it in a separate page and check. 1st remove the javascript form the button click and check.

Vignesh Kumar · Answer

Hi Sanjeeb, Saw the link and looks like they have used Clear method in the program. So do you think this has to be added to the program.

Sanjeeb Lenka · Answer

hi, I checked that problem . its came due to the buttons and other controls. so i giving you a link just check that link its not in Jquery. you just check and reply. http://stackoverflow.com/questions/7525537/how-to-exporting-to-excel-parent-and-nested-gridview-data

Vignesh Kumar · Answer

It worked great with no problems now! A small doubt, when the report is generated the report doesn't seems nice when compared to the page and can be found in the attachment. Can you pls suggest me something for this.

Vignesh Kumar · Answer

Hi Sanjeeb, I have added the Jquery to the library already. Totally I HAVE THREE PAGES, where it works for LOB and doesn't works for BSP and APP pages in the attchment.

Sanjeeb Lenka · Answer

hi, you forgot to add Jquery library in both the form just add that and check. Mark it as answered if it helps you.

Vignesh Kumar · Answer

Sanjeeb I have attached two pages where I need to bring this functionality and I get the same error for these two pages.

Sanjeeb Lenka · Answer

hi, paste your code i will check that.

Vignesh Kumar · Answer

Hi Sanjeeb, I tried your code and its still the same. Please look into the attachment for the error message.

Sanjeeb Lenka · Answer

Hi Vignesh, You forgot to give the div id in your code. Means which div you write for grid. so i modified the code and attached it. just check it carefully before update it. Don't forget to attach the jquery. if it helps you mark it as answered.

Vignesh Kumar · Answer

So Sanjeeb if I want to do same functionality to other page, there is no change done to aspx page right, apart from the script. Because I tried in another page where it has lot of nested grid and I am getting an error on highlighted one below when I click on Export to Excel. THIS ATTACHMENT IS A DIFFERENT PAGE WHICH HAS NESTED GRID. html = $.trim(html); html = html.replace(/>/g, html = html.replace(/ $( } script language ="javascript" type ="text/javascript"> function ExportDivDataToExcel() { var html = $ ( "#divprint " ).html(); '>' ); '<' ); "input[id$='HdnValue']" ).val(html); script > t

Vignesh Kumar · Answer

A Legendary work! It looks great. Thanks a ton Sanjeeb.

Sanjeeb Lenka · Answer

sorry i forgot add the hidden field just add this line after the div end and before the content at last line of aspx.

Vignesh Kumar · Answer

The Name "hdnvalue" doesn't exist in the current context. protected void Button2_Click(object sender, EventArgs e) { string html = HdnValue .Value; ExportToExcel(ref html, "MyReport"); }

Sanjeeb Lenka · Answer

hi, i attached the code in txt using div and jquery. just check that. 1. add the jquer library. 2.then check the code carefully what i changed and add . in aspx and cs.

Vignesh Kumar · Answer

I have done it. And no change in the behaviour.

Pankaj Pandey · Answer

just add a namespace on the top of your .cs page. using System.Data; and try again with Sanjeeb code.

Sanjeeb Lenka · Answer

okk i will modify your code in notepad and attached it .

Vignesh Kumar · Answer

I am not able to access this site. Content Blocked

Sanjeeb Lenka · Answer

Hi, I saw your codes in that nested grid . may be due to that you are not getting actual result. so put your grid within a div and export it. follow this link for do that: http://nice-tutorials.blogspot.in/2011/01/export-dynamic-data-from-div-to-excel.html any problem reply

Vignesh Kumar · Answer

No Sanjeeb, I am not getting! ERROR The type or namespace name 'DataTable' could not be found (are you missing a using directive or an assembly reference?)

Sanjeeb Lenka · Answer

hi , In exel you are getting data or not.

Vignesh Kumar · Answer

What is the namespace that I should add for this datatable? I am stuck there.

Ravi Shekhar · Answer

Hi Vignesh, I think you should export data from your datatable. this is a good practice. check below code... public void ExportData(DataTable dset) { HttpResponse response = HttpContext.Current.Response; // first let's clean up the response.object response.Clear(); response.Charset = ""; // set the response mime type for excel //Dim filename As String = "Record.xls" string filename = "Report(" + "" + DateTime.Now.ToString("dd-MM-yyyy") + ").xls"; response.ContentType = "application/vnd.ms-excel"; response.AddHeader("Content-Disposition", "attachment;filename=\"" + filename + "\""); // create a string writer using (StringWriter sw = new StringWriter()) { using (HtmlTextWriter htw = new HtmlTextWriter(sw)) { // instantiate a datagrid DataGrid dg = new DataGrid(); dg.DataSource = dset; dg.DataBind(); dg.RenderControl(htw); response.Write(sw.ToString()); response.End(); } } }

Vignesh Kumar · Answer

Hi Sanjeeb, Here are attached codes.

Sanjeeb Lenka · Answer

can you share your aspx and .cs code so i will check that

Vignesh Kumar · Answer

It works great. But the excel does not fetch the grid info.

ASP.NET Error

Answers (29)