FormView - After update goes to wrong record
Posted on 2006-07-21
I've run into this problem a few times, I update something in the FormView that is in the Order By clause of the SQL in the SqlDataAdapter, thus changing the order of the rows. Then the form view goes to ReadOnly mode at the same index as before the edit, but the record displayed is now whatever is in that spot after the order changed.
Any way to force it to go to the record with the same datakeyname after update?