private void testConnectionBtn_Click(object sender, EventArgs e) { this.user = userInput.Text; this.password = passwordInput.Text; SQLServer server = new SQLServer(this.sqlserver, this.user, this.password, this.database); if (server.testConnection()) { Alert.Info("La conexion con la base de datos es correcta"); } else { Alert.Warning("No se puede conectar con el servidor o con la base de datos :("); } }
private void initHostsDropDown() { List <string> servers = SQLServer.getHosts(); if (servers.Count > 0) { for (int i = 0; i < servers.Count; i++) { hostsDropDown.Items.Add(servers[i]); } } else { Alert.Warning("No se han encontrado servidores de Microsoft SQL Server"); } }
private void conexionBtn_Click(object sender, EventArgs e) { this.user = userInput.Text; this.password = passwordInput.Text; Form dbform = new Form2(); SQLServer server = new SQLServer(this.sqlserver, this.user, this.password, this.database); if (server.testConnection()) { Program.dbxml = new DBtoXML(server.getConnection()); Program.dbName = this.database; dbform.Show(); this.Hide(); } else { Alert.Warning("Error al conectarse con la base de datos"); } }
private void hostsDropDown_SelectedIndexChanged(object sender, EventArgs e) { this.sqlserver = (string)hostsDropDown.SelectedItem; SQLServer servidor = new SQLServer(this.sqlserver); List <string> dbs = servidor.getDataBases(); dbDropDown.Items.Clear(); // limpiamos la lista de bases de datos if (dbs.Count > 0) { for (int i = 0; i < dbs.Count; i++) { dbDropDown.Items.Add(dbs[i]); } } else { Alert.Warning("No se han encontrado bases de datos en este servidor"); } }
private void connectSilentModeBtn_Click(object sender, EventArgs e) { this.user = userInput.Text; this.password = passwordInput.Text; Form standAloneForm = new Standalone(); // formulario para programar el modo silencioso SQLServer server = new SQLServer(this.sqlserver, this.user, this.password, this.database); if (server.testConnection()) { Program.dbxml = new DBtoXML(server.getConnection()); Program.dbName = this.database; this.saveConf(); standAloneForm.Show(); this.Hide(); } else { Alert.Warning("Error al conectarse con la base de datos"); } }