private void btnxConn_Click(object sender, EventArgs e) { //string sChaine; if (txtnomBD.Text.Equals("") || txtnomuser.Text.Equals("") || txtpwd.Text.Equals("")) { MessageBox.Show(this, "Valeurs de connexion a la base des donnees manquantes !", "Missing data ..."); txtnomuser.Focus(); } else { try { this.Cursor = Cursors.WaitCursor; chaineconn = @"Data Source=" + txtnomserveur.Text + ";Initial Catalog=" + txtnomBD.Text.Trim() + ";User ID=" + txtnomuser.Text.Trim() + ";Password="******"Connection to the database successfully.", "Connected to the database", MessageBoxButtons.OK, MessageBoxIcon.Information); mainform.strconn = chaineconn; mainform.usern = this.txtnomuser.Text.Trim(); mainform.LockMenu(true); } catch (Exception erreur) { MessageBox.Show(erreur.Message , "" , MessageBoxButtons.OK , MessageBoxIcon.Error); mainform.xconnf = null; return; } this.Cursor = Cursors.Default; _Myconn.Close(); this.Close(); } }
//CONNEXION A LA BASE DES DONNEES public void btnConnect_Click(object sender, EventArgs e) { //string sChaine; if (cboDatabases.Text.Trim() != "xEntryDbz") { MessageBox.Show("Base des donnees incorrect. Reessayer SVP.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); cboDatabases.Focus(); } else { try { this.Cursor = Cursors.WaitCursor; chaineconn = @"Data Source=" + cboServeur.Text + ";Initial Catalog=" + cboDatabases.Text.Trim() + ";User ID=" + txtUser.Text.Trim() + ";Password="******"Connection to the database successfully.", "Connected to the database", MessageBoxButtons.OK, MessageBoxIcon.Information); mainform.strconn = chaineconn; mainform.usern = this.txtUser.Text.Trim(); mainform.LockMenu(true); } catch (Exception erreur) { MessageBox.Show(erreur.Message , "" , MessageBoxButtons.OK , MessageBoxIcon.Error); } this.Cursor = Cursors.Default; _Myconn.Close(); this.Close(); } }