private void dbList_DropDown(object sender, EventArgs e)
{
if (dbListPopulated)
{
return;
}
AdoDotNetConnectionProperties prop =
(ConnectionProperties as AdoDotNetConnectionProperties);
DbConnectionStringBuilder cb = prop.ConnectionStringBuilder;
try
{
using (MySqlConnectionSupport conn = new MySqlConnectionSupport())
{
conn.Initialize(null);
conn.ConnectionString = cb.ConnectionString;
conn.Open(false);
dbList.Items.Clear();
using (DataReader 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)
{
MessageBox.Show(Resources.UnableToRetrieveDatabaseList);
}
}
private void dbList_DropDown(object sender, EventArgs e)
{
if (dbListPopulated) return;
AdoDotNetConnectionProperties prop =
(ConnectionProperties as AdoDotNetConnectionProperties);
DbConnectionStringBuilder cb = prop.ConnectionStringBuilder;
try
{
using (MySqlConnectionSupport conn = new MySqlConnectionSupport())
{
conn.Initialize(null);
conn.ConnectionString = cb.ConnectionString;
conn.Open(false);
dbList.Items.Clear();
using (DataReader 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)
{
MessageBox.Show(Resources.UnableToRetrieveDatabaseList);
}
}
