private void cb_connexion_SelectedIndexChanged(object sender, EventArgs e) { int x = cb_connexion.SelectedIndex; if (x >= -1) { groupBox1.Enabled = true; tb_name.Text = tb_connectionstring.Text = tb_database.Text = tb_fichier.Text = tb_login.Text = tb_password.Text = tb_port.Text = tb_server.Text = ""; int y = QueryLauncher.GetSGBD(QueryLauncher.connexions[x].SGBD.ToString()); if (y > -1) { cb_database.SelectedIndex = y; } tb_name.Text = QueryLauncher.connexions[x].Name; tb_server.Text = QueryLauncher.connexions[x].Server; tb_port.Text = QueryLauncher.connexions[x].Port.ToString(); tb_database.Text = QueryLauncher.connexions[x].Database; tb_login.Text = QueryLauncher.connexions[x].Login; tb_password.Text = QueryLauncher.connexions[x].Password; tb_fichier.Text = QueryLauncher.connexions[x].Fichier; tb_connectionstring.Text = QueryLauncher.connexions[x].ConnectionString; } }
private void b_test_Click(object sender, EventArgs e) { if (cb_connexion.SelectedIndex > -1) { Connexion co = new Connexion { SGBD = ((SGBD)cb_database.SelectedItem).Nom, ConnectionString = tb_connectionstring.Text }; IDatabase dbtest = QueryLauncher.Connect(co); MessageBox.Show((dbtest.Connected) ? "Connexion OK" : "Erreur de connexion : " + dbtest.LastError); } }
public String BuildConnectionString() { String connectionString = ""; SGBD s = QueryLauncher.sgbds[QueryLauncher.GetSGBD(SGBD)]; connectionString = s.DefaultConnectionString.Replace("{server}", Server) .Replace("{login}", Login) .Replace("{password}", Password) .Replace("{database}", Database) .Replace("{port}", Port.ToString()) .Replace("{fichier}", Fichier); return(connectionString); }
public ConnectManager(QueryLauncher parent) { InitializeComponent(); this.parent = parent; cb_connexion.Items.AddRange(QueryLauncher.connexions.ToArray()); foreach (SGBD s in QueryLauncher.sgbds) { cb_database.Items.Add(s); } cb_database.SelectedIndex = 0; groupBox1.Enabled = false; }