如何在C＃中显示SQL``RINT''命令的输出？

医龙

我有一个始终返回“ PRINT”命令的SQL过程，我想提取此“ PRINT”命令的输出，即C＃中的过程，我该怎么做？这是程序
ALTER PROC ResultsPoll
@pollid INT
1 d! v! }! v0 i/ v% K4 [3 TAS
$ q) _7 ~- D( m6 Z/ t3 @DECLARE @count1 INT
* d9 {: \! Y. a( {. o* e# j2 ~: `DECLARE @count2 INT
, T& m4 m- g# x, NDECLARE @count3 INT
1 ~+ x6 r7 _, \0 f# q# Y/ iDECLARE @count4 INT
$ O# z' I+ m' XDECLARE @count5 INT
DECLARE @test VARCHAR(MAX)
% ?4 F7 g  Z& E9 k% B) WDECLARE @value VARCHAR(MAX)
/ j, Y6 e7 ~3 E$ y* P6 }3 W% vSELECT @count1 = COUNT(mem_id) FROM Students_answer_Polls INNER JOIN Polls ON Polls.poll_id = Students_answer_Polls.poll_id
WHERE Students_answer_Polls.poll_id = @pollid AND Students_answer_Polls.answer = Polls.a1
SELECT @count2 = COUNT(mem_id) FROM Students_answer_Polls INNER JOIN Polls ON Polls.poll_id = Students_answer_Polls.poll_id
WHERE Students_answer_Polls.poll_id = @pollid AND Students_answer_Polls.answer = Polls.a2
SELECT @count3 = COUNT(mem_id) FROM Students_answer_Polls INNER JOIN Polls ON Polls.poll_id = Students_answer_Polls.poll_id
! H2 A- U6 v2 n1 Y, J8 EWHERE Students_answer_Polls.poll_id = @pollid AND Students_answer_Polls.answer = Polls.a3
) @- _2 k1 e& L  v( m/ HSELECT @count4 = COUNT(mem_id) FROM Students_answer_Polls INNER JOIN Polls ON Polls.poll_id = Students_answer_Polls.poll_id
WHERE Students_answer_Polls.poll_id = @pollid AND Students_answer_Polls.answer = Polls.a4
SELECT @count5 = COUNT(mem_id) FROM Students_answer_Polls INNER JOIN Polls ON Polls.poll_id = Students_answer_Polls.poll_id
+ @' R' s5 m$ |* aWHERE Students_answer_Polls.poll_id = @pollid AND Students_answer_Polls.answer = Polls.a5
SELECT @test=Polls.a1 FROM Polls WHERE poll_id = @pollid
IF(@test IS NOT NULL)
BEGIN
PRINT ('Number of students who chose '+@test+' is:'+' '+CAST (@count1 AS VARCHAR(MAX)))
/ B9 Y# I) k, pEND
# s3 ~3 v- |. cSELECT @test=Polls.a2 FROM Polls WHERE poll_id = @pollid
- B" V: R; U# l) r( D7 r8 {# {IF(@test IS NOT NULL)
BEGIN
PRINT ('Number of students who chose '+@test+' is:'+' '+CAST (@count2 AS VARCHAR(MAX)))
+ t5 ?% g! V. I! K; S) V, _END
# W( U( w5 T( B4 p7 ?SELECT @test=Polls.a3 FROM Polls WHERE poll_id = @pollid
IF(@test IS NOT NULL)
BEGIN
' o9 T3 V- y/ _PRINT ('Number of students who chose '+@test+' is:'+' '+CAST (@count3 AS VARCHAR(MAX)))
END
& ~# V1 y( {9 T: ISELECT @test=Polls.a4 FROM Polls WHERE poll_id = @pollid
" N: c+ c  P/ u$ \IF(@test IS NOT NULL)
1 d! M5 \/ {" i7 NBEGIN
PRINT ('Number of students who chose '+@test+' is:'+' '+CAST (@count4 AS VARCHAR(MAX)))
: Z4 V. p. K6 j6 eEND
SELECT @test=Polls.a5 FROM Polls WHERE poll_id = @pollid
* r4 u4 q1 a  X  X) N; Y" r' B& ~IF(@test IS NOT NULL)
$ q3 c  _, g) R( y1 h" n. nBEGIN
  o, c& {/ }+ D% E6 s+ T1 cPRINT ('Number of students who chose '+@test+' is:'+' '+CAST (@count5 AS VARCHAR(MAX)))
END
               
' O6 A) P; l% f解决方案:
+ d, L2 i) q( G               

' ~6 X9 p+ U, P0 K
/ U  z0 U* `+ c                您需要订阅SqlConnection.InfoMessage活动。
( i' E7 x* f. J* B: n. |+ w) WMSDN在这里有一些示例代码。