How to display the result of a stored procedure (implemented using cursors)

See more:

cursor

stored-procedure

My stored procedure is as follows, I have implemented it using stored procedures:

ALTER PROCEDURE VIEW_RESULTS

@formID INT

AS
DECLARE @questionID INT
DECLARE @applicantID INT
DECLARE @applicantName varchar(MAX)
DECLARE @qID INT
DECLARE @NewLineChar AS CHAR(2) = CHAR(13) + CHAR(10)


DECLARE all_applicants_cursor CURSOR FOR 
SELECT applicantID
FROM FormFillers
WHERE formID=@formID


DECLARE questions_cursor CURSOR FOR 
SELECT questionID 
FROM FormQuestions
WHERE formID=@formID

	
open all_applicants_cursor
FETCH NEXT FROM all_applicants_cursor 
INTO @applicantID

WHILE @@FETCH_STATUS = 0
BEGIN

		SELECT applicantName + CHAR(13)+CHAR(10) 
		From  RegisteredApplicants
		WHERE applicantID=@applicantID

			open questions_cursor
			FETCH NEXT FROM questions_cursor 
			INTO @qID

			WHILE @@FETCH_STATUS = 0
			BEGIN

				SELECT Q.questionText
				FROM FormQuestions Q, Answers A
				WHERE Q.questionID=@qID AND A.questionID=@qID AND A.applicantID=@applicantID

			FETCH NEXT FROM questions_cursor 
			INTO @qID	
    
			END 
			CLOSE questions_cursor;
			DEALLOCATE questions_cursor;
	
FETCH NEXT FROM all_applicants_cursor 
INTO @applicantID	
END 
CLOSE all_applicants_cursor;
DEALLOCATE all_applicants_cursor;

In My asp control(using grid view for experimenting), I need to display the result of this select statement:

SELECT Q.questionText
FROM FormQuestions Q, Answers A
WHERE Q.questionID=@qID AND A.questionID=@qID AND A.applicantID=@applicantID

But when I set the data source and test the query, the poped up message says: The query didn't returned any data tables.

This is my first attempt with the cursors, kindly assist me in this.
Thanks.