ASP.NET Dynamic Data

Re: Wrong value on update

sjnaughton — Wed, 01 Jul 2009 12:36:11 GMT

If it's a ForiegnKey field I would check the ExtractValue method of the ForeignKey_Edit.aspx.cs and see what value it has when you put a break point in there.

You can a a break point with a condition i.e. Column.Name == "MyColumn" and then it will only breal on that column if you have several in that table.

Re: Wrong value on update

stevew1975 — Wed, 01 Jul 2009 11:38:30 GMT

What happens when you do an update or anything that posts back, is that the page_load is run before your update code.

I was just checking to see if there is anything in your page_load which is updating the information before hitting your update code.

Re: Wrong value on update

michaelr524 — Wed, 01 Jul 2009 11:00:03 GMT

Hey Steve,

Can you explain please, I didn't really understand your answer.

The original value is loaded automaticly then I edit a row and then I update and get this:

Microsoft JScript runtime error: Sys.WebForms.PageRequestManagerServerErrorException: The UPDATE statement conflicted with the FOREIGN KEY constraint "FK_Readiness_ActivitiesHistory_Readiness_ActivitiyStatusFactorDef". The conflict occurred in database "ReportsEden", table "dbo.Readiness_ActivitiyStatusFactorDef".

The statement has been terminated.

Microsoft JScript runtime error: Sys.WebForms.PageRequestManagerServerErrorException: The UPDATE statement conflicted with the FOREIGN KEY constraint

I inspected the values sent from the page using FireBug and then I inspected the values before they are being sent to the database and they are not the same.

Thanks

Michael

Re: Wrong value on update

stevew1975 — Wed, 01 Jul 2009 10:33:31 GMT

Check you page load, are you updating it with the original value here. If so you may need the !IsPostback check.

Wrong value on update

michaelr524 — Wed, 01 Jul 2009 09:53:01 GMT

Hey people,

Here is a strange problem. I've created a DD Linq2Sql website.

When editing and then updating a row one of the foreign fields is wrong on update

and causes an error in SQL. I don't understand where does it take it's value from.

The value which is sent through AJAX from the select box is right, but when I put a break point in the update method I could see the value is wrong there.

partial void UpdateReadiness_ActivitiesHistory(Readiness_ActivitiesHistory instance)

{

// here I set the breakpoint and inspected 'instance'

ExecuteDynamicUpdate(instance);

}

Has anyone had any experience of this kind?

Please help.

Thanks

Michael

partial void UpdateReadiness_ActivitiesHistory(Readiness_ActivitiesHistory instance)

{

ExecuteDynamicUpdate(instance);

}