protected virtual void ExportData(DataTable dataTbl, Export.ExportFormat outputFormat, int[] columnList, string[] headerList) { try { switch (outputFormat) { case Export.ExportFormat.Excel: this.saveFileDialog.DefaultExt = "xls"; this.saveFileDialog.Filter = "Microsoft Excel(*.xls)|*.xls"; break; case Export.ExportFormat.CSV: this.saveFileDialog.DefaultExt = "csv"; this.saveFileDialog.Filter = "Van ban(*.csv)|*.csv"; break; case Export.ExportFormat.XML: this.saveFileDialog.DefaultExt = "html"; this.saveFileDialog.Filter = "Trang web(*.html)|*.html"; break; default: return; } this.saveFileDialog.CheckPathExists = true; this.saveFileDialog.AddExtension = true; this.saveFileDialog.RestoreDirectory = true; this.saveFileDialog.Title = "Thu muc luu tap tin ?"; if (this.saveFileDialog.ShowDialog() != DialogResult.OK) { return; } // Get the datatable to export DataTable dtTbl = dataTbl.Copy(); common.Export.ExportToExcel(dtTbl, this.saveFileDialog.FileName, columnList, headerList); dtTbl.Dispose(); common.sysLibs.ShowMessage("Đã xuất dữ liệu ra tập tin : " + this.saveFileDialog.FileName); } catch (Exception er) { common.sysLibs.ShowMessage("Xuất dữ liệu gặp lỗi.\n\r\n\r" + er.Message.ToString()); } }
protected virtual void ExportData(DataTable dataTbl, Export.ExportFormat outputFormat, int[] columnList) { ExportData(dataTbl, outputFormat, columnList, null); }
protected virtual void ExportData(DataTable dataTbl, Export.ExportFormat outputFormat) { ExportData(dataTbl, outputFormat, null, null); }