calculations using data extracted from a database

Morrislgn · March 22nd, 2004, 03:28 PM

hi,

i have a problem which i could use guidance to solve, please?!

i would like to extract a series of values from a database and then multiply them individual figures which are put into the system by users.

At the moment, I can extract the figures i want from the database by using the SQL query:

Select Values
From table
Where ((Value_ID = '1') OR (Value_ID='2') Or (Value_ID='3') Or (Value_ID='4') Or (Value_ID='5'));

this query should return the values of 10, 9, 8, 7, 6.

Is it possible to extract these values from the database and multiply them like so:

database values x user input
10 x 20
9 x 30
8 x 40
7 x 50
6 x 60

I am not to sure how to approach this problem. Any ideas or sample code where this has been done before would be great

Thanks

Morris

bmains · March 22nd, 2004, 03:46 PM

You could use ADO.NET to multiply the values then post the results back through an update statement using the SQL data adapter. You could also handle this in the database

update Table set Value = Value X Multiplier where Value_ID in ('1', etc).

What database are you using?

Morrislgn · March 22nd, 2004, 05:25 PM

hi,

i am using access 2002.

the thing s, i dont want to store the results back in the database - I want to leave the data unchanged while displaying the results of the calculations to the user via a web form of some type.

thanks for your help

Morris

bmains · March 22nd, 2004, 07:37 PM

In ADO.NET, you could create a custom data column that stores this field. That may be what you want to do. Add a DataColumn to your DataSet's table, and store the calculation there. Then use a control to do the data binding, which this value will be present.

Does that sound on the right track?

Andy Hodges · March 29th, 2004, 09:04 AM

If you are using .Net why not bind the data to a datagrid and then us Container.DataItem("Value") to return the value of the field from your database to the page and then do the calculation on the page?

Andy Hodges

Morrislgn · April 1st, 2004, 03:19 PM

Hi folks, sorry for taking so long to get back to you - very sorry.

Thanks for your suggestions - they were much appreciated. I think I have this problem solved, maybe, hopefully... ill get back to you on your suggestions if it turns out that my work is not right! At this point, anyone who read any of my previous posts will know that tomorrow morning ill probably be back begging for help!!

Thanks again,

Morris