SqlParameterCollection parameter problem

kiraasuha

Adding a parameter a to a sqlcommand, adding a to another command gives the following error:

An unhandled "System.ArgumentException" type exception appears in system.data.dll.

Additional information: Another SqlParameterCollection already contains a SqlParameter with ParameterName "@a".



I want to add the same parameter to multiple commands.

trampzz

The specific code posted may be a problem with the sqlCommand definition.

wangsupe

I have encountered the same problem, such as: a parameter is called in more than two places.

柠檬在线

If several parameter values ​​are the same, define it once.
If it is different, add a sentence sql_command.Parameters.Clear () after running sqlcommand each time.