private void Button1_Click(object sender, EventArgs e) { if (serverData.Count > 0) { var server = sqlservers.CreateSqlServerFromDataTable(serverData, comboBox1); if (server != null) { server.password = textBoxPassword.Text; ConnectionResultSet result = DB.TestConnection(server); if (result.wasSuccessful) { var con = DB.connect(server); this.OnConnectionChanged(this, new ConnectionEventArgs(con, server)); Close(); } else { this.UseWaitCursor = false; MessageBox.Show("Connection failed: \n" + result.errorMessage, "Test Connection", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } else { WarnNoServersSaved(); } }
private void Button2_Click(object sender, EventArgs e) { if (serverData.Count > 0) { var server = DbUtils.getSqlServerFromTable(serverData, comboBox1); if (server != null) { //test connection ConnectionResultSet result = DB.TestConnection(server); if (result.wasSuccessful) { this.UseWaitCursor = false; MessageBox.Show("Connection Successful", "Test Connection", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { this.UseWaitCursor = false; MessageBox.Show("Connection failed: \n" + result.errorMessage, "Test Connection", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } else { WarnNoServersSaved(); } }
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 Reconnect() { if (server != null && con != null) { con.Close(); ConnectionResultSet result = DB.TestConnection(server); if (result.wasSuccessful) { var con = DB.connect(server, this.con.Database); this.SetReconnectionStatus(con); } } }
private void fillDatabaseCmb(object sender, DoWorkEventArgs args) { if (cmbServers.Items.Count == 0) { return; } //ama den iparxei kanenas server den to kanei DbConnection con = new DbConnection(); con.Host = (string)serverData.Rows[cmbServers.SelectedIndex]["host"]; con.port = unchecked ((int)(long)serverData.Rows[cmbServers.SelectedIndex]["port"]); con.username = (string)serverData.Rows[cmbServers.SelectedIndex]["username"]; con.password = (string)serverData.Rows[cmbServers.SelectedIndex]["password"]; Console.WriteLine("cmbServers.Items.Count" + cmbServers.Items.Count); //edw prepei na bei to database kai mia if then else apo katw analoga ama kanei connect se server i se database try { ConnectionResultSet result = con.testConnection(); if (result.wasSuccessful) { List <string> databases = con.getDatabases(); databases.Remove("information_schema"); databases.Remove("mysql"); databases.Remove("performance_schema"); databases.Remove("sys"); cmbdatabase.Items.Clear(); foreach (string database in databases) { TreeNode node = new TreeNode(database); node.ImageIndex = 0; cmbdatabase.Items.Add(database); Console.WriteLine(database); } if (cmbdatabase.Items.Count > 0) { cmbdatabase.SelectedIndex = 0; } } else { MessageBox.Show("Connection failed: \n" + result.errorMessage, "Test Connection", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
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 fillDatabaseCmb(object sender, DoWorkEventArgs args) { if (cmbServers.Items.Count == 0) { return; } //ama den iparxei kanenas server den to kanei //edw prepei na bei to database kai mia if then else apo katw analoga ama kanei OldMySqlConnect se server i se database try { ConnectionResultSet result = DB.TestConnection(this.getServerFromUI());//con.testConnection(); if (result.wasSuccessful) { using (var con = DB.connect(this.getServerFromUI())) { List <string> databases = DbUtils.getDatabases(this.getServerFromUI()); databases.Remove("information_schema"); databases.Remove("mysql"); databases.Remove("performance_schema"); databases.Remove("sys"); cmbdatabase.Items.Clear(); foreach (string database in databases) { TreeNode node = new TreeNode(database); node.ImageIndex = 0; cmbdatabase.Items.Add(database); Console.WriteLine(database); } if (cmbdatabase.Items.Count > 0) { cmbdatabase.SelectedIndex = 0; } } } else { MessageBox.Show("Connection failed: \n" + result.errorMessage, "Test Connection", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void bTestConnection_Click(object sender, EventArgs e) { if (!performChecks()) { return; } //test connection ConnectionResultSet result = con.testConnection(); if (result.wasSuccessful) { MessageBox.Show("Connection Successful", "Test Connection", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Connection failed: \n" + result.errorMessage, "Test Connection", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void bTestConnection_Click(object sender, EventArgs e) { if (!performChecks()) { return; } this.UseWaitCursor = true; //test connection ConnectionResultSet result = DB.TestConnection(createMySqlServerInfoCreds(), tbDatabase.Text); if (result.wasSuccessful) { this.UseWaitCursor = false; MessageBox.Show("Connection Successful", "Test Connection", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { this.UseWaitCursor = false; 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 DbConnection con = new DbConnection(); this.Invoke((MethodInvoker) delegate() { con.Host = (string)serverData.Rows[cmbServers.SelectedIndex]["host"]; con.port = unchecked ((int)(long)serverData.Rows[cmbServers.SelectedIndex]["port"]); con.username = (string)serverData.Rows[cmbServers.SelectedIndex]["username"]; con.password = (string)serverData.Rows[cmbServers.SelectedIndex]["password"]; }); //edw prepei na bei to database kai mia if then else apo katw analoga ama kanei connect se server i se database ConnectionResultSet result = con.testConnection(); if (result.wasSuccessful) { List <string> databases = con.getDatabases(); if (hideSystemDatabases) { databases.Remove("information_schema"); databases.Remove("mysql"); databases.Remove("performance_schema"); databases.Remove("sys"); } foreach (string database in databases) { this.Invoke((MethodInvoker) delegate() { TreeNode node = new TreeNode(database); node.ImageIndex = 0; List <string> tables = con.getTables(database); 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; }); } 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); }); } 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); }); } }