存储过程:admin_yz
CREATE PROCEDURE [admin_yz]
@name varchar,@mm varchar
AS
IF(Select mm from admin where name= @name )=@mm
RETURN 1
ELSE
RETURN 0
GO
VB客户端:
Myconnection.ConnectionString = "Driver={SQL server};server=FS;uid=sa;pwd=;database=yd"
Myconnection.Open
Set rs1 = New ADODB.Recordset
Set cmd = New ADODB.Command
cmd.ActiveConnection = Myconnection cmd.CommandText = "admin_yz"
cmd.CommandType = adCmdStoredProc
Set param = cmd.CreateParameter("RetVal", adInteger, adParamReturnValue, 4)
cmd.Parameters.Append param
Set param = cmd.CreateParameter("name", adChar, adParamInput, 20, Trim(Text3.Text))
cmd.Parameters.Append param
Set param = cmd.CreateParameter("mm", adChar, adParamInput, 20, Trim(Text2.Text))
cmd.Parameters.Append param Set rs1 = cmd.Execute()
Set rs1 = Nothing
If cmd.Parameters("RetVal").Value = 1 Then
frm_main.Show
Unload Me
Else
MsgBox ("密码错误,请重新输入!!!")
Text2.SetFocus
End If
返回的结果总不是‘1’,既提示 ("密码错误,请重新输入!!!")
但在查询分析器里却可以返回正确的值,真不知道哪里搞错了。
CREATE PROCEDURE [admin_yz]
@name varchar,@mm varchar
AS
IF(Select mm from admin where name= @name )=@mm
RETURN 1
ELSE
RETURN 0
GO
VB客户端:
Myconnection.ConnectionString = "Driver={SQL server};server=FS;uid=sa;pwd=;database=yd"
Myconnection.Open
Set rs1 = New ADODB.Recordset
Set cmd = New ADODB.Command
cmd.ActiveConnection = Myconnection cmd.CommandText = "admin_yz"
cmd.CommandType = adCmdStoredProc
Set param = cmd.CreateParameter("RetVal", adInteger, adParamReturnValue, 4)
cmd.Parameters.Append param
Set param = cmd.CreateParameter("name", adChar, adParamInput, 20, Trim(Text3.Text))
cmd.Parameters.Append param
Set param = cmd.CreateParameter("mm", adChar, adParamInput, 20, Trim(Text2.Text))
cmd.Parameters.Append param Set rs1 = cmd.Execute()
Set rs1 = Nothing
If cmd.Parameters("RetVal").Value = 1 Then
frm_main.Show
Unload Me
Else
MsgBox ("密码错误,请重新输入!!!")
Text2.SetFocus
End If
返回的结果总不是‘1’,既提示 ("密码错误,请重新输入!!!")
但在查询分析器里却可以返回正确的值,真不知道哪里搞错了。
谢谢你,那个问题我已经解决了
我发现了,如果把 adChar换成adInteger,然后把存储过程里的@mm也改成int型的,表里的mm字段也改成int的,就可以了,但我用户名和密码必须用字符型的啊!
帖子地址:http://topic.csdn.net/u/20111003/16/4e724da9-d09b-47d0-ad9a-2d975a0fce33.html,加分