Public Function isValidArticleID(ByVal IDArticle As Integer) As Boolean mConn.Open() Dim mCommand As New SqlCommand("isValidArticleID", mConn) 'Paramètre de la procédure stockée mCommand.CommandType = CommandType.StoredProcedure mCommand.Parameters.Add("@ArticleID", IDArticle) Dim SQlReturn As New SqlParameter("@Return_Value", SqlDbType.Int) SQlReturn.Direction = ParameterDirection.ReturnValue mCommand.Parameters.Add(SQlReturn) Try mCommand.ExecuteScalar() If CType(SQlReturn.Value, Integer) = 1 Then Return True Else Return False End If Catch ex As Exception Return False Finally mConn.Close() End Try End Function
ALTER FUNCTION dbo.IsValidArticleID ( @ArticleID int) RETURNS int AS BEGIN DECLARE @return int SELECT @return=ID from Articles WHERE ID = @ArticleID IF @return IS NOT NULL RETURN 1 ELSE BEGIN RETURN 0 END RETURN 0 END