OleDbCommand调用select and update 语句stored procedure,update返回执行结果.

OleDbCommand调用select and update 语句stored procedure,update返回执行结果.

---------------------------------------------------------------------
AY5R]9V9t#x0stored procedure:ITPUB个人空间? mI+A,[{']
CREATE Proc dbo.XX
;o/z1_F/RK~%a!da0(ITPUB个人空间5H(~TkbR
 @uniqueTransId varchar(10),ITPUB个人空间3`a9`@'Z,h1iL
 @numDaysAdded int,
6r0Dp(Y@1G3T0 @orgId int,
R7F M$p:o%E'Ri0 @fundId int
4OUQ
lSPms0)
#U`!z2q4h3G0ASITPUB个人空间n%Kr2Q.QV7}9`*X-U
set nocount  on

begin  

 update tbl_Transaction
qRb/]"[ Q~0 set CurEFTId = @uniqueTransId ,DateUpdated=getdate()ITPUB个人空间
jy1iry0h/Z
 where TransactionStatusId = 44 and ScheduledProcessDate <= getDate() + @numDaysAdded
sP-j`],ma0 and TransactionTypeId = 144 and IsFeeReversal = 4 and CurEFTId is null and rganizationId = @orgId AND FundId = @fundId

 select Id, FundEntryId, GroupId from tbl_Transaction where CurEFTId  =  @uniqueTransId

ITPUB个人空间)I7L~] J
endITPUB个人空间}'AC:q(X*Tr
GOITPUB个人空间%G/U~Na
p8A+d+Q/Kw
------------------------------------------------------ITPUB个人空间oDv'I+MH3JP*j*Z\
C#ITPUB个人空间!K%_6uX:Pl
DataSet tsd = new DataSet();ITPUB个人空间T'A`5I3gV|
adptrT.Fill(tsd, "Ta");
-J RsMl0-------------------------------------------------------
F/k5C X:g fu*\k0tsd中应该只有select的结果集,但实际中update操作结果也被返回在DS中.ITPUB个人空间G)cK$v-A_a]-]!L
好个调查...原因为tbl_Transaction trigger中有一句select...导致DS中返回两个Table