/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void ImgExpExcel_Click(object sender, EventArgs e) { try { int rowcount = ucCustomPagerItems.isCountRecord; string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString()); int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null) { sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString()); } BLL_Crew_Admin objBLL = new BLL_Crew_Admin(); DataTable dt = objBLL.CRW_LIB_Export_OilMajor(); if (dt.Rows.Count > 0) { string[] HeaderCaptions = { "Oil Major Name", "Display Name", "Remark", "Active Status" }; string[] DataColumnsName = { "Oil_Major_Name", "Display_Name", "Remarks", "Active Status" }; GridViewExportUtil.ShowExcel(dt, HeaderCaptions, DataColumnsName, "OilMajors" + "_" + DateTime.Now.ToString("yyyy-MM-dd HH.mm.ss"), "Oil Majors", ""); } } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); } }