Procedure expects parameter which was not supplied

In addition to the other answers here, if you’ve forgotten to put:

cmd.CommandType = CommandType.StoredProcedure;

Then you will also get this error.