/// <summary> /// Método desconecta todos os links /// </summary> public void desconectar() { DB4.Close(); Contas.Close(); //Small.Close(); DB4net.Close(); Contasnet.Close(); //Smallnet.Close(); }
/// <summary> /// Método desconecta todos os links /// </summary> public void desconectar() { DB4.Close(); if (Contas.State != 0) { Contas.Close(); } //Small.Close(); if (DB4.State != 0) { DB4net.Close(); } if (Contasnet.State != 0) { Contasnet.Close(); } //Smallnet.Close(); }
/// <summary> /// Método que conectar os links via ado.net 4.0 aos bancos de dados. /// </summary> public void conectarNet() { if (DB4net.State == ConnectionState.Closed) { DB4net.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + endereco + "BD4.mdb;Persist Security Info=False;Jet OLEDB:Database Password=''"; DB4net.Open(); } if (Contasnet.State == ConnectionState.Closed) { Contasnet.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source= Server.MapPath(" + endereco + "contas.mdb);Persist Security Info=False;Jet OLEDB:Database Password=495798"; Contasnet.Open(); } if (Smallnet.State == ConnectionState.Closed) { Smallnet.ConnectionString = endSamll; Smallnet.Open(); } }