连续执行存储过程会出现：为存储过程指定参数过多的问题~~~~ 郁闷

[qq346127416]

我有一个插入数据的窗体 第一个插入没有问题 再插入一条就出现了这个错误 把窗体关了之后再插入也没错误
就是不能连着插入两条~~~~ 求各位大侠怎么解决啊~~~ 谢谢了

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go


-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
create PROCEDURE [dbo].[proc_setfirst] 
	@atype varchar(5),
    @id varchar(500),
    @keyword nvarchar(50),
    @flag int
AS
BEGIN
	SET NOCOUNT ON;
    declare @sql nvarchar(500) 
    if(@atype='add')
        begin
           declare @tempid int 
           select  @tempid = max(id) from FirstKeyWordTable
           set @tempid = @tempid +2
           insert into FirstKeyWordTable(id,keyword,flag) values (@tempid,@keyword,@flag)
        end
    else if(@atype='up')
        begin 
           update FirstKeyWordTable set keyword=@keyword,flag=@flag where id=@id
        end
     else if (@atype='del')
        begin 
          
    
            set @sql ='delete from FirstKeyWordTable where [id] in (' +@id +')'
            exec (@sql)
        end
END

public int AddFirstKeyWordTable(string keyword, string flag)
        {
            SqlParameter patype = new SqlParameter("@atype", SqlDbType.VarChar, 5);
            patype.Value = "add";
            SqlParameter pid = new SqlParameter("@id", SqlDbType.VarChar);
            pid.Value = "1";
            SqlParameter pkeyword = new SqlParameter("@keyword", SqlDbType.NVarChar, 50);
            pkeyword.Value = keyword;
            SqlParameter pflag = new SqlParameter("@flag", SqlDbType.Int);
            pflag.Value = flag;
            SqlParameter[] pars = new SqlParameter[4];
            pars[0] = patype;
            pars[1] = pid;
            pars[2] = pkeyword;
            pars[3] = pflag;
            int i = sqlDB.ExecuteNonQueryByProc("proc_setfirst", pars);
            return i;
        }

[qq346127416]

没人么、、、、、、、、、

[wuyq11]

sqlDB.ExecuteNonQueryByProc中Parameter.Clear

[qq346127416]

可以了 非常感谢~~~

[fusheng112]

我也遇到同样问题了