c# mysql 数据库连接测试_C#测试数据库连接是否成功

新建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;

///

/// 测试连接数据库是否成功

///

///

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() { }

///

/// 从配置文件中读取数据库联接字符串

///

///

public static string ConnectionString()

{

return (ConfigurationSettings.AppSettings["ConnectionString"]);

}

}