'Procedure or function has too many arguments specified

[mrp9090]

I am using a SqlDataSource with a GridView and stored proc, and I have specified exactly the same update parameters for the SqlDataSource in exactly the same order as my stored proc. Yet I keep getting the error 'Procedure or function <stored procedure name> has too many arguments specified'. Has anybody else come across this, and if so how do you prevent this annoying error?

 

[vbkris]

hmm, tihs could happen when the parameters that u send and the parameters of the SP dont match (this is an inbuilt feature of Enterprise Library)...

Known is handfull, Unknown is worldfull

 

[ca8msm]

There must be more arguments being passed to your SP than it is expecting. This may be down to something that is being generated from the SqlDataSource or by some manual parameters that you have added - either way, you'll have to look at which parameter's are being passed and work it out from there.


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[mrp9090]

The only thing that I could think of was that I am not explicitly passing the DataKey field to the stored proc, and maybe it is getting passed automatically without me knowing. But I have tried to explicitly pass it and it still gives me the same error.

 

[vbkris]

>> that I am not explicitly passing the DataKey field to the stored proc

DataKey field? could u clarify a bit???

Known is handfull, Unknown is worldfull

 

[jbenson001]

How about showing the pramaters for your SP, and the sql data source code.

 

[mrp9090]

I meant that I was setting DataKeyNames in my GridView that is linked to the SqlDataSource.