473,322 Members | 1,345 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

recordset processing

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
Nov 19 '05 #1
3 996
Carlos,

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

Eliyahu

"Carlos" <ch******@yahoo.com> wrote in message
news:uj**************@TK2MSFTNGP09.phx.gbl...
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

Nov 19 '05 #2

Thanks Eliyahu,

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

Carlos.

"Eliyahu Goldin" <re*************@monarchmed.com> wrote in message
news:e5**************@TK2MSFTNGP14.phx.gbl...
Carlos,

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

Eliyahu

"Carlos" <ch******@yahoo.com> wrote in message
news:uj**************@TK2MSFTNGP09.phx.gbl...
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


Nov 19 '05 #3
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

"Carlos" <ch******@yahoo.com> wrote in message
news:es*************@tk2msftngp13.phx.gbl...

Thanks Eliyahu,

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

Carlos.

"Eliyahu Goldin" <re*************@monarchmed.com> wrote in message
news:e5**************@TK2MSFTNGP14.phx.gbl...
Carlos,

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

Eliyahu

"Carlos" <ch******@yahoo.com> wrote in message
news:uj**************@TK2MSFTNGP09.phx.gbl...
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



Nov 19 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Agoston Bejo | last post by:
I would like to use an ADODB.RecordSet object to temporarily store some data and then iterate through it. Actually it needs to be a RecordSet only because it is a perfect choice as data structure...
1
by: Jason Chan | last post by:
I am writing a function to take a recordset as parameter, and print a HTML Select element according to the record in the recordset. I would like to check if the input object a RecordSet before...
27
by: Oscar | last post by:
I am looking for a way to pass an ADO recordset that has been retrieved in an ASP page to another HTML-page. Is there someone who can provide me with a small sample or a link to see how this is...
3
by: Nathan Bloomfield | last post by:
Hi there, I am having difficulty with a piece of code which would work wonders for my application if only the error trapping worked properly. Basically, it works as follows: - adds records...
8
by: Tom | last post by:
I have the following code structure (abbreviated) Do Until RstA.EOF Do Until RstB.EOF RstB.MoveNext Loop RstA.MoveNext Loop
6
by: James | last post by:
I am writing a web service for a classic ASP application. I need to consume an ADO recordset and then send it to another web service for processing. I found an MSDN ariticle telling how to do this...
10
by: Roger Withnell | last post by:
I'm using ASP, VBScript and SQL Server. I'm also using UTF-8 character set and so my codepage is 65001 and SQL Server datatype nvarchar. I can insert unicode characters correctly into the...
5
by: Henrik | last post by:
The problem is (using MS Access 2003) I am unable to retrieve long strings (255 chars) from calculated fields through a recordset. The data takes the trip in three phases: 1. A custom public...
4
MMcCarthy
by: MMcCarthy | last post by:
The following code is simply an example of some code that processes through two recordsets. It can be helpful for anyone curious as to how to start processing with recordsets (Which objects to refer...
4
by: Bob | last post by:
Hi all, I'm trying to import data, modify the data then insert it into a new table. The code below works fine for it but it takes a really long time for 15,000 odd records. Is there a way I...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.