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