private void ExportToExcel()
{
string sortExpression = gvPricingPlans.MasterTableView.SortExpressions.GetSortString();
DataView dvPricingPlanHistory = GetPricingPlanHistoryDataTable().DefaultView;
//set sorting
if (!string.IsNullOrEmpty(sortExpression))
{
dvPricingPlanHistory.Sort = sortExpression;
}
string fileNameExtension;
string encoding;
string mimeType;
string fileName = "PrcingPlanHistory";
byte[] reportBytes = AdminWebReportHandler.GeneratePrcingPlanHistoryReport(dvPricingPlanHistory, ReportTypes.Excel,
out fileNameExtension, out encoding, out mimeType);
Utils.ExportReport(reportBytes, mimeType, fileNameExtension, fileName);
}
protected void btnExporttoExcel_Click(object sender, EventArgs e)
{
string sortExpression = gvUsers.MasterTableView.SortExpressions.GetSortString();
DataView dvUsers = GetUserList().DefaultView;
//set sorting
if (!string.IsNullOrEmpty(sortExpression))
{
dvUsers.Sort = sortExpression;
}
string fileNameExtension;
string encoding;
string mimeType;
string fileName = "UserList";
byte[] reportBytes = AdminWebReportHandler.GenerateUserListReport(dvUsers, ReportTypes.Excel,
out fileNameExtension, out encoding, out mimeType);
Utils.ExportReport(reportBytes, mimeType, fileNameExtension, fileName);
}
