Click here to Skip to main content
Rate this: bad
Please Sign up or sign in to vote.
See more: SQL LINQ
the PriceUpdation.aspx page has a Textbox and a button
and in database i have a table having two Fields
1) Product Price
2) Final Product Price
on the click of button --- THE percentage % we will enter in that textbox like 15% it will callculate the 15% of Product Price and add that calcluted % to the Final Product Price ..
All This i have to do with LINQ
Can i update two coloumns by LINQ ... my table has 23 Fields .. ??

ANS asap ======================= Thanks alot for replying
Posted 15-Aug-10 0:23am

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Yes you can. You get the object from the database context set the properties, then call SubmitChanges on the context object to submit the changes. Scott Gu has a good article on this
Using LINQ to SQL (Part1)[^]

You are storing calculated fields, it might be better to store the percentage and re-calculate the two properties you have above. This depends upon the nature of your application of course!

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

  Print Answers RSS
0 OriginalGriff 5,170
1 DamithSL 4,357
2 Maciej Los 3,750
3 Kornfeld Eliyahu Peter 3,470
4 Sergey Alexandrovich Kryukov 2,851

Advertise | Privacy | Mobile
Web02 | 2.8.141216.1 | Last Updated 15 Aug 2010
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100