The reason I was asking is because when you do an update using the AJAX ToolKit ReOrder list it uses reflection on the DataTable created in the select method to generate the update parameters instead of the parameters specified in the Update method you specify on your SqlDataSource. So your update method has to have all the fields in your select method as parameters. Sounded like you were having a similar issue.

>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.