Bulk Calculation
-
I have data in a SqlServer table and I want to Select the data into a gridview or something like that and perform a calculation on the data. I want to have a button that will carry out a calulation on all the records displayed and save the total for each record after the calculation to a field in the DB table containing the records. Anyone any ideas on best way to do this?
-
I have data in a SqlServer table and I want to Select the data into a gridview or something like that and perform a calculation on the data. I want to have a button that will carry out a calulation on all the records displayed and save the total for each record after the calculation to a field in the DB table containing the records. Anyone any ideas on best way to do this?
There is any reason NOT to do the calculations inside SQL? SQL is pretty good with calculations...
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
-
There is any reason NOT to do the calculations inside SQL? SQL is pretty good with calculations...
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
-
I have data in a SqlServer table and I want to Select the data into a gridview or something like that and perform a calculation on the data. I want to have a button that will carry out a calulation on all the records displayed and save the total for each record after the calculation to a field in the DB table containing the records. Anyone any ideas on best way to do this?
macca24 wrote:
Anyone any ideas on best way to do this?
In the button click, call a stored procedure that does the calculation and updates the data and then refresh your grid.
There are only 10 types of people in the world, those who understand binary and those who don't.
