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