子晴的编程日记

记录我的编程日记

导航

验证连接数据库方法

private static SqlConnection mySqlConnection;
private static bool IsCanConnectioned = false;
public bool GetConnection()
{
mySqlConnection = new SqlConnection(MySqlConnection.connectionString);
try
{
//Open DataBase
//打开数据库
mySqlConnection.Open();
IsCanConnectioned = true;
}
catch
{
//Can not Open DataBase
//打开不成功 则连接不成功
IsCanConnectioned = false;
}
finally
{
//Close DataBase
//关闭数据库连接
mySqlConnection.Close();
}
return IsCanConnectioned;
}

posted on 2019-08-22 11:20  子晴的编程日记  阅读(314)  评论(0编辑  收藏  举报