Click here to Skip to main content
12,951,732 members (65,001 online)
Rate this:
Please Sign up or sign in to vote.
See more:

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
Top Experts
Last 24hrsThis month
OriginalGriff 6,239
CHill60 3,490
Maciej Los 3,083
Jochen Arndt 1,975
ppolymorphe 1,880

Advertise | Privacy | Mobile
Web01 | 2.8.170525.1 | Last Updated 15 Aug 2010
Copyright © CodeProject, 1999-2017
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