/// <summary> /// Main Constructor - will instance a new MySqlConnection without Open. /// </summary> /// <param name="Server"></param> /// <param name="User"></param> /// <param name="Password"></param> /// <param name="Database"></param> public MySqlWrapper(string Server, int Port, string User, string Password, string Database) { mServer = Server; mPort = Port; mUser = User; mPassword = Password; mDatabase = Database; mState = MysqlState.Closed; }
/// <summary> /// internal method to Close an instanced Connection /// </summary> /// <param name="FreeConnection"></param> /// <returns></returns> public MysqlError Close(bool FreeConnection) { mLastError = null; if (mConnection == null) { mState = MysqlState.Error; return(MysqlError.CloseBeforeInit); } try { mConnection.Close(); if (mConnection.State != System.Data.ConnectionState.Closed) { mState = MysqlState.Error; return(MysqlError.FailedToClose); } } catch (MySqlException e) { mState = MysqlState.Error; mLastError = e; return(MysqlError.CanNotDisconnectFromDB); } catch (Exception e) { mState = MysqlState.Error; mLastError = e; return(MysqlError.UnknownClose); } finally { // free Memory if (mCommand != null) { mCommand.Dispose(); } if (mAdapter != null) { mAdapter.Dispose(); } if (FreeConnection == true && mConnection != null) { mConnection.Dispose(); } } mState = MysqlState.Closed; return(MysqlError.None); }
/// <summary> /// method to Open an instanced Connection /// </summary> /// <returns></returns> public MysqlError Open() { mLastError = null; if (mConnection == null) { return(MysqlError.OpenBeforeInit); } // no need to open if allready done if (mConnection.State == System.Data.ConnectionState.Open) { mState = MysqlState.Open; return(MysqlError.None); } try { mConnection.Open(); if (mConnection.State != System.Data.ConnectionState.Open) { mState = MysqlState.Error; return(MysqlError.FailedToOpen); } } catch (MySqlException e) { mState = MysqlState.Error; mLastError = e; return(MysqlError.CanNotConnectToDB); } catch (Exception e) { mState = MysqlState.Error; mLastError = e; return(MysqlError.UnknownOpen); } mState = MysqlState.Open; return(MysqlError.None); }
/// <summary> /// internal method to Close an instanced Connection /// </summary> /// <param name="FreeConnection"></param> /// <returns></returns> public MysqlError Close( bool FreeConnection ) { mLastError = null; if( mConnection == null ) { mState = MysqlState.Error; return MysqlError.CloseBeforeInit; } try { mConnection.Close(); if( mConnection.State != System.Data.ConnectionState.Closed ) { mState = MysqlState.Error; return MysqlError.FailedToClose; } } catch( MySqlException e ) { mState = MysqlState.Error; mLastError = e; return MysqlError.CanNotDisconnectFromDB; } catch( Exception e ) { mState = MysqlState.Error; mLastError = e; return MysqlError.UnknownClose; } finally { // free Memory if( mCommand != null ) mCommand.Dispose(); if( mAdapter != null ) mAdapter.Dispose(); if( FreeConnection == true && mConnection != null ) mConnection.Dispose(); } mState = MysqlState.Closed; return MysqlError.None; }
/// <summary> /// method to Open an instanced Connection /// </summary> /// <returns></returns> public MysqlError Open() { mLastError = null; if( mConnection == null ) return MysqlError.OpenBeforeInit; // no need to open if allready done if( mConnection.State == System.Data.ConnectionState.Open ) { mState = MysqlState.Open; return MysqlError.None; } try { mConnection.Open(); if( mConnection.State != System.Data.ConnectionState.Open ) { mState = MysqlState.Error; return MysqlError.FailedToOpen; } } catch( MySqlException e ) { mState = MysqlState.Error; mLastError = e; return MysqlError.CanNotConnectToDB; } catch( Exception e ) { mState = MysqlState.Error; mLastError = e; return MysqlError.UnknownOpen; } mState = MysqlState.Open; return MysqlError.None; }
/// <summary> /// Main Constructor - will instance a new MySqlConnection without Open. /// </summary> public MySqlWrapper() { mState = MysqlState.Closed; }
/// <summary> /// Main Constructor - will instance a new MySqlConnection without Open. /// </summary> /// <param name="Server"></param> /// <param name="User"></param> /// <param name="Password"></param> /// <param name="Database"></param> public MySqlWrapper( string Server, int Port, string User, string Password, string Database ) { mServer = Server; mPort = Port; mUser = User; mPassword = Password; mDatabase = Database; mState = MysqlState.Closed; }