hiiii sir,
i use your code given below for exporting gridview to excel file. There is no any problem in code but excel file was not generated. i use this code
plz sir help me....
thanks and regards,
Mr. Shubham A. Patil
Student
public void ExportGridToExcel(GridView grd)
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=GridViewExport.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
grd.AllowPaging = false;
GrdBind();
grd.RenderControl(hw);
string style = @"<style> .textmode { } </style>";
Response.Write(style);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
public override void VerifyRenderingInServerForm(Control control)
{
//required to avoid the run time error "
//Control 'GridView1' of type 'Grid View' must be placed inside a form tag with runat=server."
}
protected void imgBtnPDF_Click(object sender, ImageClickEventArgs e)
{
ExportGridToExcel(grdStudent);
grdStudent.AllowPaging = true;
GrdBind();
}
protected void grdStudent_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
grdStudent.PageIndex = e.NewPageIndex;
GrdBind();
}
