private void fillTreeView()
{
if (cmbServers.Items.Count == 0)
{
return;
} //ama den iparxei kanenas server den to kanei
sqlservers server = null;
this.Invoke((MethodInvoker) delegate()
{
server = sqlservers.CreateSqlServerFromDataTable(serverData, cmbServers);
});
ConnectionResultSet result = DB.TestConnection(server);
if (result.wasSuccessful)
{
DbConnection con = DB.connect(server);
List <string> databases = null;
if (Utils._convert(server.db_type) == sqlbox.commons.DbType.SQLITE)
{
databases = new List <string>()
{
"main"
};
}
else
{
databases = new SqlBuilderFactory(server)
.Create(null).removeSystemDatabases(DbDataHelper.getDatabases(server, con), !hideSystemDatabases);
}
foreach (string database in databases)
{
this.Invoke((MethodInvoker) delegate()
{
TreeNode node = new TreeNode(database);
node.ImageIndex = 0;
List <string> tables = DbDataHelper.getTables(server, database, con);
foreach (string table in tables)
{
TreeNode tablenode = new TreeNode(table);
tablenode.ImageIndex = 1;
node.Nodes.Add(tablenode);
}
tvDatabases.Nodes.Add(node);
});
}
DB.close(con);
}
else
{
this.Invoke((MethodInvoker) delegate()
{
MessageBox.Show("Connection failed: \n" + result.errorMessage, "Test Connection", MessageBoxButtons.OK, MessageBoxIcon.Error);
});
}
}
private void ComboBoxServers_SelectedIndexChanged(object sender, EventArgs e)
{
if (!Utils.IsDbEmbedded(GetServer().db_type))
{
base.changeDatabase(comboBoxServers.SelectedItem.ToString());
}
var tables = DbDataHelper.getTables(base.GetSqlConnection());
this.initTabControl(comboBoxServers.SelectedItem.ToString(), tables);
GetMainHome().GetUserControl <Editor>().UpdateEditor(
new SqlBuilderFactory(base.GetSqlConnection()).Create(null).removeSystemDatabases(tables, false));
}
private void setDatagridviewTables(List <string> tables)
{
setRootTablesIntoTreeView(new SqlBuilderFactory(base.GetSqlConnection())
.Create(null).removeSystemDatabases(tables == null ? DbDataHelper.getTables(base.GetSqlConnection()) : tables, false));
}
