Dim adoCmd As ADODB.Command Dim adoCn As ADODB.Connection Dim parIn As ADODB.Parameter Dim parOut As ADODB.ParameterSet adoCn = New ADODB.ConnectionWith adoCn .CursorLocation = adUseClient .Open "Provider=SQLOLEDB;Server=" + ServerName + ";Database=myinvoice;Uid=" + ServerID + ";Pwd=" + ServerPassword + ";" End WithSet adoCmd = New ADODB.Command adoCmd.ActiveConnection = adoCn adoCmd.CommandType = adCmdStoredProc adoCmd.CommandText = "存储过程名称" Set parIn = adoCmd.CreateParameter(名称, 类型, adParamInput, 长度, 值) adoCmd.Parameters.Append parIn '输入参数用 adParamOutput Set parOut = adoCmd.CreateParameter("输出参数", 类型, adParamOutput, 长度, 值) adoCmd.Parameters.Append parOut adoCmd.Execute MsgBox adoCmd.Parameters("输出参数"), vbInformation adoCn.Close
Dim adoCn As ADODB.Connection
Dim parIn As ADODB.Parameter
Dim parOut As ADODB.ParameterSet adoCn = New ADODB.ConnectionWith adoCn
.CursorLocation = adUseClient
.Open "Provider=SQLOLEDB;Server=" + ServerName + ";Database=myinvoice;Uid=" + ServerID + ";Pwd=" + ServerPassword + ";"
End WithSet adoCmd = New ADODB.Command
adoCmd.ActiveConnection = adoCn
adoCmd.CommandType = adCmdStoredProc
adoCmd.CommandText = "存储过程名称"
Set parIn = adoCmd.CreateParameter(名称, 类型, adParamInput, 长度, 值)
adoCmd.Parameters.Append parIn
'输入参数用 adParamOutput
Set parOut = adoCmd.CreateParameter("输出参数", 类型, adParamOutput, 长度, 值)
adoCmd.Parameters.Append parOut
adoCmd.Execute
MsgBox adoCmd.Parameters("输出参数"), vbInformation
adoCn.Close
这些值,应该怎么设置?