Problem in update record

Question

0.00/5 (No votes)

See more:

hello frds,

i have 2 table 1st Order and 2nd OrderProduct. both have PK and FK with OrderID relationship. now i want to update some field OrderProduct table but when i try to update that Amout Field nad NetAmount Field its give error. i m doing that using linq to Sql in asp dotnet.
here is error :
Value of member 'ID' of an object of type 'OrdersProduct' changed.

please help me.........

Thank To all in advance

Posted 18-May-12 3:31am

Yatin_Chauhan

Updated 18-May-12 3:32am

v2

Add a Solution

Comments

Mohamed Mitwalli 18-May-12 9:36am

Share your code

Prasad_Kulkarni 18-May-12 9:38am

Post some code snippet Yatin

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

SASS_Shooter · Answer 1 · 2012-05-18T05:41:00

The error you are getting is the result of modifying the key to the record.
You need to check your code and remove anything that will change the key. For example: if your code does something like this:

C#

OrdersProduct currentProduct = {populate from database};

...

currentProduct = modifiedProduct;

That is bad -- especially if you are letting your user get access to the key field and modifying it!!!

Also make certain you're not modifying the field 'ID' anywhere yourself!