Question

用C#判断sql服务器是否启动

C#Winform的，我想在连接数据库的时候判断下服务器是否启动！

Answer 1

你可以看看这段代码，相信应该有用。在连接之前先判断，如果是打开的则将连接关闭后再重新打开，如果不是，则直接打开

private static SqlConnection connection;

public static SqlConnection Connection

{

get

{

string connectionString = @"";//数据库连接语句

if (connection == null)

{

connection = new SqlConnection(connectionString);

connection.Open();

}

else if (connection.State == System.Data.ConnectionState.Closed)

{

connection.Open();

}

else if (connection.State == System.Data.ConnectionState.Broken)

{

connection.Close();

connection.Open();

}

return connection;

}

}