private void LoadTables()
{
try
{
string serverName = ApplyConfigVarsOnField(txtServer.Text);
string databaseName = ApplyConfigVarsOnField(cboDatabase.Text);
string username = ApplyConfigVarsOnField(txtUserName.Text);
string password = ApplyConfigVarsOnField(txtPassword.Text);
if (serverName.Trim().Length > 0 && databaseName.Length > 0)
{
Cursor.Current = Cursors.WaitCursor;
lvwTables.Items.Clear();
List <TableSizeInfo> tables = SqlTableSizeCollectorEntry.GetAllTableRowCounts(serverName, databaseName, chkIntegratedSec.Checked, username, password, (int)numericUpDownCmndTimeOut.Value);
foreach (var table in tables)
{
ListViewItem lvi = new ListViewItem(table.Name);
lvi.SubItems.Add("0");
lvi.SubItems.Add("0");
lvi.SubItems.Add(table.Rows.ToString());
lvi.Tag = table;
SqlTableSizeCollectorEntry selectedEntry = (SqlTableSizeCollectorEntry)SelectedEntry;
if (selectedEntry != null && selectedEntry.Tables != null)
{
TableSizeEntry tse = (from t in selectedEntry.Tables
where t.TableName.ToLower() == table.Name.ToLower()
select t).FirstOrDefault();
if (tse != null)
{
lvi.Checked = true;
lvi.SubItems[1].Text = tse.WarningValue.ToString();
lvi.SubItems[2].Text = tse.ErrorValue.ToString();
}
}
lvwTables.Items.Add(lvi);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Loading tables", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
Cursor.Current = Cursors.Default;
}
