VB连接数据库执行存储过程出现“为过程或函数 指定了过多的参数”

来源:百度知道 编辑:UC知道 时间:2024/05/23 23:08:28
存储过程:
ALTER procedure [dbo].[feng]
(@issue int,@num int output)
as
select @num=count(buy_number.issue)from buy_number ,elicit_number
where(
@issue=buy_number.issue
And buy_number.first = elicit_number.first
and buy_number.second=elicit_number.second
and buy_number.third=elicit_number.third)
代码段:
Me.sqlconnection1.ConnectionString = "Server=(local);Database=choujiang;User id=aaa;Pwd=aaa"
sqlcmd.Connection = Me.sqlconnection1
sqlcmd.CommandType = CommandType.Text
sqlcmd.CommandText = "dbo.feng"
sqlcmd.CommandType = CommandType.StoredProcedure
Dim num As SqlParameter = sqlcmd.Parameters.Add("@num", SqlDbType.Int)
Dim issue As SqlParameter = sqlcmd.Parameters.Add("@issue", SqlDbType.Int)
num.Direction = ParameterDirection.Output
issue.Direction = ParameterDirection.Input
issue.

select @num=count(buy_number.issue)from buy_number ,elicit_number
where(
@issue=buy_number.issue
And buy_number.first = elicit_number.first
and buy_number.second=elicit_number.second
and buy_number.third=elicit_number.third)

buy_number.issue = @issue

错误定位在哪行?

执行该过程只需要输入一个参数,有一个是输出的参数,@num int output