Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Not sure how to figure this error
Message
General information
Forum:
ASP.NET
Category:
Troubleshooting
Environment versions
Environment:
C# 3.0
OS:
Windows XP
Database:
MS SQL Server
Miscellaneous
Thread ID:
01327039
Message ID:
01327065
Views:
11
Not sure what you're asking me. I added these 2 parameters to SP and at least it works now. Have no idea where these parameters were coming from.

>Is this on a AJAX Toolkit ReOrder List?
>
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform