//新建ConnectionTestInfo类 using System.Data.SqlClient; using System.Data; public class ConnectionTestInfo { private static SqlConnection mySqlConnection; //mySqlConnection is a SqlConnection object private static string ConnectionString = ""; private static bool IsCanConnectioned = false; /// <summary> /// 测试连接数据库是否成功 /// </summary> /// <returns></returns> public static bool ConnectionTest() { //获取数据库连接字符串 ConnectionString = ConnectionInfo.ConnectionString(); //创建连接对象 mySqlConnection = new SqlConnection(ConnectionString); //ConnectionTimeout 在.net 1.x 可以设置 在.net 2.0后是只读属性,则需要在连接字符串设置 //如:server=.;uid=sa;pwd=;database=PMIS;Integrated Security=SSPI; Connection Timeout=30 //mySqlConnection.ConnectionTimeout = 1;//设置连接超时的时间 try { //Open DataBase //打开数据库 mySqlConnection.Open(); IsCanConnectioned = true; } catch { //Can not Open DataBase //打开不成功 则连接不成功 IsCanConnectioned = false; } finally { //Close DataBase //关闭数据库连接 mySqlConnection.Close(); } //mySqlConnection is a SqlConnection object if (mySqlConnection.State == ConnectionState.Closed || mySqlConnection.State == ConnectionState.Broken) { //Connection is not available return IsCanConnectioned; } else { //Connection is available return IsCanConnectioned; } } } //其中数据库字符串调用了类ConnectionInfo的方法ConnectionString public class ConnectionInfo { public ConnectionInfo() { } /// <summary> /// 从配置文件中读取数据库联接字符串 /// </summary> /// <returns></returns> public static string ConnectionString() { return (ConfigurationSettings.AppSettings["ConnectionString"]); } }
转载于:https://blog.51cto.com/baobaolovetutu/1262323