private void SetTableFilter()
{
if (txtFilter.Text.Equals("Filter..."))
{
return;
}
filteredTablesList.Clear();
TablesListBox.DataSource = null;
if (rdoContains.Checked)
{
var filterQuery = from t in tablesList
where t.Contains(txtFilter.Text.Trim())
select t;
filteredTablesList.AddRange(filterQuery.ToList <string>());
}
else
{
var filterQuery = from t in tablesList
where t.StartsWith(txtFilter.Text.Trim())
select t;
filteredTablesList.AddRange(filterQuery.ToList <string>());
}
TablesListBox.DataSource = filteredTablesList;
TablesListBox.Refresh();
RefreshColumnList();
}
private void deleteTableToolStripMenuItem_Click(object sender, EventArgs e)
{
if (MessageBox.Show($"Delete table {TablesListBox.SelectedItem} ?", "Are you sure?", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
Global.currentDb.DropTable(TablesListBox.SelectedItem.ToString());
TablesListBox.Refresh();
Global.currentTable = null;
}
}
private void deleteTableToolStripMenuItem_Click(object sender, EventArgs e)
{
if (MessageBox.Show($"Delete table {TablesListBox.SelectedItem} ?", "Are you sure?", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
try
{
GlobalContext.currentDb.DropTable(TablesListBox.SelectedItem.ToString());
TablesListBox.Refresh();
GlobalContext.currentTable = null;
}
catch (Exception exc)
{
MessageBox.Show(exc.Message, "Failed to drop table", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
//private void LoadConnections()
//{
// string[] lines = File.ReadAllLines("Connections.txt");
// cboConnString.Items.AddRange(lines);
// cboConnString.Refresh();
//}
/// <summary>
/// Open the database, loads the schema into the dataset
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// <exception>Throws SqlException or a general Exception</exception>
private void btnOpenDatabase_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(cboConnString.Text))
{
MessageBox.Show("Enter or select an existing connection string before clicking \"Open\"!", "Open Database Error", MessageBoxButtons.OK, MessageBoxIcon.Stop);
return;
}
// Collapse the columns list box
splitContainer3.SuspendLayout();
splitContainer3.Panel2Collapsed = true;
btnShowColumns.Text = ">";
splitContainer3.ResumeLayout();
tablesList.Clear();
TablesListBox.DataSource = null;
TablesListBox.Refresh();
ssStatus.Items[0].Text = "";
txtResults.Text = "Opening Database - for Clarity and other very large schemas, this may take some time. Be patient." +
"\r\nFor example, Clarity takes over 30 seconds to load";
txtResults.Refresh();
DateTime start = DateTime.Now;
string connString = cboConnString.Text.Trim();
dbUtils.OpenDatabase(connString, ssStatus);
foreach (DataRow row in dbUtils.SchemaDataSet.Tables["Tables"].Rows)
{
tablesList.Add(row["TABLE_NAME"].ToString());
}
TablesListBox.DataSource = tablesList;
TablesListBox.Refresh();
TimeSpan elapsed = DateTime.Now - start;
SetStatus(String.Format("Database Loaded: {0} in {1:D2} hours, {2:D2} minutes, {3:D2} seconds and {4:D2} milliseconds",
dbUtils.CurrentDatabase, elapsed.Hours,
elapsed.Minutes, elapsed.Seconds, elapsed.Milliseconds));
btnSearch.Enabled = true;
btnSelectAllTables.Enabled = true;
}
