Why would every parameter exist in the New/Old Value arguments except the "salesprice" parameter? I've tried populating the textbox without the formatstring, and it's still missing. Form View Update Event Args) Handles fv Loan Details. The stored procedure on the backend takes care of this, and these are not parameters for the Update method.
Lasty, the select query of the object datasource is a stored procedure that performs several joins based on PF/FK relationships to bring back more meaningful information than just a FK, so some columns are just the joined value, and can not be updated directly.
Again, formview is trying to pass these parameters So given that, I have defined the following even handler for a simple form view: (not sure if this is the way to proceed given the above, but...) protected void Form View1_Item Updating(object sender, Form View Update Event Args e) My questions are as follows: 1) Is this the right approach?
So I have a formview that displays information from the database and allows editing of it. When all you've got is a Hammer, Every Problem looks like a Nail.
If a user decides to edit the formview, I want to get the changes made to the content, the users member ID and the Date Time of when it happened.
Probably something to do with my idiotic approach, but not sure. OK, playing around I realized that EVAL should be used instead of Bind, so that takes care of the extra field being passed back.
thanks in advance for any advice or help you can offer However, when I leave the Form View to it's own devices it is still trying to pass all the parameters back, regarless of what the object datasource it asking for. So now myevent looks like this (much simplier, thanks) protected void Form View1_Item Updating(object sender, Form View Update Event Args e) However, the update is returning from this, in your ODS setup: Old Values Parameter Format String="original_" you probably chose concurrency options in the wizard.
The data DOES pull in to the textbox as it should, formatted properly and all.
I've attached the html, SQL (for get Loan Data()), and the codebehind.
2) Is so, when I cancel the edit (because I did the update myself), and change mode, the Form View returns to read only mode as inteneded (good so far).
However, when I hit F5 (refresh), the Item Updating method is called again, and updates the database.
Then I will get an runtime exception from the BLL that no matching function has input parameters .....(Project ID, ......., Last Updated By, ....