private void PopulateTablesAndSequences()
{
errorLabel.Text = string.Empty;
tablesListBox.DataBindings.Clear();
try
{
if (ownersComboBox.SelectedItem == null)
{
return;
}
var tables = metadataReader.GetTables(ownersComboBox.SelectedItem.ToString());
tablesListBox.Enabled = false;
tablesListBox.Items.Clear();
if (tables != null && tables.Any())
{
tablesListBox.Items.AddRange(tables.ToArray());
tablesListBox.Enabled = true;
tablesListBox.SelectedIndex = 0;
}
var sequences = metadataReader.GetSequences(ownersComboBox.SelectedItem.ToString());
sequencesComboBox.Enabled = false;
sequencesComboBox.Items.Clear();
if (sequences != null && sequences.Any())
{
sequencesComboBox.Items.AddRange(sequences.ToArray());
sequencesComboBox.Enabled = true;
sequencesComboBox.SelectedIndex = 0;
}
}
catch (Exception ex)
{
errorLabel.Text = ex.Message;
}
}
private void PopulateTablesAndSequences()
{
try
{
toolStripStatusLabel1.Text = "Retrieving tables...";
statusStrip1.Refresh();
if (ownersComboBox.SelectedItem == null)
{
tablesListBox.DataSource = new List <Table>();
return;
}
_tables = metadataReader.GetTables(ownersComboBox.SelectedItem.ToString());
tablesListBox.Enabled = false;
TableFilterTextBox.Enabled = false;
tablesListBox.DataSource = _tables;
tablesListBox.DisplayMember = "Name";
if (_tables != null && _tables.Any())
{
tablesListBox.Enabled = true;
TableFilterTextBox.Enabled = true;
tablesListBox.SelectedItem = _tables.FirstOrDefault();
}
var sequences = metadataReader.GetSequences(ownersComboBox.SelectedItem.ToString());
sequencesComboBox.Enabled = false;
sequencesComboBox.Items.Clear();
if (sequences != null && sequences.Any())
{
sequencesComboBox.Items.Add(""); // No sequence
sequencesComboBox.Items.AddRange(sequences.ToArray());
sequencesComboBox.Enabled = true;
sequencesComboBox.SelectedIndex = 0;
}
toolStripStatusLabel1.Text = string.Empty;
statusStrip1.Refresh();
}
catch (Exception ex)
{
toolStripStatusLabel1.Text = ex.Message;
}
}