public static DBConexion Instance() { if (frmInstance == null) { frmInstance = new DBConexion(); } return frmInstance; }
public DBConexion(string driver, string server, string port, string db, string user, string password) { this.server = server; this.puerto = port; this.database = db; this.usuarioDB = user; this.password = password; this.conn = new MySqlConnection("server=" + server + ";port=" + puerto + ";database=" + database + ";userid=" + usuarioDB + ";password="******";"); frmInstance = this; }
private void btnProbarConexion_Click(object sender, EventArgs e) { DDB.DBConexion conn = new DDB.DBConexion(Properties.Settings.Default.DRIVER, txtSERVER.Text, txtPUERTO.Text , txtDB.Text, txtUSER.Text, txtPASSWORD.Text); if (conn.conection.State == ConnectionState.Open) { MessageBox.Show("Conexion Exitosa", "CONEXION", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Conexion Fallo", "ERROR DE CONEXION", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void verificarConexionBD() { progressText.Text = "Verificando conexion con Base de Datos ..."; try { //seteando parametros de conexion DDB.DBConexion conn = new DDB.DBConexion(Properties.Settings.Default.DRIVER,Properties.Settings.Default.SERVER, Properties.Settings.Default.PUERTO, Properties.Settings.Default.DATABASE, Properties.Settings.Default.USERDB, Properties.Settings.Default.PASSWORD); progressText.Text = "Conexion con Base de Datos :" + conn.conection.State; if (conn.conection.State != ConnectionState.Open) { OK = false; } Thread.Sleep(1000); } catch (Exception ex) { progressText.Text = "Fallo conexion con Base de Datos"; OK = false; Thread.Sleep(1000); } }
public DBSIC() { conn = DBConexion.Instance(); }
public DBInvInicial() { conn = DBConexion.Instance(); }
public DBPartida() { conn = DBConexion.Instance(); }
public DBPac() { conn = DBConexion.Instance(); }
public DBCuenta() { conn = DBConexion.Instance(); }
public DBImages() { conn = DBConexion.Instance(); }
public DBMovCash() { conn = DBConexion.Instance(); }
public DBVencidos() { conn = DBConexion.Instance(); }
public DBReporte() { conn = DBConexion.Instance(); }
public DBTarjeta() { conn = DBConexion.Instance(); }
public DBGasto() { conn = DBConexion.Instance(); }
public DBUsuario() { conn = DBConexion.Instance(); }
public DBPRENDASAL() { conn = DBConexion.Instance(); }
public DBPrestamo() { conn = DBConexion.Instance(); }
public DBCatalogo() { conn = DBConexion.Instance(); }