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();
}
