Dotnet总结(2)--访问ms sql server 数据库基类--2

发表于:2007-06-30来源:作者:点击数: 标签:
// 测试数据库链接
        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;
        } 

原文转自:http://www.ltesting.net