Response.Clear();

Response.Buffer true;

Response.ContentType "application/vnd.ms-excel";

Response.AddHeader("Content-Disposition" "attachment;filename ReviewDesignation.xls");//This
lets you always open the Excel window when exporting whether you click on open
or save.

Response.Charset "";

this.EnableViewState false;

System.IO.StringWriter oStringWriter new
System.IO.StringWriter();System.Web.UI.HtmlTextWriter oHtmlTextWriter

new System.Web.UI.HtmlTextWriter(oStringWriter);

this.ClearControls(dGrid);

dGrid.RenderControl(oHtmlTextWriter);

Response.Write(oStringWriter.ToString());

Response.End();