存储过程如下:
DE PE TEMP @ID INT AS
SELECT * FROM TEMPTABLE
WHERE ID=ID
GO就一个参数,ID,整型的.
如何在VB中调用并将其结果给某个记录集?
DE PE TEMP @ID INT AS
SELECT * FROM TEMPTABLE
WHERE ID=ID
GO就一个参数,ID,整型的.
如何在VB中调用并将其结果给某个记录集?
解决方案 »
- 如何在Richtextbox中象WORD一样,显示、复制、删除回车
- 关于监控剪贴板的问题
- sfilename = Appbbb_.Path & "\" & CStr(sfilename) & ".xls"生成exe竟然没报错,只是在运行exe后才说运行时错误424 需要对象
- 如何实现C/S三层的中间层?
- 查询在新窗口不刷新,怎样让他刷新呢??
- 俺是初学者,求救!读写文件
- 求助如何解决:键列信息不足或不正确,更新影响到多行
- 如何用ADO更新sybase数据库
- 怎样可以知道Win下的"记事本"中的光标前的字符呢??????????????
- 谁有写好的进销存系统,最好是Access的!(有报酬!)
- 为什么一个API程序会引起软件这样的反应,期待如何解决?
- 用ODBC建立完数据库后,不能用。
Rec.open "exec TEMP " & id,conn
@UserID varchar(4),
@ObjID varchar(4)
AS
SELECT UserID,ObjID,Auth
FROM tAuth
WHERE tAuth.UserID = @UserID
AND tAuth.ObjID = @ObjID
GOPrivate Sub Command1_Click()
Dim conn As New Connection
Dim cmd As New Command
Dim rs As New Recordset
conn.ConnectionString = "..."
conn.Open
Set cmd.ActiveConnection = conn
cmd.CommandType = adCmdStoredProc
cmd.CommandText = "spGetAuth"
cmd.Parameters("@UserID").Value = "0000"
cmd.Parameters("@ObjID").Value = "Root"
rs.Open cmd, , adOpenDynamic, adLockReadOnly
End Sub
如:
该存储过程只有一句:delete from temptableDim conn As New Connection
conn.execute 存储过程名
这样调用行吗
如果有参数
则:
conn.execute "sp_Your @Para1=" & paraValue & ",..."
Dim cmd As New Command程序结束时,用不用像rs.close :set rs=nothing这样,在内存中消除它,如:
set cmd=nothing
@dwbh CHAR(7),
@S1 CHAR(7) OUTPUT
AS
private sub refreshlist()
dim rs as recordset
set rs=mconn.execute("test",,adcmdstoredproc)
txt.text=rs("s1")
end sub
程序结束时,内存中消除它,如:
set cmd=nothing