Dotnet总结（2）--访问ms sql server 数据库基类--2

2022-07-15 80酷酷网 80kuku.com

　　server|访问|数据|数据库// 测试数据库链接
        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;
        }