Can't Get A Simple Code To Work

Can someone please help me fix this. The if statement always runs. I only want it to run if the statement is true and there is a result coming back. If the productID does not have any magazines linking to it, I don't want the If statement to run. Thanks in advance.








ASP.NET code:





If Not Magazine.GetMagazinesForProduct(ProductID) Is Nothing Then


blanklabel.Text = categoryDetails.Spacer


blanklabel.Visible = True


blanklabel2.Text = categoryDetails.Spacer


blanklabel2.Visible = True


magazinerecommendedlabel.Text = "Recommended/Featured in the following magazine(s):"


magazinerecommendedlabel.Visible = True


End If


-------------------------





magazine class:





Public Function GetMagazinesForProduct(ByVal productID As String) As SqlDataReader


Dim connection As New SqlConnection(connectionString)





Dim command As New SqlCommand("GetMagazinesForProduct", connection)


command.CommandType = CommandType.StoredProcedure





command.Parameters.Add("@ProductID", SqlDbType.VarChar, 50)


command.Parameters("@ProductID").Value = productID





connection.Open()





Return command.ExecuteReader(CommandBehavior.CloseConnection)


End Function





-----------------------





Stored Procedure:





CREATE PROCEDURE GetMagazinesForProduct


(@ProductID varchar)


AS


SELECT Magazine.[Name], Magazine.[Issue], Magazine.SmallImagePath


FROM Magazine INNER JOIN MagazineProduct


ON Magazine.MagazineID = MagazineProduct.MagazineID


WHERE MagazineProduct.ProductID = @ProductID


RETURN


GO





--------------------------