過程如下﹕
CREATE PROCEDURE spUserLogin
@UserID char(4),@UserName char(50),@LoginSucc bit output
As
declare @procError int
if exists(select UserID from tblUser where UserID=@UserID and UserName=@UserName)
begin
set @LoginSucc=1
end
else
begin
set @LoginSucc=0
end
GO
在FORM中調用過程并取過程中@LoginSucc的值﹐應該如何編寫代碼比較簡單(最好用對象﹐當然用adodc控件)﹐謝謝。
CREATE PROCEDURE spUserLogin
@UserID char(4),@UserName char(50),@LoginSucc bit output
As
declare @procError int
if exists(select UserID from tblUser where UserID=@UserID and UserName=@UserName)
begin
set @LoginSucc=1
end
else
begin
set @LoginSucc=0
end
GO
在FORM中調用過程并取過程中@LoginSucc的值﹐應該如何編寫代碼比較簡單(最好用對象﹐當然用adodc控件)﹐謝謝。
解决方案 »
- vb与access2003连接程序
- 系列专题:【附源码】Windows Shell接口之VB实现(一):ICopyHook接口
- VB控制网页赋值问题
- Vsprinter的奇怪疑难问题!谁能解决!
- 我想做一个东东(很简单的~!)帮我一下
- 如何是图片框里的图片呈半透明
- & 请推荐vb开发过程中 最好的报表制作工具 &
- 救命!那位高手知道,怎样查看office文档?
- MSCOMM控件发送文件,只用MSComm1.Output = "teststr"就可以了吗?
- 随机读取文件,错误在哪里????(
- 如何保存Image物件? 注意﹕Image物件并不是一個文件。高分相送!!!在線恭候!!!
- Tabstricp控件小问题
Dim LoginSucc As intger
Dim rs As ADODB.Recordset
Dim comm As New ADODB.Command
On Error GoTo err
comm.ActiveConnection = conn
comm.CommandType = adCmdStoredProc
comm.CommandText = "spUserLogin "
conn.CursorLocation = adUseClient
Set param = comm.CreateParameter("@UserID ", adInteger, adParamInput, 4, UserID )
comm.Parameters.Append param
Set param = comm.CreateParameter("@UserName ", adVarChar, adParamInput, 50, UserName )
comm.Parameters.Append param
Set param = comm.CreateParameter("@LoginSucc ", adTinyInt, adParamOutput, 1)
comm.Parameters.Append param
Set rs = comm.Execute
LoginSucc= comm.Parameters("@LoginSucc").Value
err:
Call DisplayERR
End Function
dim cn as string
Set com = New ADODB.Command
cn=""'连接字符串
com.ActiveConnection = CN
com.CommandText = "spUserLogin "
com.CommandType = adCmdStoredProc com.Parameters("@UserID") = "bbb"
com.Parameters("@UserName") ="bbb"
text1.text=com.Parameters("@LoginSucc")
Dim prmStr As Parameter
Set comStr = New ADODB.Command
comStr.CommandType = adCmdStoredProc
comStr.CommandText = "spUserLogin"
Set prmStr = comStr.CreateParameter("", , adParamOutput)
comStr.Parameters.Append prmStr
comStr.Execute