recordset processing

[Carlos]

Hi all,

I am new to asp .net, and now I need to access a database,
and accumulate totals according to values that I find on each row
with a given condition. Can anybody show me a code snipet addressing
such task ? Thanks in advance.

Carlos

 

[Eliyahu Goldin]

Carlos,

Do you need to show the rows or just to get totals?

Eliyahu

 

[Carlos]

Thanks Eliyahu,

I just need to accumulate totals from a particular field without showing
data.

Carlos.

 

[Eliyahu Goldin]

Then it is a sql task. Write a query using sql aggregate functions and debug
it with a utility that runs queries against your database.

If for whatever reason you still need to do it in the code, use database
access components connection, command and reader. You can find plenty of
examples in MSDN.

Eliyahu