How to export the data from Griedview to excel simple code

Question

0.00/5 (No votes)

See more:

Hi i have tried the following code on my button click event but it shows an error as Control 'ctl00_ContentPlaceHolder1_grdsalarydetail' of type 'GridView' must be placed inside a form tag with runat=server. i have tried the same logic of code i asp.net with vb which works after adding an overrides method as

C#

Response.Clear();
        Response.AddHeader("Content-disposition", "Attachmen;filename=reports.xlsx");
        StringWriter StringWriter = new System.IO.StringWriter();
        HtmlTextWriter HtmlTextWriter = new HtmlTextWriter(StringWriter);
        grdsalarydetail.RenderControl(HtmlTextWriter);
        Response.Write(StringWriter.ToString());
        Response.End();

but can any one explain in csharp how can i use the same code as i am not getting the correct logic of override method in csharp

XML

<b><pre lang="vb">Public Overrides Sub VerifyRenderingInServerForm(ByVal control As System.Web.UI.Control)
        'MyBase.VerifyRenderingInServerForm(control)
    End Sub</pre>
</b>

Posted 3-Dec-12 4:30am

Salman Farooqui

Updated 3-Dec-12 4:34am

Krunal Rohit

v3

Add a Solution

3 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Shekhar Reddy.N · Answer 1 · 2012-12-03T17:17:00

private void ExportGridToExcel(GridView grdGridView, string fileName)
{
Response.Clear();
Response.AddHeader("content-disposition",
string.Format("attachment;filename={0}.xlsx", fileName));
Response.Charset = "";
Response.ContentType = "application/vnd.xlsx";

StringWriter stringWrite = new StringWriter();
HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);

grdGridView.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
}
//You have to override this method
public override void VerifyRenderingInServerForm(Control control)
{

}

C#

<pre lang="c#">

Lacy00 · Answer 2 · 2012-12-03T16:58:00

Actually, there are a lot of solutions to export data from gridview to Excel. I am afraid people may not successfully reproduce your problem, so why do not try other solutions? they are easy to perform and at the same time, you can learn much from them. Here I can suggest you some, I believe they are helpful for you, you want simple code, so you can decide yourself which is the best
9 Solutions to Export Data to Excel for ASP.NET[^]
Export DataTable to Excel through DataGridView[^]
Excel to Datatable and Datatable to Excel[^]

Krunal Rohit · Answer 3 · 2012-12-03T04:35:00

Solution 1

Get a reference from Export Gridview Data to Excel in ASP.NET[^]

Posted 3-Dec-12 4:35am

Krunal Rohit

How to export the data from Griedview to excel simple code

3 solutions

Solution 4

Solution 3

Solution 1

Add your solution here

Preview 0

How to export the data from Griedview to excel simple code

3 solutions

Solution 4

Solution 3

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us