recordset processing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Carlos - 20 Jul 2005 13:11 GMT

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

Reply to this Message

Eliyahu Goldin - 20 Jul 2005 13:24 GMT

Carlos,

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

Eliyahu

> Hi all,
>
[quoted text clipped - 4 lines]
>
> Carlos

Reply to this Message

Carlos - 20 Jul 2005 14:47 GMT

Thanks Eliyahu,

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

Carlos.

> Carlos,
>
[quoted text clipped - 10 lines]
>>
>> Carlos

Reply to this Message

Eliyahu Goldin - 20 Jul 2005 15:09 GMT

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

> Thanks Eliyahu,
>
[quoted text clipped - 17 lines]
> >>
> >> Carlos

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...