GridView Excel Export

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22

// use EnableEventValidation="false" in this page !

private void ExportToExcel(string filename)
{
    Response.Clear();
    Response.Buffer = true;
    Response.AddHeader("Content-Disposition", string.Format("attachment; filename={0}", filename));
    Response.ContentType = "application/vnd.ms-excel";
    Response.Charset = "";
    EnableViewState = false;

    StringWriter myStringWriter = new StringWriter();
    HtmlTextWriter myHtmlTextWriter = new HtmlTextWriter(myStringWriter);

    GridView1.RenderControl(myHtmlTextWriter);        
    Response.Write(myStringWriter.ToString());
    Response.End();
}

public override void VerifyRenderingInServerForm(Control control)
{
}