/// <summary> /// 連接Access資料庫 /// </summary> /// <returns></returns> private DaoErrMsg ConnectAccess() { DaoErrMsg Err = new DaoErrMsg(); if (m_SQL != null) { //表示已開啟過;// return(Err); } m_SQL = CreateDbCom(DaoConfigFile.Instance.FileDatabase); Err = m_SQL.Connect(); if (Err.isError) { System.Diagnostics.Debug.WriteLine(Err.ErrorMsg); m_SQL = null; return(Err); } DatabaseConnectedChange?.Invoke(true); return(Err); }
/// <summary> /// 關閉資料庫連接 /// </summary> internal void CloseDatabase() { if (m_SQL == null) { return; } m_SQL.Close(); m_SQL = null; DatabaseConnectedChange?.Invoke(false); }
/// <summary> /// 連接MSSQL資料庫 /// </summary> /// <returns></returns> private DaoErrMsg ConnectMSSQL(string ServerPath, string DbName, string DbID, string DbPW) { DaoErrMsg Err = new DaoErrMsg(); if (m_MSSQL != null) { //表示已開啟過;// return(Err); } //建立資料庫連接字串 ////注意:SQLExpress版本要寫成:「.\sqlexpress」 //string strServerPath = Properties.Settings.Default.DB_SERVER_NAME; ////strServerPath = @"KEYNES-PC\EXPRESS"; //string strDbName = Properties.Settings.Default.DB_NAME; //string strDbID = Properties.Settings.Default.DB_ID; //string strDbPW = Properties.Settings.Default.DB_PW; string strConnection = string.Format(@"server={0};database={1};uid={2};pwd={3}", ServerPath, DbName, DbID, DbPW); m_MSSQL = new DaoDbCommon(strConnection, new SqlConnection()); Err = m_MSSQL.Connect(); if (Err.isError) { System.Diagnostics.Debug.WriteLine(Err.ErrorMsg); m_MSSQL = null; return(Err); } DatabaseConnectedChange?.Invoke(true); return(Err); }