protected void btnExportExcel_Click(object sender, EventArgs e) { try { DataTable objDataTable = new DataTable(); string SelectedColumns = string.Empty; for (int i = 0; i < grddata.Columns.Count; i++) { if (SelectedColumns == string.Empty) { SelectedColumns = SelectedColumns + "[" + grddata.Columns[i].HeaderText + "]"; } else { SelectedColumns = SelectedColumns + "," + "[" + grddata.Columns[i].HeaderText + "]"; } } SelectedColumns = SelectedColumns.Replace(",[Delete]", " "); SelectedColumns = SelectedColumns.Replace(",[Is Submit]", " "); objDataTable = BeanHelper.SearchBean.GetData(ViewState["SearchCondition"].ToString() + ViewState["OrderBy"].ToString(), SelectedColumns); ExcelWrite objExcelWrite = new ExcelWrite(TitleCaption.Text); objExcelWrite.ExportExcel(objDataTable); } catch (Exception ex) { Messagesection.Visible = true; Message.Text = ex.Message; LogManager.Log(ex); } }
protected void btnExportExcel_Subscription_Click(object sender, EventArgs e) { try { string SelectedColumns = string.Empty; for (int i = 0; i < grdSubscriptionGet.Columns.Count; i++) { if (!string.IsNullOrEmpty(grdSubscriptionGet.Columns[i].HeaderText)) { if (SelectedColumns == string.Empty) { SelectedColumns = SelectedColumns + "[" + grdSubscriptionGet.Columns[i].HeaderText + "]"; } else { SelectedColumns = SelectedColumns + "," + "[" + grdSubscriptionGet.Columns[i].HeaderText + "]"; } } } DataTable objDataTable = BeanHelper.SearchBean.GetData(ViewState["SearchCondition_SubscriptionGet"].ToString() + ViewState["OrderBy_SubscriptionGet"].ToString(), SelectedColumns); ExcelWrite objExcelWrite = new ExcelWrite(TitleCaption.Text); objExcelWrite.ExportExcel(objDataTable); } catch (Exception ex) { Messagesection.Visible = true; Message.Text = ex.Message; LogManager.Log(ex); } }