数据库连接判断

public bool IsConnected()
    {
        SqlConnection connection = new SqlConnection(connectionString);//connectionString 数据库连接字符串
        try
        {
            if (connection.State != ConnectionState.Open)
            {
                connection.Open();
            }
            return true;
        }
        catch
        {
            return false;
        }
    }
posted @ 2012-07-04 23:37  盈不足  阅读(165)  评论(0编辑  收藏  举报