public void CloseConnection() { try { _oLogErrors = new LogErrores(); _oConnection.Close(); } catch (Exception ex) { _oLogErrors.GuardarLog(IConstantes.TIPOCAPA.ACCESODATOS, this.GetType().ToString(), MethodInfo.GetCurrentMethod().Name, ex.Message); } }
public ProyectoZDA(string user, string password, string server, string port, string database = "master") { try { _oLogErrors = new LogErrores(); //string conexionBD = ConfigurationManager.AppSettings["CargoDispatcherDB"]; ConnectionString = "Data Source=" + server + "," + port + ";Network Library=DBMSSOCN;Initial Catalog=" + database + ";User ID=" + user + ";Password="******";Integrated Security = SSPI;"; } catch (Exception ex) { _oLogErrors.GuardarLog(IConstantes.TIPOCAPA.ACCESODATOS, this.GetType().ToString(), MethodInfo.GetCurrentMethod().Name, ex.Message); } }
public MysqlServerDA(string user, string password, string server, string port, string database="test") { try { _oLogErrors = new LogErrores(); //string conexionBD = ConfigurationManager.AppSettings["CargoDispatcherDB"]; ConnectionString = "server=" + server + ";user="******";database=" + database + ";port=" + port + ";password="******";"; } catch (Exception ex) { _oLogErrors.GuardarLog(IConstantes.TIPOCAPA.ACCESODATOS, this.GetType().ToString(), MethodInfo.GetCurrentMethod().Name, ex.Message); } }
/// <summary> /// This is the Base Class for all the DA Method's Inside This Library /// Date: 9/4/2014 /// Created By: Juan Pablo Arias Mora /// </summary> public SqlServerDA() { try { _oLogErrors = new LogErrores(); //string conexionBD = ConfigurationManager.AppSettings["CargoDispatcherDB"]; ConnectionString = "user id=ReplicationManager_su;" + "password=12345;server=localhost;" + "Trusted_Connection=yes;" + "database=ReplicationManager; " + "connection timeout=30"; //_oConnection = new MySqlConnection(conexionBD); } catch (Exception ex) { _oLogErrors.GuardarLog(IConstantes.TIPOCAPA.ACCESODATOS, this.GetType().ToString(), MethodInfo.GetCurrentMethod().Name, ex.Message); } }
private void LogViewer_Load(object sender, EventArgs e) { LogErrores tempLogErrores = new LogErrores(); string path = tempLogErrores.LogLocation(); rtbLog.LoadFile(path, RichTextBoxStreamType.PlainText); }
/// <summary> /// This method will Open the Connection Required. /// Date: 9/4/2014 /// Created By: Juan Pablo Arias Mora /// </summary> public void OpenConnection() { try { _oLogErrors = new LogErrores(); _oConnection = new SqlConnection(this.ConnectionString); _oConnection.Open(); //_oConnection = new MySqlConnection(ConfigurationManager.AppSettings["CargoDispatcherDB"]); } catch (Exception ex) { _oLogErrors.GuardarLog(IConstantes.TIPOCAPA.ACCESODATOS, this.GetType().ToString(), MethodInfo.GetCurrentMethod().Name, ex.Message); } }