protected void lnkExportToExcel_Click(object sender, EventArgs e)
{
try
{
DataTable dtb = new DataTable();
dtb = gLAccountListBAL.GetGLAccountListForExportToExcel();
string exportedFileName = "GLAccount_" + System.DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls";
Response.Clear();
Response.Charset = "";
Response.ContentType = "application/ms-excel";
Response.Buffer = true;
Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", exportedFileName));
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new System.Web.UI.HtmlTextWriter(stringWrite);
System.Web.UI.WebControls.DataGrid dg = new System.Web.UI.WebControls.DataGrid();
dg.AllowPaging = false;
dg.HeaderStyle.BackColor = System.Drawing.Color.RoyalBlue;
dg.HeaderStyle.ForeColor = System.Drawing.Color.White;
dg.DataSource = dtb;
dg.DataBind();
dg.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
}
catch (Exception exp)
{
logExcpUIobj.MethodName = "lnkExportToExcel_Click()";
logExcpUIobj.ResourceName = "Finance_General_Ledger_GL_Integration_GLAccountList.CS";
logExcpUIobj.RecordId = "Export To excel";
logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString();
logExcpDALobj.SaveExceptionToDB(logExcpUIobj);
log.Error("[Finance_General_Ledger_GL_Integration_GLAccountList : lnkExportToExcel_Click] An error occured in the processing of Records. Details : [" + exp.ToString() + "]");
}
}
