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);
}
}
