Click here to Skip to main content
11,806,575 members (64,228 online)
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 14-Aug-10 23:23pm

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 ppolymorphe 205
1 OriginalGriff 175
2 Richard Deeming 175
3 Sergey Alexandrovich Kryukov 170
4 Abhinav S 120
0 OriginalGriff 3,380
1 Maciej Los 1,990
2 CPallini 1,915
3 KrunalRohit 1,907
4 ppolymorphe 1,317

Advertise | Privacy | Mobile
Web04 | 2.8.151002.1 | Last Updated 15 Aug 2010
Copyright © CodeProject, 1999-2015
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