Counting instances in c# (keeping a tally)

[trd79]

Hi,

I am reading a database which is returning a list of dates. I need to count the instances of each date and store in an array or similar.
I don't know how many dates I will be getting, or how many different ones.

In Perl I would so something like this
for(`getdata`){
$array{$1}++;
}

need something that looks like this:

while (dReader.Read())
{
Array['dReader[0].ToString()']++;
}


Any ideas?

[r035198x]

Hi,

I am reading a database which is returning a list of dates. I need to count the instances of each date and store in an array or similar.
I don't know how many dates I will be getting, or how many different ones.

In Perl I would so something like this
for(`getdata`){
$array{$1}++;
}

need something that looks like this:

while (dReader.Read())
{
Array['dReader[0].ToString()']++;
}


Any ideas?

You could use a System.Collections.Hashtable<DateTime, int>.

[trd79]

You could use a System.Collections.Hashtable<DateTime, int>.

Many thanks,

will try that.

[trd79]

Hi,

Have tried using a hashtable as suggested.

Currently looks like this (and seems to work)

Hashtable sessions = new Hashtable();
while (dReader.Read())
        {
            DateTime date = DateTime.Parse(dReader[0].ToString());
            sessions[date] = (sessions.ContainsKey(date)) ? (int)sessions[date] + 1 : 1;
        }

Is this the best way of doing it?