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)); }