/*
* Exports the selected query data to excel; use random file name by timestamp
*/
private void ExportDataTableToExcel(DataTable sInputTable)
{
// export to Excel
// create random timestamp
TimeSpan sTime = DateTime.Now - new DateTime(1970, 1, 1, 0, 0, 0);
string timeStamp = ((long)sTime.TotalMilliseconds).ToString();
ExcelManager em = new ExcelManager();
if (em.ExcelExport(sInputTable, null, "RelationalReport_" + timeStamp + ".xls"))
{
LabelStatus.Text = "Success!";
}
}
private void ExportDataTableToExcel(DataTable sInputTable)
{
// export to Excel
// create random timestamp
TimeSpan sTime = DateTime.Now - new DateTime(1970, 1, 1, 0, 0, 0);
string timeStamp = ((long)sTime.TotalMilliseconds).ToString();
ExcelManager em = new ExcelManager();
if (em.ExcelExport(sInputTable, null, "OlapReport_" + timeStamp + ".xls"))
LabelStatus.Text = "Success!";
}
