Hi everybody,
I'm getting this error
---------------------------------------------------------------------------------
Server Error in '/FCAdmin' Application.
--------------------------------------------------------------------------------
@Father is not a parameter for procedure PersonUpdate.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: @Father is not a parameter for procedure PersonUpdate.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException (0x80131904): @Father is not a parameter for procedure PersonUpdate.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +925466
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800118
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186
etc.
------------------------------
My SP has FatherID and MotherID as update parameters, not Father or Mother. I already tested this SP in SSMS, it works fine.
In my ASPX I don't have Father or Mother as UpdateParameters either (only FatherID and MotherID). However, I get Father & Mother (as first name + last name) as part of the select and bind a textbox text to it.
Do you know what the problem here is?
Of course, I can add these two extra parameters to my SP to prevent this error, but why does it try to send them as Update Parameters?
Thanks in advance.
If it's not broken, fix it until it is.
My Blog