private void SetInitialConnectionStatus(ConnectionEventArgs e)
{
this.con = e.con;
this.server = e.server;
SetAutoCommit(con);
this.setConnectionAndServerToUserControls();
this.setHomeConnectionStatus();
}
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 fillTreeView()
{
if (cmbServers.Items.Count == 0)
{
return;
} //ama den iparxei kanenas server den to kanei
sqlservers server = null;
this.Invoke((MethodInvoker) delegate()
{
server = DbUtils.getSqlServerFromTable(serverData, cmbServers);
});
//edw prepei na bei to database kai mia if then else apo katw analoga ama kanei OldMySqlConnect se server i se database
ConnectionResultSet result = DB.TestConnection(server);
if (result.wasSuccessful)
{
MySqlConnection con = (MySqlConnection)DB.connect(server);
List <string> databases = DbUtils.getDatabases(server, con);//con.getDatabases();
if (hideSystemDatabases)
{
databases = DbUtils.removeSystemDatabases(databases);
}
foreach (string database in databases)
{
this.Invoke((MethodInvoker) delegate() {
TreeNode node = new TreeNode(database);
node.ImageIndex = 0;
List <string> tables = DbUtils.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 openDatabaseWindow()
{
var databaseConnector = new DatabaseConnect();
databaseConnector.TopMost = true;
databaseConnector.Show();
this.EnableDisable(false);
databaseConnector.onConnect += (sender, e) =>
{
this.con = e.con;
SetAutoCommit(con);
this.server = e.server;
this.setConnectionAndServerToUserControls();
this.setHomeConnectionStatus();
};
databaseConnector.FormClosed += (sender, e) => this.EnableDisable(true);
}
private void menuClick(object sender, EventArgs e)
{
sqlservers server = DbUtils.getSqlServerFromTable(serverData, cmbServers);
if (tvDatabases.SelectedNode != null && tvDatabases.SelectedNode.Parent == null)
{
string database = tvDatabases.SelectedNode.Text;
if (sender.ToString() == "browse data")
{
SqlDbViewerForm sqlform = new SqlDbViewerForm(server, database);
sqlform.Show();
}
else if (sender.ToString() == "inspect database")
{
AnalyzeDbForm adbf = new AnalyzeDbForm(server, database);
adbf.Show();
}
}
else
{
if (tvDatabases.SelectedNode != null && tvDatabases.SelectedNode.Parent != null)
{
string database = tvDatabases.SelectedNode.Parent.Text;
if (sender.ToString() == "browse data")
{
SqlDbViewerForm sqlform = new SqlDbViewerForm(server, database);
sqlform.Show();
}
else if (sender.ToString() == "inspect database")
{
AnalyzeDbForm adbf = new AnalyzeDbForm(server, database);
adbf.Show();
}
}
}
}
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 = DbUtils.getSqlServerFromTable(serverData, cmbServers);
});
//edw prepei na bei to database kai mia if then else apo katw analoga ama kanei OldMySqlConnect se server i se database
ConnectionResultSet result = DB.TestConnection(server);
if (result.wasSuccessful)
{
MySqlConnection con = (MySqlConnection)DB.connect(server);
List <string> databases = DbUtils.getDatabases(server, con);//con.getDatabases();
if (hideSystemDatabases)
{
databases = DbUtils.removeSystemDatabases(databases);
}
foreach (string database in databases)
{
this.Invoke((MethodInvoker) delegate() {
TreeNode node = new TreeNode(database);
node.ImageIndex = 0;
List <string> tables = DbUtils.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);
});
}
this.Invoke((MethodInvoker) delegate() {
ToolStripMenuItem opendb = new ToolStripMenuItem();
ToolStripMenuItem analyzedb = new ToolStripMenuItem();
opendb.Text = "browse data";
opendb.Tag = "sql";
opendb.Click += new EventHandler(menuClick);
analyzedb.Text = "inspect database";
analyzedb.Click += new EventHandler(menuClick);
ContextMenuStrip menu = new ContextMenuStrip();
menu.Items.AddRange(new ToolStripMenuItem[] { opendb, analyzedb });
tvDatabases.ContextMenuStrip = menu;
});
DB.close(con);
}
else
{
this.Invoke((MethodInvoker) delegate() {
MessageBox.Show("Connection failed: \n" + result.errorMessage, "Test Connection", MessageBoxButtons.OK, MessageBoxIcon.Error);
});
}
}
