How can I return a cursor from a stored procedure to a data grid
Posted on 2006-05-24
I have a select that I need to convert into a cursor in order to pass it to the data grid.
1. This is the stored procedure
CREATE PROCEDURE SP_1
FROM PROVIDERS AS P,
OTHERPROVIDERS AS DP
WHERE DP.PROVIDERID = P.PROVIDERID
AND DP.COD1 = @PAR1
AND DP.COD2 = @PAR2
2. I'm using c#, asp.net 2003 and I need to conect my form with this cursor. Where, how and what should I do to acomplish this funcionality?
Thank you very much.....