Author: serendipideist | Posted on: 9/23/2008 10:18:27 AM | Views : 1443

I have a FormView bound to an ObjectDataSource. After submitting the form, if the SQL query fails for some reason, the form should NOT rebind.  However, anytime an update or insert command is executed, the formview rebinds with the original values, and the user loses the new form values entered. 

 How do you stop it from rebinding?

 Note that the select method takes a single parameter (the page's "AreaId" property), which does not change from the moment the submit button is pressed to the time it reloads.  In other words, since the parameter value has not changed, I don't see what could be causing it to execute the select method. I only change the AreaId value if it's successful:

  Private Sub ods_Areas_Updated(ByVal sender As Object, ByVal e As Syst ...

Go to the complete details ...