Dotnet總結（2）--訪問ms sql server 數據庫基類--2

- 中國WEB開發者網絡 (http://www.webasp.net)
-- 技術教程 (http://www.webasp.net/article/)
--- Dotnet總結（2）--訪問ms sql server 數據庫基類--2 (http://www.webasp.net/article/18/17580.htm)
-- 作者：未知
-- 發佈日期： 2005-04-18
// 測試數據庫鏈接
        public static bool TestDBConnect(string strDSN)
        {
            bool bReturn = true;
            SqlConnection oSqlConnection = new SqlConnection(strDSN);
            int iTmp = oSqlConnection.ConnectionTimeout;
            try
            {
                oSqlConnection.Open();                
            }
            catch
            {
                bReturn = false;
            }
            finally
            {
                oSqlConnection.Close();
                oSqlConnection.Dispose();
            }
            return bReturn;
        } 
webasp.net