private void SetColumnFilter() { if (txtColumnFilter.Text.Equals("Filter...")) { return; } ColumnsListBox.SuspendLayout(); filteredColumnsList.Clear(); ColumnsListBox.DataSource = null; EnumerableRowCollection <DataRow> filterQuery; if (rdoColumnContains.Checked) { filterQuery = from c in dbUtils.SchemaDataSet.Tables["TableColumns"].AsEnumerable() where c.Field <string>("COLUMN_NAME").Contains(txtColumnFilter.Text.Trim()) select c; } else { filterQuery = from c in dbUtils.SchemaDataSet.Tables["TableColumns"].AsEnumerable() where c.Field <string>("COLUMN_NAME").StartsWith(txtColumnFilter.Text.Trim()) select c; } filteredColumnsList = PopulateTheColumnList(filterQuery); ColumnsListBox.DataSource = filteredColumnsList; ColumnsListBox.ResumeLayout(); }
/// <summary> /// Selects all tables in the database schema for searching /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSelectAllTables_Click(object sender, EventArgs e) { TablesListBox.SuspendLayout(); ColumnsListBox.SuspendLayout(); for (int i = 0; i < TablesListBox.Items.Count; i++) { TablesListBox.SetSelected(i, true); } TablesListBox.TopIndex = 0; RefreshColumnList(); TablesListBox.ResumeLayout(); ColumnsListBox.ResumeLayout(); }
private void LoadColumns() { // If no database currently open, don't do anything if (string.IsNullOrEmpty(dbUtils.CurrentDatabase)) { return; } ColumnsListBox.SuspendLayout(); columnsList.Clear(); ColumnsListBox.DataSource = null; string selectedTables = string.Empty; foreach (string item in TablesListBox.SelectedItems) { selectedTables += item + ","; } var columnQuery = from c in dbUtils.SchemaDataSet.Tables["TableColumns"].AsEnumerable() where selectedTables.Contains(c.Field <string>("TABLE_NAME")) select c; columnsList = PopulateTheColumnList(columnQuery); ColumnsListBox.DataSource = columnsList; ColumnsListBox.ResumeLayout(); }