I have data in a SqlServer table and I have an asp.net front-end. I am selecting the data into a form in asp.net and I am clicking a button to perform a calculation on the data. There are maybe 300 records and I want the same calculation performed on each record I have selected. The calulation will take the form of adding the value in two fields in the record and then multiplying that amount by 1.23.
Anyone any ideas on best way to do this?