28,406
社区成员
发帖
与我相关
我的任务
分享存储过程中有输入参数和输入参数，在asp里面该怎样表示呢？
rs.open "存储过程，参数1,参数2,参数3",conn,1,1
输出参数怎么办呢？谢谢！
...全文
请发表友善的回复…
发表回复
ttt2 2002-01-14
- 打赏
- 举报
使用 command对象
liaogs 2002-01-14
- 打赏
- 举报
rs.open "存储过程名，参数1,参数2,参数3",conn,1,1
输出参数怎么办呢？谢谢！
输出参数怎么办呢？谢谢！
wdfboy1978 2002-01-14
- 打赏
- 举报
什么意思？请写清楚。
yigenhuochai 2002-01-14
- 打赏
- 举报
KnowLittle(人傻不要紧，只要肯学习。) 兄的方式比较好
KnowLittle 2002-01-14
- 打赏
- 举报
Dim cmdExec
Dim con
Dim rs
Set cmdExec = Server.CreateObject("ADODB.Command")
cmdExec.CommandType = adCmdStoredProc
set con = ConnectDatabase()
cmdExec.ActiveConnection = con
cmdExec.Parameters.Append cmdExec.CreateParameter("",adInteger,adParamInput ,,Session("LoginCompanyId"))
cmdExec.Parameters.Append cmdExec.CreateParameter("",adVarWChar,adParamInput ,50,Session("LoginName"))
cmdExec.Parameters.Append cmdExec.CreateParameter("",adVarWChar,adParamInput ,20,ReportType)
cmdExec.Parameters.Append cmdExec.CreateParameter("",adVarWChar,adParamInput ,100,Name)
cmdExec.CommandText = "sp_AddReport"
set rs = cmdExec.Execute
AddReport = rs(0)
rs.close
Dim con
Dim rs
Set cmdExec = Server.CreateObject("ADODB.Command")
cmdExec.CommandType = adCmdStoredProc
set con = ConnectDatabase()
cmdExec.ActiveConnection = con
cmdExec.Parameters.Append cmdExec.CreateParameter("",adInteger,adParamInput ,,Session("LoginCompanyId"))
cmdExec.Parameters.Append cmdExec.CreateParameter("",adVarWChar,adParamInput ,50,Session("LoginName"))
cmdExec.Parameters.Append cmdExec.CreateParameter("",adVarWChar,adParamInput ,20,ReportType)
cmdExec.Parameters.Append cmdExec.CreateParameter("",adVarWChar,adParamInput ,100,Name)
cmdExec.CommandText = "sp_AddReport"
set rs = cmdExec.Execute
AddReport = rs(0)
rs.close
