Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Not sure how to figure this error
Message
 
 
To
All
General information
Forum:
ASP.NET
Category:
Troubleshooting
Title:
Not sure how to figure this error
Environment versions
Environment:
C# 3.0
OS:
Windows XP
Database:
MS SQL Server
Miscellaneous
Thread ID:
01327039
Message ID:
01327039
Views:
50
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
Next
Reply
Map
View

Click here to load this message in the networking platform