private void SetWhereView()
{
if (tableComboBox.Text != String.Empty && dbComboBox.Text != String.Empty)
{
whereColumnBox.Items.Clear();
opBox.Items.Clear();
Dictionary <string, string> columns = _runner.GetTable(dbComboBox.Text, tableComboBox.Text).Columns;
if (columns.Count > 0)
{
foreach (var col in columns)
{
whereColumnBox.Items.Add(col.Key);
}
opBox.Items.Add(">");
opBox.Items.Add("=");
opBox.Items.Add("<");
opBox.Items.Add("<>");
opBox.Items.Add(">=");
opBox.Items.Add("<=");
wherePanel.Enabled = true;
}
}
else
{
wherePanel.Enabled = false;
}
}
public void SetProperties(string dbName, string tableName)
{
Init();
var databases = _runner.GetDatabaseList().ToList();
if (databases.Count > 0)
{
foreach (var db in databases)
{
dbNameBox.Items.Add(db.Name);
}
if (dbName == tableName && dbName == string.Empty)
{
dbNameBox.SelectedIndex = 0;
}
else
{
tableNameTextBox.Text = tableName;
tableNameTextBox.Enabled = false;
dbNameBox.Text = dbName;
dbNameBox.Enabled = false;
Dictionary <string, string> columns = _runner.GetTable(dbName, tableName).Columns;
CreateTableView(columns);
}
}
}
