private void cbDbNames_SelectedIndexChanged(object sender, EventArgs e) { sbDbNames.Text = ((DataTable)cbDbNames.ComboBox.DataSource).Rows[cbDbNames.SelectedIndex].ItemArray[0].ToString(); SetPTODataSource(sbDbNames.Text); //Workaround to refresh report this.reportViewer1.Reset(); this.reportViewer1.ServerReport.ReportPath = "/SQLPTOReports/SystemInfo"; this.reportViewer1.RefreshReport(); RefreshReport(); //Close PerfQuery window if it's open if (frmPerfQuery != null) { frmPerfQuery.Close(); frmPerfQuery.Dispose(); frmPerfQuery = null; } if (frmExpensiveQueriesAndPlans != null) { frmExpensiveQueriesAndPlans.Close(); frmExpensiveQueriesAndPlans.Dispose(); frmExpensiveQueriesAndPlans = null; } //cbDbNames.ComboBox.Hide(); reportViewer1.Focus(); }
private void btnQueriesAndPlans_ButtonClick(object sender, EventArgs e) { if (frmExpensiveQueriesAndPlans == null || frmExpensiveQueriesAndPlans.IsDisposed) { frmExpensiveQueriesAndPlans = new ExpensiveQueriesAndPlans(); } frmExpensiveQueriesAndPlans.DatabaseName = sbDbNames.Text; //frmPerfQuery.Width = Screen.PrimaryScreen.Bounds.Width; //frmPerfQuery.Height = Screen. frmExpensiveQueriesAndPlans.WindowState = FormWindowState.Maximized; frmExpensiveQueriesAndPlans.Show(); frmExpensiveQueriesAndPlans.BringToFront(); }