Finally solved-the problem that the Stored Procedure Call prompts a large number of parameters to be passed!

When calling a stored procedure, it always says that there are too many parameters to be passed. On csdn, the problem is not solved. It is always depressing ..

Today, I am not depressed, because I have solved this problem. The solution is too many parameters. I just want to reduce the number of parameters. The details are as follows:

Sqlcommand cmd;

...

...

...

Cmd. Parameters. Clear (); // clear the previous parameters. This error occurs if I didn't do this at the beginning.

Add the required parameters.

Summary:

The program is not careful enough, so pay more attention to it later.