private void ExportToolStripMenuItem_Click(object sender, EventArgs e) { ExportForm form = new ExportForm(); form.DisableExportSql(); form.DisableExportPtt(); form.DisableExportSession(); form.Initialize(_databaseOperation, dataViewer1, _dataViewerParametersDataViewer1); form.ShowDialog(); }
public void ExportDataUnattended(string fileName) { string originalMinDuration = _dataViewerParametersDataViewer1.Columns["MinDuration"][4]; string originalMaxDuration = _dataViewerParametersDataViewer1.Columns["MaxDuration"][4]; string originalAvgDuration = _dataViewerParametersDataViewer1.Columns["AvgDuration"][4]; string originalDevDuration = _dataViewerParametersDataViewer1.Columns["DevDuration"][4]; string originalVarDuration = _dataViewerParametersDataViewer1.Columns["VarDuration"][4]; string originalSumDuration = _dataViewerParametersDataViewer1.Columns["SumDuration"][4]; string originalMinReads = _dataViewerParametersDataViewer1.Columns["MinReads"][4]; string originalMaxReads = _dataViewerParametersDataViewer1.Columns["MaxReads"][4]; string originalAvgReads = _dataViewerParametersDataViewer1.Columns["AvgReads"][4]; string originalDevReads = _dataViewerParametersDataViewer1.Columns["DevReads"][4]; string originalVarReads = _dataViewerParametersDataViewer1.Columns["VarReads"][4]; string originalSumReads = _dataViewerParametersDataViewer1.Columns["SumReads"][4]; string originalMinWrites = _dataViewerParametersDataViewer1.Columns["MinWrites"][4]; string originalMaxWrites = _dataViewerParametersDataViewer1.Columns["MaxWrites"][4]; string originalAvgWrites = _dataViewerParametersDataViewer1.Columns["AvgWrites"][4]; string originalDevWrites = _dataViewerParametersDataViewer1.Columns["DevWrites"][4]; string originalVarWrites = _dataViewerParametersDataViewer1.Columns["VarWrites"][4]; string originalSumWrites = _dataViewerParametersDataViewer1.Columns["SumWrites"][4]; string originalMinCPU = _dataViewerParametersDataViewer1.Columns["MinCPU"][4]; string originalMaxCPU = _dataViewerParametersDataViewer1.Columns["MaxCPU"][4]; string originalAvgCPU = _dataViewerParametersDataViewer1.Columns["AvgCPU"][4]; string originalDevCPU = _dataViewerParametersDataViewer1.Columns["DevCPU"][4]; string originalVarCPU = _dataViewerParametersDataViewer1.Columns["VarCPU"][4]; string originalSumCPU = _dataViewerParametersDataViewer1.Columns["SumCPU"][4]; string originalMinRows = _dataViewerParametersDataViewer1.Columns["MinRows"][4]; string originalMaxRows = _dataViewerParametersDataViewer1.Columns["MaxRows"][4]; string originalAvgRows = _dataViewerParametersDataViewer1.Columns["AvgRows"][4]; string originalDevRows = _dataViewerParametersDataViewer1.Columns["DevRows"][4]; string originalVarRows = _dataViewerParametersDataViewer1.Columns["VarRows"][4]; string originalSumRows = _dataViewerParametersDataViewer1.Columns["SumRows"][4]; _dataViewerParametersDataViewer1.Columns["MinDuration"][4] = "SearchableShow"; _dataViewerParametersDataViewer1.Columns["MaxDuration"][4] = "SearchableShow"; _dataViewerParametersDataViewer1.Columns["AvgDuration"][4] = "SearchableShow"; _dataViewerParametersDataViewer1.Columns["DevDuration"][4] = "SearchableShow"; _dataViewerParametersDataViewer1.Columns["VarDuration"][4] = "SearchableShow"; _dataViewerParametersDataViewer1.Columns["SumDuration"][4] = "SearchableShow"; _dataViewerParametersDataViewer1.Columns["MinReads"][4] = "SearchableShow"; _dataViewerParametersDataViewer1.Columns["MaxReads"][4] = "SearchableShow"; _dataViewerParametersDataViewer1.Columns["AvgReads"][4] = "SearchableShow"; _dataViewerParametersDataViewer1.Columns["DevReads"][4] = "SearchableShow"; _dataViewerParametersDataViewer1.Columns["VarReads"][4] = "SearchableShow"; _dataViewerParametersDataViewer1.Columns["SumReads"][4] = "SearchableShow"; _dataViewerParametersDataViewer1.Columns["MinWrites"][4] = "SearchableShow"; _dataViewerParametersDataViewer1.Columns["MaxWrites"][4] = "SearchableShow"; _dataViewerParametersDataViewer1.Columns["AvgWrites"][4] = "SearchableShow"; _dataViewerParametersDataViewer1.Columns["DevWrites"][4] = "SearchableShow"; _dataViewerParametersDataViewer1.Columns["VarWrites"][4] = "SearchableShow"; _dataViewerParametersDataViewer1.Columns["SumWrites"][4] = "SearchableShow"; _dataViewerParametersDataViewer1.Columns["MinCPU"][4] = "SearchableShow"; _dataViewerParametersDataViewer1.Columns["MaxCPU"][4] = "SearchableShow"; _dataViewerParametersDataViewer1.Columns["AvgCPU"][4] = "SearchableShow"; _dataViewerParametersDataViewer1.Columns["DevCPU"][4] = "SearchableShow"; _dataViewerParametersDataViewer1.Columns["VarCPU"][4] = "SearchableShow"; _dataViewerParametersDataViewer1.Columns["SumCPU"][4] = "SearchableShow"; _dataViewerParametersDataViewer1.Columns["MinRows"][4] = "SearchableShow"; _dataViewerParametersDataViewer1.Columns["MaxRows"][4] = "SearchableShow"; _dataViewerParametersDataViewer1.Columns["AvgRows"][4] = "SearchableShow"; _dataViewerParametersDataViewer1.Columns["DevRows"][4] = "SearchableShow"; _dataViewerParametersDataViewer1.Columns["VarRows"][4] = "SearchableShow"; _dataViewerParametersDataViewer1.Columns["SumRows"][4] = "SearchableShow"; ExportForm form = new ExportForm(); form.DisableExportSql(); form.DisableExportPtt(); form.DisableExportSession(); form.Initialize(_databaseOperation, dataViewer1, _dataViewerParametersDataViewer1); form.DoExportCsvAllPagesUnattended(fileName, _totalRows); _minStartTime = form.GetMinStartTime(); _maxStartTime = form.GetMaxStartTime(); _dataViewerParametersDataViewer1.Columns["MinDuration"][4] = originalMinDuration; _dataViewerParametersDataViewer1.Columns["MaxDuration"][4] = originalMaxDuration; _dataViewerParametersDataViewer1.Columns["AvgDuration"][4] = originalAvgDuration; _dataViewerParametersDataViewer1.Columns["DevDuration"][4] = originalDevDuration; _dataViewerParametersDataViewer1.Columns["VarDuration"][4] = originalVarDuration; _dataViewerParametersDataViewer1.Columns["SumDuration"][4] = originalSumDuration; _dataViewerParametersDataViewer1.Columns["MinReads"][4] = originalMinReads; _dataViewerParametersDataViewer1.Columns["MaxReads"][4] = originalMaxReads; _dataViewerParametersDataViewer1.Columns["AvgReads"][4] = originalAvgReads; _dataViewerParametersDataViewer1.Columns["DevReads"][4] = originalDevReads; _dataViewerParametersDataViewer1.Columns["VarReads"][4] = originalVarReads; _dataViewerParametersDataViewer1.Columns["SumReads"][4] = originalSumReads; _dataViewerParametersDataViewer1.Columns["MinWrites"][4] = originalMinWrites; _dataViewerParametersDataViewer1.Columns["MaxWrites"][4] = originalMaxWrites; _dataViewerParametersDataViewer1.Columns["AvgWrites"][4] = originalAvgWrites; _dataViewerParametersDataViewer1.Columns["DevWrites"][4] = originalDevWrites; _dataViewerParametersDataViewer1.Columns["VarWrites"][4] = originalVarWrites; _dataViewerParametersDataViewer1.Columns["SumWrites"][4] = originalSumWrites; _dataViewerParametersDataViewer1.Columns["MinCPU"][4] = originalMinCPU; _dataViewerParametersDataViewer1.Columns["MaxCPU"][4] = originalMaxCPU; _dataViewerParametersDataViewer1.Columns["AvgCPU"][4] = originalAvgCPU; _dataViewerParametersDataViewer1.Columns["DevCPU"][4] = originalDevCPU; _dataViewerParametersDataViewer1.Columns["VarCPU"][4] = originalVarCPU; _dataViewerParametersDataViewer1.Columns["SumCPU"][4] = originalSumCPU; _dataViewerParametersDataViewer1.Columns["MinRows"][4] = originalMinRows; _dataViewerParametersDataViewer1.Columns["MaxRows"][4] = originalMaxRows; _dataViewerParametersDataViewer1.Columns["AvgRows"][4] = originalAvgRows; _dataViewerParametersDataViewer1.Columns["DevRows"][4] = originalDevRows; _dataViewerParametersDataViewer1.Columns["VarRows"][4] = originalVarRows; _dataViewerParametersDataViewer1.Columns["SumRows"][4] = originalSumRows; }