How to Export Grind View data to excel.
pls send me With Examples.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Hermes CondezPosted Mar 6, 2012, 8:13 AM
protected void ExportToXls_Click(object sender, EventArgs e) //On click Event of a control (button/link button/hyperlink)
{
this.DataGridView1.AllowPaging = false;
ExportGridViewToExcel(Response, this.DataGridView1, "Exported.xls");
}
public void ExportGridViewToExcel(HttpResponse response, GridView gvControl, string fileName)
{
string attachment = "";
System.IO.StringWriter sw = new System.IO.StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
response.AddHeader("content-disposition", "attachment; filename=" + fileName);
response.ClearContent();
response.AddHeader("content-disposition", attachment);
gvControl.AllowPaging = false;
gvControl.DataBind();
gvControl.RenderControl(htw);
response.Write(sw.ToString());
response.Flush();
response.End();
gvControl.AllowPaging = true;
}
public override void VerifyRenderingInServerForm(Control control) // I just got this in forum just
// add this. I don't why but it will work if this is added
{
}
Satyapriya NayakPosted Mar 6, 2012, 6:19 AM
Please refer the below link
http://www.c-sharpcorner.com/UploadFile/DipalChoksi/exportxl_asp2_dc11032006003657AM/exportxl_asp2_dc.aspx
Thanks