Ceriwis  

Go Back   Ceriwis > HOBI > Komputer & Teknologi > Programming

Programming Share, tanya jawab, saling bantu antar programmer dengan berbagai macam bahasa pemrograman.

Reply
 
Thread Tools
  #1  
Old 20th November 2011
Guesuper Guesuper is offline
Ceriwiser
 
Join Date: Nov 2011
Posts: 408
Rep Power: 14
Guesuper mempunyai hidup yang Normal
Default (ASK) Ke Master C# cara ambil keluaran SP di WEB Service

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



Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


 


All times are GMT +7. The time now is 06:22 AM.


no new posts