存储过程中有输入参数和输入参数，在asp里面该怎样表示呢？

[liaogs]

rs.open "存储过程，参数1,参数2,参数3",conn,1,1
输出参数怎么办呢？谢谢！

[KnowLittle]

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

[yigenhuochai]

KnowLittle(人傻不要紧，只要肯学习。)　兄的方式比较好

[wdfboy1978]

什么意思？请写清楚。

[liaogs]

rs.open "存储过程名，参数1,参数2,参数3",conn,1,1
输出参数怎么办呢？谢谢！

[ttt2]

使用 command对象