private void cmdTest_Click(object sender, EventArgs e) { try { SqlDatabaseSizeEntry test = new SqlDatabaseSizeEntry(); test.SqlServer = txtServer.Text; test.Database = cboDatabase.Text; test.IntegratedSecurity = chkIntegratedSec.Checked; test.UserName = txtUserName.Text; test.Password = txtPassword.Text; test.SqlCmndTimeOutSec = (int)numericUpDownCmndTimeOut.Value; test.WarningSizeMB = (int)warningNumericUpDown.Value; test.ErrorSizeMB = (int)errorNumericUpDown.Value; long currentSize = test.GetDBSize(); MessageBox.Show(string.Format("Current database size: {0} MB", currentSize), "Test", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show(ex.Message, "Test", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public override void RefreshDisplayData() { try { lvwEntries.BeginUpdate(); Cursor.Current = Cursors.WaitCursor; foreach (ListViewItem lvi in lvwEntries.Items) { SqlDatabaseSizeEntry dbSizeEntry = (SqlDatabaseSizeEntry)lvi.Tag; long size = dbSizeEntry.GetDBSize(); lvi.SubItems[1].Text = size.ToString(); CollectorState currentState = dbSizeEntry.GetState(size); if (currentState == CollectorState.Good) { lvi.ImageIndex = 0; } else if (currentState == CollectorState.Warning) { lvi.ImageIndex = 1; } else { lvi.ImageIndex = 2; } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Refresh", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { Cursor.Current = Cursors.Default; lvwEntries.EndUpdate(); } base.RefreshDisplayData(); }