private void btnCopy_Click(object sender, EventArgs e)
{
if (dataGridView1.DataSource == null)
{
return;
}
if (dataGridView1.DataSource is ServerSizeSummary)
{
ServerSizeSummary size = (ServerSizeSummary)dataGridView1.DataSource;
StringBuilder sb = new StringBuilder();
sb.AppendLine("Database Size Summary");
sb.AppendLine("Server:\t" + this.connData.SQLServerName);
foreach (DataGridViewColumn col in dataGridView1.Columns)
{
sb.Append(col.HeaderText + "\t");
}
sb.AppendLine();
foreach (ServerSizeSummaryRow row in size.Rows)
{
sb.AppendLine(row.DatabaseName + "\t" + row.DateCreated + "\t" + row.DataSize + "\t" + row.Location);
}
Clipboard.SetText(sb.ToString());
}
}
private void bgWorker_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
{
ServerSizeSummary summ = (ServerSizeSummary)e.Result;
this.serverSizeSummary1 = summ;
this.serverSizeSummary1.AcceptChanges();
this.dataGridView1.DataSource = summ;
double sum = 0.0;
foreach (ServerSizeSummaryRow row in summ)
{
sum = sum + row.DataSize;
}
statSizeSum.Text = "Total Server Size: " + sum.ToString() + " MB";
this.toolStripProgressBar1.Style = ProgressBarStyle.Blocks;
this.Cursor = Cursors.Default;
}
private void bgWorker_DoWork(object sender, DoWorkEventArgs e)
{
ServerSizeSummary summ = DbInformation.InfoHelper.GetServerDatabaseInfo(this.connData);
e.Result = summ;
}
