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);

    }

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

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 

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

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.

 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.