JinYeTransportCostsSystem/ConnectionTestInfo.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace JinYeTransportCostsSystem
{
   public class ConnectionTestInfo
    {
        private static SqlConnection mySqlConnection;  
        private static string ConnectionString = "";
        private static bool IsCanConnectioned = false;
        /// <summary>
        /// 测试连接数据库是否成功
        /// </summary>
        /// <returns></returns>
        public static bool ConnectionTest()
        {
            ConnectionString = ConnectionInfo.ConnectionString();
            mySqlConnection = new SqlConnection(ConnectionString);
            try
            {
                mySqlConnection.Open();
                IsCanConnectioned = true;
            }
            catch
            {
                IsCanConnectioned = false;
            }
            finally
            {
                mySqlConnection.Close();
            }
            if (mySqlConnection.State == ConnectionState.Closed || mySqlConnection.State == ConnectionState.Broken)
            {
                return IsCanConnectioned;
            }
            else
            {
                return IsCanConnectioned;
            }
        }

    }
    public class ConnectionInfo
    {
        public ConnectionInfo() { }
        public static string ConnectionString()
        {
           return Tsr.DBUtility.PubConstant.ConnectionString;
        }
    }
    
}