(ASK) Ke Master C# cara ambil keluaran SP di WEB Service

[Guesuper]

Gini gan ... ane punya Store Procedure yang isi nya cursor




Code:

alter PROCEDURE SP_Cursor3 as
begin
declare CsrMsiswa cursor
for select * from m

open CsrMsiswa

declare @NIK int
declare @NAMA char(30)
declare @NO INT
SET @NO=1

PRINT 'DAFTAR NILAI MAHASISWA'
PRINT 'MATA KULIAH'
PRINT 'DOSEN'
PRINT 'NO. NIK NAMA 1 2 3 4 5 rata-2'
PRINT '==============================================='

fetch next from CsrMsiswa into @NIK, @NAMA
while @@FETCH_STATUS=0
BEGIN PRINT CONVERT(CHAR(6),@NO) + CONVERT(CHAR(7),@NIK)+ @NAMA
SET @NO= @NO+1
FETCH NEXT FROM CsrMsiswa into @NIK, @NAMA
end
PRINT '==============================================='

close CsrMsiswa
deallocate CsrMsiswa
end
go

yang ane mau tanya.... web method nya kaya gmn supaya bisa ambil keluaran dari Stored procedure di atas...



thanx gan :ceriwislove:

</div>