Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Not sure how to figure this error
Message
Information générale
Forum:
ASP.NET
Catégorie:
Problèmes
Versions des environnements
Environment:
C# 3.0
OS:
Windows XP
Database:
MS SQL Server
Divers
Thread ID:
01327039
Message ID:
01327065
Vues:
12
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform