ASP.net Looping through a Collection of Dates

  • Thread starter Thread starter Mick Walker
  • Start date Start date
M

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.
 
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:
Click to expand...


In your SQL statement, sort the list by date. Then use a datareader (or
dataset) to output the data.
 
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
 
Cor said:
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
Click to expand...
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
 
Mick said:
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.
Click to expand...

Keep track of the year and month, and check against each item that you
output. When it changes, output a new header.
 
Mick Walker said:
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
Click to expand...

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.
 
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
 
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.
Click to expand...


Try this:

dim tempDate as item(1).date

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

and so on...
 
Back
Top