//Close DataBase //关闭数据库连接 mySqlConnection.Close(); } //mySqlConnection is a SqlConnection object
if (mySqlConnection.State == ConnectionState.Closed || mySqlConnection.State == ConnectionState.Broken)
//获取数据库连接字符串 ConnectionString = ConnectionInfo.ConnectionString(); //创建连接对象 mySqlConnection = new SqlConnection(ConnectionString);
//ConnectionTimeout 在.net 1.x 可以设置 在.net 2.0 后是只读属性，则需要在连接 字符串设置
private static string ConnectionString = "";
private static bool IsCanConnectioned = false;
SqlConnection
/// <summary> /// 测试连接数据库是否成功 /// </summary> /// <returns></returns> public static bool ConnectionTest() {
// 如 ： 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 {
C#测试数据库连接是否成功
新建 ConnectionTestInfo 类 using System.Data.SqlClient; using System.Data;
public class ConnectionTestInfo
{
private
static
mySqlConnection; //mySqlConnection is a SqlConnection object
{ public ConnectionInfo() { }
/// <summary> /// 从配置文件中读取数据库联接字符串 /// </summary> /// <returns></returns> public static string ConnectionString() {
return (ConfigurationSettings.AppSetห้องสมุดไป่ตู้ings["ConnectionString"]); } }
{ //Connection is not available return IsCanConnectioned;
} else {
//Connection is available return IsCanConnectioned; } } }
其中数据库字符串调用了类 ConnectionInfo 的方法 ConnectionString public class ConnectionInfo