各位大俠怎么樣才能把存儲過程的參數傳到程序中來,謝謝!!

[Hengli]

我的意思是想在存儲過程中返回一個值,在程序中用一變量接收:
以下是我做的:
--存儲過程內容:
Create Procedure MJ_Select_YPM (@Name nvarchar(50) Output) AS
..................

程序部分
dim strName as string
'Comm 是ADODB.Command
Comm.CommandText="MJ_Select_YPM ('" & strName & "')"
comm.execute
為什么這樣做會失敗,請各位老鳥賜招

[DimVar]

Dim ADORs As ADODB.Recordset
Dim ADOCmd As ADODB.Command
Dim ADOPrm As ADODB.Parameter

Set ADOCmd.ActiveConnection = ADOCon

With ADOCmd
.CommandType = adCmdStoredProc
.CommandText = "MJ_Select_YPM"
End With

sParmName = "Name"
Set ADOPrm = ADOCmd.CreateParameter(sParmName, adVarChar, adParamOutput)
ADOCmd.Parameters.Append ADOPrm

Set ADORs = ADOCmd.Execute

Debug.Print "Name: " & ADOCmd.Parameters("Name").Value

[落伍者]

同意楼上的
楼主注意，存储过程的参数类型是output的才可以返回。