储存过程如何返回output参数啊?????
xiyun 2003-03-31 12:48:45 过程如下:
ALTER PROCEDURE CheckUserLogon
@UserName varchar(10),
@Password varchar(10),
@CheckResult tinyint output
as
DECLARE @CorrectPassword VARCHAR(10)
SELECT @CorrectPassword=Passwd FROM KeyList WHERE UserID=@UserName
IF(@@RowCount<>1)
BEGIN
SET @CheckResult=0
RETURN @CheckResult
END
ELSE
IF(@CorrectPassword<>@Password)
BEGIN
SET @CheckResult=0
RETURN @CheckResult
END
ELSE
BEGIN
SET @CheckResult=1
RETURN @CheckResult
END
请问,我该怎么在vb.net中得到返回结果呢?
这样可以么?
Dim passresult As Byte
Me.SqlConnection1.Open()
Me.SqlCommand1.ExecuteNonQuery()
passresult = Me.SqlCommand1.Parameters.Item(2).Value
Me.SqlConnection1.Close()
谢谢赐教啊!!!