No value given for one or more required parameters. (ADO Error)

There are many reasons for this error:

1. Parameter name not spelt correctly
2. Case is not correct in parameter (firstname instead of FirstName )
3. Passing incorrect type, for example, numeric instead of string - pass the string within quote