怎么样才能得到返回值？？

[cssin]

这是存储过程
CREATE PROCEDURE ValidateLogin
@Username nvarchar(4),
@Password char(15)
AS
SELECT * FROM UserInfo WHERE 用户名 = @Username AND 口令 = @Password
RETURN @@ROWCOUNT
GO

这是VB中的代码：
With cmdLogin
.CommandType = adCmdStoredProc
.CommandText = "ValidateLogin"
.ActiveConnection = cnLogin
.Parameters.Append .CreateParameter("@RETURN_VALUE", adInteger, adParamReturnValue, , iRtn)
.Parameters.Append .CreateParameter("Username", adWChar, adParamInput, 4, strUsername)
.Parameters.Append .CreateParameter("Password", adChar, adParamInput, 15, strPassword)
Set rsLogin = .Execute
End With

If iRtn = 0 Then
Login = False
Else
Login = True
End If
执行中iRtn得到的值总是0，但实际应该得到返回的行数的啊～～

[cssin]

UP一次

[cssin]

这么下了，
再UP一次.

[water_j]

TRY IT!
CREATE PROCEDURE ValidateLogin
@Username nvarchar(4),
@Password char(15)
AS
SELECT count(*) FROM UserInfo WHERE 用户名 = @Username AND 口令 = @Password
RETURN @@ROWCOUNT
GO

[wangsitao]

CREATE PROCEDURE ValidateLogin
@Username nvarchar(4),
@Password char(15),
@iRet int
AS
set @iRet=SELECT * FROM UserInfo WHERE 用户名 = @Username AND 口令 = @Password
GO




这是VB中的代码：
With cmdLogin
.CommandType = adCmdStoredProc
.CommandText = "ValidateLogin"
.ActiveConnection = cnLogin
.Parameters.Append .CreateParameter("Username", adWChar, adParamInput, 4, strUsername)
.Parameters.Append .CreateParameter("Password", adChar, adParamInput, 15, strPassword)
.Parameters.Append .CreateParameter("iRet", adInteger, adParamOutput, , iRtn)
Set rsLogin = .Execute
End With

试试