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