Prepared Statements and the “Parameter X has no default value” error
Posted January 27th, 2010 by WesleyWhen I stumbled upon this error “parameter @columnName has no default value”, first thing I tried was Google, of course. When googling, I found lots of answers for this problem, but they all resulted in the following solutions:
Parameter name is different in the query and when declaring the parameter (wrong columnName, or wrong parameter assigned [...]
Tags: ado.net, DbCommand, nullable, OleDbCommand, prepared statement