How to fetch all separated result in Stored Procedure with While Loop

Hello Everyone,

That is the query result of my stored procedure (with while loop). The problem is when I fetch it using :

While sqlreader.read

.....

End While

It only reads one row. Is there a way to fetch all that result even if they are being separated by While Loop in my Stored Procedure?

Thank you guys.

- Charlie