private void dbList_DropDown(object sender, EventArgs e)
{
if (_dbListPopulated)
{
return;
}
var prop = ConnectionProperties as MySqlConnectionProperties;
if (prop == null)
{
return;
}
var cb = prop.ConnectionStringBuilder;
try
{
using (var conn = new MySqlConnectionSupport())
{
conn.Initialize(null);
conn.ConnectionString = cb.ConnectionString;
conn.Open(false);
dbList.Items.Clear();
using (var reader = conn.Execute("SHOW DATABASES", 1, null, 0))
{
while (reader.Read())
{
string dbName = reader.GetItem(0).ToString().ToLowerInvariant();
if (dbName == "information_schema")
{
continue;
}
if (dbName == "mysql")
{
continue;
}
dbList.Items.Add(reader.GetItem(0));
}
_dbListPopulated = true;
}
}
}
catch (Exception ex)
{
MySqlSourceTrace.WriteAppErrorToLog(ex, Resources.ErrorTitle, Resources.UnableToRetrieveDatabaseList, true);
}
}
