ASP.net Looping through a Collection of Dates

[Mick Walker]

I have a collection of objects populated from a SQL Server (sorted
descending). Each of these object has a date field.

I need a way to loop through these object starting from the newest
entry, and finishing at the last, and output them in the format:

June 2007
Item
Item
Item
May 2007
Item
Item
....
....
....
....
December 2006
Item
Item
..... and so on.

I have no idea how to achieve this, so if someone could help me that
would be great.

[Spam Catcher]

Mick Walker <Mi*********@privacy.netwrote in news:5djhv5F34s3l4U1
@mid.individual.net:

I have a collection of objects populated from a SQL Server (sorted
descending). Each of these object has a date field.

I need a way to loop through these object starting from the newest
entry, and finishing at the last, and output them in the format:

In your SQL statement, sort the list by date. Then use a datareader (or
dataset) to output the data.

[Cor Ligthert [MVP]]

Mick,

Probably I would try to get the Top 1 record, using the Execute Scalar,
order the table by the DateTime and where the date is than the previous
date.

Avoiding to give you the fish but help you to learn how to fish.

Cor

"Mick Walker" <Mi*********@privacy.netschreef in bericht
news:5d*************@mid.individual.net...

>I have a collection of objects populated from a SQL Server (sorted
descending). Each of these object has a date field.

I need a way to loop through these object starting from the newest entry,
and finishing at the last, and output them in the format:

June 2007
Item
Item
Item
May 2007
Item
Item
...
...
...
...
December 2006
Item
Item
.... and so on.

I have no idea how to achieve this, so if someone could help me that would
be great.

[Mick Walker]

Cor Ligthert [MVP] wrote:

Mick,

Probably I would try to get the Top 1 record, using the Execute Scalar,
order the table by the DateTime and where the date is than the previous
date.

Avoiding to give you the fish but help you to learn how to fish.

Cor

Thanks for your reply Cor.
However I am still no wiser at the moment. I know what I wish to do, I
am just unsure of how to do it.

I need to loop though my collection,

Process Items Which Are in current Month
Write Heading
Write Items
Process Items Which Are in current Month -1
Write Heading
Write Items
Process Items Which Are in current Month -2
Write Heading
Write Items
Process Items Which Are in current Month -3
Write Heading
Write Items

......
I would like to keep the result set to a max of 6 months.

Any ideas?

Regards
Mick

[=?ISO-8859-1?Q?G=F6ran_Andersson?=]

Mick Walker wrote:

I have a collection of objects populated from a SQL Server (sorted
descending). Each of these object has a date field.

I need a way to loop through these object starting from the newest
entry, and finishing at the last, and output them in the format:

June 2007
Item
Item
Item
May 2007
Item
Item
...
...
...
...
December 2006
Item
Item
.... and so on.

I have no idea how to achieve this, so if someone could help me that
would be great.

Keep track of the year and month, and check against each item that you
output. When it changes, output a new header.

--
Göran Andersson
_____
http://www.guffa.com

[Mr. Arnold]

"Mick Walker" <Mi*********@privacy.netwrote in message
news:5d*************@mid.individual.net...

Cor Ligthert [MVP] wrote:

>Mick,

Probably I would try to get the Top 1 record, using the Execute Scalar,
order the table by the DateTime and where the date is than the previous
date.

Avoiding to give you the fish but help you to learn how to fish.

Cor

Thanks for your reply Cor.
However I am still no wiser at the moment. I know what I wish to do, I am
just unsure of how to do it.

I need to loop though my collection,

Process Items Which Are in current Month
Write Heading
Write Items
Process Items Which Are in current Month -1
Write Heading
Write Items
Process Items Which Are in current Month -2
Write Heading
Write Items
Process Items Which Are in current Month -3
Write Heading
Write Items

What do you mean? Are you talking about looping through a collection class
with a collection of objects.

If that's what you're talking about then you use a Foreach loop

Foreach item as theobject in Collection

if item.Date = current Month then
do something
endif

if item.Date = current Month -1 then
do something
endif
next

Or if you're talking about a SQL recordset, then you use a ADO.Net
Datareader and loop through the resultset.

while dr Not EOF
if dr.Date = current Month then
do something
endif
loop

It's really not clear as to what you're asking.

[Cor Ligthert [MVP]]

Mick,

Something like this, executed with a command.executescalar seems proper for
me.
(where here the orders from the Northwind database is used)
Select Top 1 OrderDate From Orders Where OrderDate @previousdate' Order By
OrderDate

Cor

"Mick Walker" <Mi*********@privacy.netschreef in bericht
news:5d*************@mid.individual.net...

Cor Ligthert [MVP] wrote:

>Mick,

Probably I would try to get the Top 1 record, using the Execute Scalar,
order the table by the DateTime and where the date is than the previous
date.

Avoiding to give you the fish but help you to learn how to fish.

Cor

Thanks for your reply Cor.
However I am still no wiser at the moment. I know what I wish to do, I am
just unsure of how to do it.

I need to loop though my collection,

Process Items Which Are in current Month
Write Heading
Write Items
Process Items Which Are in current Month -1
Write Heading
Write Items
Process Items Which Are in current Month -2
Write Heading
Write Items
Process Items Which Are in current Month -3
Write Heading
Write Items

.....
I would like to keep the result set to a max of 6 months.

Any ideas?

Regards
Mick

[SteveO]

On Jun 16, 6:44 pm, Mick Walker <[e-mail]:

I have a collection of objects populated from a SQL Server (sorted
descending). Each of these object has a date field.

I need a way to loop through these object starting from the newest
entry, and finishing at the last, and output them in the format:

June 2007
Item
Item
Item
May 2007
Item
Item
...
...
...
...
December 2006
Item
Item
.... and so on.

I have no idea how to achieve this, so if someone could help me that
would be great.

Try this:

dim tempDate as item(1).date

do while tempDate < item(n).date
...
tempDate = tempDate.addDays(1)
loop

and so on...