ansaurus

Question

Answer 1

A:

Sorry but this is a better explanation of the issue Exporting from c#.net I am getting a problem I have a form that when I export to excel I ge the following <div></div> I have data in the datagrid but not in excel I am just getting <div></div>

2008-12-18 17:23:22

Please edit your original post in lieu of creating an answer to provide additional information.

Quintin Robinson 2008-12-18 17:24:57

Where is the code to export? All I can see is some repeater placed on a page. Post some C# page that is exporting and error message that you are getting.

Pradeep 2008-12-18 17:26:05

Answer 2

A:

And this is the function that I am using

void ExportToExcel3()
 {
     Response.Clear();
     Response.AddHeader("content-disposition", "attachment;filename=FileName.xls");
     Response.Charset = "";
     Response.ContentType = "application/vnd.xls";
     System.IO.StringWriter stringWrite = new System.IO.StringWriter();
     System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
     GridView2.RenderControl(htmlWrite);
     Response.Write(stringWrite.ToString());
     Response.End();
 }



public override void VerifyRenderingInServerForm(Control control)
 {

 }

2008-12-18 17:25:11

Answer 3

+1 A:

Are you populating gridview2 prior to the export (in the same request)?

Unless it is databound/populated prior to the export call through the page hierarchy (because it doesn't appear to happen in the export method) the results will be an empty grid. That might be your issue.

Quintin Robinson 2008-12-18 17:32:07

Answer 4

A:

YES I am populating the datagrid prior to the export. This is the line of code. It's funny I create a new webform just with this section of code and the export worked. Do you think there's a problem with the datarepeater that I have in the page that is causing the conflict.

MemberList list = MemberDB.GetMembers(sql, m_page, m_RecordPerPage, out count, _state);
          this.GridView2.DataSource = list;
          this.GridView2.DataBind();

2008-12-18 17:37:30

Answer 5

A:

Where do you call the ExportToExcel3() function? It looks to me like you're rendering the datagrid before the databinding event in the page lifecycle.

Joel Coehoorn 2008-12-18 17:47:06

Answer 6

A:

From a button So the sequence is I [LOAD event] fill out the Datagrid with my storedprocedure and then I ask the user to clik on the ExportTOExcel button.

2008-12-18 17:49:49

Note, this is why in my answer I said "In the same request". You must populate the grid in the same request as the click. You must consider your page stateless. The current request doesn't really know that the previous request populated data unless you make it aware.

Quintin Robinson 2008-12-18 18:00:14

You're right, CQ, but I've been finding a lot of people have no idea what you mean by "in the same request" or "pages are stateless" until they see something like what I've written in the next response.

Joel Coehoorn 2008-12-18 18:03:26

Yes your response was very concise, I'm glad someone could express verbosely what I had intended to say!

Quintin Robinson 2008-12-18 18:05:08

Answer 7

+1 A:

That's not the sequence at all- it's just not how asp.net and the web work.

You don't fill the grid during the load phase: you retrieve the data and set it as the datasource for the table, but the grid (actually a repeater) isn't filled yet. That doesn't happen until the databinding phase. After the databinding phase (during the render phase) the page with the databound repeater is finally sent by the server to the browser. At this point all your server-side stuff is disposed.

Now the browser can finally show the page with the big "Export to Excel" button which the user can click. Again: the server is already destroying all the data you worked so hard to build. When the user clicks your button, a brand new request is created and a brand new page will be sent back to the browser. You have to load all your data into the grid again.

Joel Coehoorn 2008-12-18 17:57:09

Answer 8

A:

so do you advise to bind the datagrid again inside the exportToExcel button?

2008-12-18 18:02:36

You must re-populate either inside or prior to the call within the same request as the click.

Quintin Robinson 2008-12-18 18:03:44

Answer 9

A:

Check out the following article:

http://www.highoncoding.com/Articles/197_Extensive_Study_of_GridView_Export_to_Excel.aspx

azamsharp 2008-12-18 18:57:06

Answer 10

A:

I found the solution to my problem. Thank you all for contributing. On the Load_Page Event I had the binding inside of an if !postback.

2008-12-18 20:15:04

Answer 11

A:

I am getting a problem while exporting data to excel.... I have a generate report button. once I click on that button a reportin generated... but my generate report button get disabled unless I refresh the page. what should I do????

2009-02-23 10:47:33

Answer 12

+1 A:

There is a wonderful library through which you can export data to excel. For Details see this link:-

Export To Excel in .Net

Zeeshan Umar 2010-07-13 06:25:36

ansaurus

tags:

views:

answers:

Export to Excel from c# .net

related questions