Q: Hours

[Geoff Jones]

Hi

I'm hoping that somebody can help me with the following question.

I have a DataView which contains a column which contains a Time.

I would like to create an array which will store the times within one hour.
For example, all the times between 12:00 and 13:00 will be placed in one
index of the array, all the calls from 13:00 to 14:00 will be placed in the
next.

Can anybody give me some code to do this?

Thanks in advance

Geoff

[Jay B. Harlow [MVP - Outlook]]

Geoff,
Just out of curiosity, why have you moved to the
microsoft.public.dotnet.languages.csharp newsgroup?

Do you really want this part in csharp or would you like VB.NET like the
rest has been?

Can you define a little better what "all the times between" means? Do you
mean all the DataRows that fall within that time frame or ever minute
(outside of the rows) that falls within that range?

Just curious
Jay

"Geoff Jones" <ge***@NODAMNSPAM.com> wrote in message
news:40*********************@news.dial.pipex.com.. .

Hi

I'm hoping that somebody can help me with the following question.

I have a DataView which contains a column which contains a Time.

I would like to create an array which will store the times within one hour. For example, all the times between 12:00 and 13:00 will be placed in one
index of the array, all the calls from 13:00 to 14:00 will be placed in the next.

Can anybody give me some code to do this?

Thanks in advance

Geoff

[Geoff Jones]

Hi Jay

VB has been put on hold for now. I'm trying to work on some C# now (oh joy!)
LOL

Sorry I didn't make the original post very clear. Suppose I have a list of
dates as follows:

15:02, 09:23, 14:34, 17:02, 15:45, etc.

These would be in order i.e. each one would have its own unique identifier
in terms of order e.g. 15:02 is 1, 09:23 is 2 etc.

I'd like to be able to create an array that would, for example, have:

index 0 having all the items in the list with times from 01:00 to 02:00 (but
not including)
index 1 having all the items in the list with times from from 02:00 to 03:00
(but not including)

etc.

Interested in hearing your thoughts

Geoff

"Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in message
news:eB**************@TK2MSFTNGP09.phx.gbl...

Geoff,
Just out of curiosity, why have you moved to the
microsoft.public.dotnet.languages.csharp newsgroup?

Do you really want this part in csharp or would you like VB.NET like the
rest has been?

Can you define a little better what "all the times between" means? Do you
mean all the DataRows that fall within that time frame or ever minute
(outside of the rows) that falls within that range?

Just curious
Jay

"Geoff Jones" <ge***@NODAMNSPAM.com> wrote in message
news:40*********************@news.dial.pipex.com.. .

Hi

I'm hoping that somebody can help me with the following question.

I have a DataView which contains a column which contains a Time.

I would like to create an array which will store the times within one

hour.

For example, all the times between 12:00 and 13:00 will be placed in one
index of the array, all the calls from 13:00 to 14:00 will be placed in

the

next.

Can anybody give me some code to do this?

Thanks in advance

Geoff

[Adlai Stevenson]

Geoff Jones wrote:

Hi

I'm hoping that somebody can help me with the following question.

I have a DataView which contains a column which contains a Time.

I would like to create an array which will store the times within one hour.
For example, all the times between 12:00 and 13:00 will be placed in one
index of the array, all the calls from 13:00 to 14:00 will be placed in the
next.

Can anybody give me some code to do this?

That is the simplest thing in the world.

Read an article or two and you'll have it.

[Jay B. Harlow [MVP - Outlook]]

Geoff,
I would use an array of arrays or an array of ArrayLists.

I would expect index 0 be from midnight to 1:00?

Then you can simply use the hour of the Time (DateTime.Hour) as your index,
and use ArrayList.Add to add the time to that row...

Hope this helps
Jay

"Geoff Jones" <ge***@NODAMNSPAM.com> wrote in message
news:40*********************@news.dial.pipex.com.. .

Hi Jay

VB has been put on hold for now. I'm trying to work on some C# now (oh joy!) LOL

Sorry I didn't make the original post very clear. Suppose I have a list of
dates as follows:

15:02, 09:23, 14:34, 17:02, 15:45, etc.

These would be in order i.e. each one would have its own unique identifier
in terms of order e.g. 15:02 is 1, 09:23 is 2 etc.

I'd like to be able to create an array that would, for example, have:

index 0 having all the items in the list with times from 01:00 to 02:00 (but not including)
index 1 having all the items in the list with times from from 02:00 to 03:00 (but not including)

etc.

Interested in hearing your thoughts

Geoff

"Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in message
news:eB**************@TK2MSFTNGP09.phx.gbl...

Geoff,
Just out of curiosity, why have you moved to the
microsoft.public.dotnet.languages.csharp newsgroup?

Do you really want this part in csharp or would you like VB.NET like the
rest has been?

Can you define a little better what "all the times between" means? Do you mean all the DataRows that fall within that time frame or ever minute
(outside of the rows) that falls within that range?

Just curious
Jay

"Geoff Jones" <ge***@NODAMNSPAM.com> wrote in message
news:40*********************@news.dial.pipex.com.. .

Hi

I'm hoping that somebody can help me with the following question.

I have a DataView which contains a column which contains a Time.

I would like to create an array which will store the times within one

hour.

For example, all the times between 12:00 and 13:00 will be placed in one index of the array, all the calls from 13:00 to 14:00 will be placed

in the

next.

Can anybody give me some code to do this?

Thanks in advance

Geoff

[Geoff Jones]

That helps a lot. Thanks Jay

As you can gather, I'm very new to programming. Your help and others is
invaluable during my steep learning curve.

One question that occurs to me now how to tell the ListArray what values I
need to store. I know for an array this can be done as:

Dim x() As Integer

However, and forgive me if this is wrong, I set up an array of an ListArray
by

Dim y() As ListArray

but that doesn't say if it holds strings, doubles or integers etc.

Can you help?

Geoff

"Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in message
news:uz**************@TK2MSFTNGP11.phx.gbl...

Geoff,
I would use an array of arrays or an array of ArrayLists.

I would expect index 0 be from midnight to 1:00?

Then you can simply use the hour of the Time (DateTime.Hour) as your index, and use ArrayList.Add to add the time to that row...

Hope this helps
Jay

"Geoff Jones" <ge***@NODAMNSPAM.com> wrote in message
news:40*********************@news.dial.pipex.com.. .

Hi Jay

VB has been put on hold for now. I'm trying to work on some C# now (oh

joy!)

LOL

Sorry I didn't make the original post very clear. Suppose I have a list of

dates as follows:

15:02, 09:23, 14:34, 17:02, 15:45, etc.

These would be in order i.e. each one would have its own unique identifier in terms of order e.g. 15:02 is 1, 09:23 is 2 etc.

I'd like to be able to create an array that would, for example, have:

index 0 having all the items in the list with times from 01:00 to 02:00

(but

not including)
index 1 having all the items in the list with times from from 02:00 to

03:00

(but not including)

etc.

Interested in hearing your thoughts

Geoff

"Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in message news:eB**************@TK2MSFTNGP09.phx.gbl...

Geoff,
Just out of curiosity, why have you moved to the
microsoft.public.dotnet.languages.csharp newsgroup?

Do you really want this part in csharp or would you like VB.NET like the rest has been?

Can you define a little better what "all the times between" means? Do

you mean all the DataRows that fall within that time frame or ever minute
(outside of the rows) that falls within that range?

Just curious
Jay

"Geoff Jones" <ge***@NODAMNSPAM.com> wrote in message
news:40*********************@news.dial.pipex.com.. .
> Hi
>
> I'm hoping that somebody can help me with the following question.
>
> I have a DataView which contains a column which contains a Time.
>
> I would like to create an array which will store the times within one hour.
> For example, all the times between 12:00 and 13:00 will be placed in one > index of the array, all the calls from 13:00 to 14:00 will be placed in the
> next.
>
> Can anybody give me some code to do this?
>
> Thanks in advance
>
> Geoff
>
>

[Jay B. Harlow [MVP - Outlook]]

Geoff,

but that doesn't say if it holds strings, doubles or integers etc. ArrayList holds objects, when you take a value out you need to cast the
value to the specific type you put in.

If you want strongly typed, either use pure arrays, either:

Dim y()() As DateTime ' Array of Arrays of DateTime

Dim x(,) As DateTime ' 2 dimensional

The "problem" with both of these is that both dimensions are "fixed",
System.Collections.ArrayList is dynamic, in that you can add elements to it.

If you want a strongly typed "ArrayList" you can inherit from
System.Collections.CollectionBase and create a strongly typed list.

NOTE: VS.NET 2005 (.NET 2.0) (Whidbey) due out sometime next year, will
support Generics so it will be easier to get an array of list of datetime...

Hope this helps
Jay

"Geoff Jones" <ge***@NODAMNSPAM.com> wrote in message
news:40*********************@news.dial.pipex.com.. . That helps a lot. Thanks Jay

As you can gather, I'm very new to programming. Your help and others is
invaluable during my steep learning curve.

One question that occurs to me now how to tell the ListArray what values I
need to store. I know for an array this can be done as:

Dim x() As Integer

However, and forgive me if this is wrong, I set up an array of an ListArray by

Dim y() As ListArray

but that doesn't say if it holds strings, doubles or integers etc.

Can you help?

Geoff

"Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in message
news:uz**************@TK2MSFTNGP11.phx.gbl...

Geoff,
I would use an array of arrays or an array of ArrayLists.

I would expect index 0 be from midnight to 1:00?

Then you can simply use the hour of the Time (DateTime.Hour) as your

index,

and use ArrayList.Add to add the time to that row...

Hope this helps
Jay

<<snip>>

[Geoff Jones]

Ah, ok, it is because you can put anything in? Like an STL vector?

"Geoff Jones" <ge***@NODAMNSPAM.com> wrote in message
news:40*********************@news.dial.pipex.com.. .

That helps a lot. Thanks Jay

As you can gather, I'm very new to programming. Your help and others is
invaluable during my steep learning curve.

One question that occurs to me now how to tell the ListArray what values I
need to store. I know for an array this can be done as:

Dim x() As Integer

However, and forgive me if this is wrong, I set up an array of an ListArray by

Dim y() As ListArray

but that doesn't say if it holds strings, doubles or integers etc.

Can you help?

Geoff

"Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in message
news:uz**************@TK2MSFTNGP11.phx.gbl...

Geoff,
I would use an array of arrays or an array of ArrayLists.

I would expect index 0 be from midnight to 1:00?

Then you can simply use the hour of the Time (DateTime.Hour) as your index,

and use ArrayList.Add to add the time to that row...

Hope this helps
Jay

"Geoff Jones" <ge***@NODAMNSPAM.com> wrote in message
news:40*********************@news.dial.pipex.com.. .

Hi Jay

VB has been put on hold for now. I'm trying to work on some C# now (oh

joy!)

LOL

Sorry I didn't make the original post very clear. Suppose I have a list of

dates as follows:

15:02, 09:23, 14:34, 17:02, 15:45, etc.

These would be in order i.e. each one would have its own unique identifier in terms of order e.g. 15:02 is 1, 09:23 is 2 etc.

I'd like to be able to create an array that would, for example, have:

index 0 having all the items in the list with times from 01:00 to

02:00

(but

not including)
index 1 having all the items in the list with times from from 02:00 to

03:00

(but not including)

etc.

Interested in hearing your thoughts

Geoff

"Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in message news:eB**************@TK2MSFTNGP09.phx.gbl...
> Geoff,
> Just out of curiosity, why have you moved to the
> microsoft.public.dotnet.languages.csharp newsgroup?
>
> Do you really want this part in csharp or would you like VB.NET like the > rest has been?
>
> Can you define a little better what "all the times between" means?

Do you

> mean all the DataRows that fall within that time frame or ever

minute > (outside of the rows) that falls within that range?
>
> Just curious
> Jay
>
> "Geoff Jones" <ge***@NODAMNSPAM.com> wrote in message
> news:40*********************@news.dial.pipex.com.. .
> > Hi
> >
> > I'm hoping that somebody can help me with the following question.
> >
> > I have a DataView which contains a column which contains a Time.
> >
> > I would like to create an array which will store the times within

one > hour.
> > For example, all the times between 12:00 and 13:00 will be placed

in one

> > index of the array, all the calls from 13:00 to 14:00 will be

placed in

> the
> > next.
> >
> > Can anybody give me some code to do this?
> >
> > Thanks in advance
> >
> > Geoff
> >
> >
>
>

[Geoff Jones]

Jay

One final question

I've tried the following just to test a few ideas:

Dim x(10) As ArrayList

x(0).Add(7)

Debug.WriteLine(CInt(x(0).Item(0))

thinking that this would print the integer 7.

However, I get an exception i.e. Object reference not set to an instance of
an object

Hope you can help.

Geoff

"Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in message
news:u0**************@TK2MSFTNGP11.phx.gbl...

Geoff,

but that doesn't say if it holds strings, doubles or integers etc. ArrayList holds objects, when you take a value out you need to cast the
value to the specific type you put in.

If you want strongly typed, either use pure arrays, either:

Dim y()() As DateTime ' Array of Arrays of DateTime

Dim x(,) As DateTime ' 2 dimensional

The "problem" with both of these is that both dimensions are "fixed",
System.Collections.ArrayList is dynamic, in that you can add elements to

it.
If you want a strongly typed "ArrayList" you can inherit from
System.Collections.CollectionBase and create a strongly typed list.

NOTE: VS.NET 2005 (.NET 2.0) (Whidbey) due out sometime next year, will
support Generics so it will be easier to get an array of list of datetime...
Hope this helps
Jay

"Geoff Jones" <ge***@NODAMNSPAM.com> wrote in message
news:40*********************@news.dial.pipex.com.. .

That helps a lot. Thanks Jay

As you can gather, I'm very new to programming. Your help and others is
invaluable during my steep learning curve.

One question that occurs to me now how to tell the ListArray what values I need to store. I know for an array this can be done as:

Dim x() As Integer

However, and forgive me if this is wrong, I set up an array of an

ListArray

by

Dim y() As ListArray

but that doesn't say if it holds strings, doubles or integers etc.

Can you help?

Geoff

"Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in message news:uz**************@TK2MSFTNGP11.phx.gbl...

Geoff,
I would use an array of arrays or an array of ArrayLists.

I would expect index 0 be from midnight to 1:00?

Then you can simply use the hour of the Time (DateTime.Hour) as your

index,

and use ArrayList.Add to add the time to that row...

Hope this helps
Jay

<<snip>>

[Jay B. Harlow [MVP - Outlook]]

Geoff,
Doh!

I forgot to mention you need to initialize each element of your array as
ArrayList is a reference type.

For index As Integer = 0 to 10
x(index) = New ArrayList()
Next

Hope this helps
Jay

"Geoff Jones" <ge***@NODAMNSPAM.com> wrote in message
news:40*********************@news.dial.pipex.com.. .

Jay

One final question

I've tried the following just to test a few ideas:

Dim x(10) As ArrayList

x(0).Add(7)

Debug.WriteLine(CInt(x(0).Item(0))

thinking that this would print the integer 7.

However, I get an exception i.e. Object reference not set to an instance of an object

Hope you can help.

Geoff

"Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in message
news:u0**************@TK2MSFTNGP11.phx.gbl...

Geoff,

but that doesn't say if it holds strings, doubles or integers etc. ArrayList holds objects, when you take a value out you need to cast the
value to the specific type you put in.

If you want strongly typed, either use pure arrays, either:

Dim y()() As DateTime ' Array of Arrays of DateTime

Dim x(,) As DateTime ' 2 dimensional

The "problem" with both of these is that both dimensions are "fixed",
System.Collections.ArrayList is dynamic, in that you can add elements to

it.

If you want a strongly typed "ArrayList" you can inherit from
System.Collections.CollectionBase and create a strongly typed list.

NOTE: VS.NET 2005 (.NET 2.0) (Whidbey) due out sometime next year, will
support Generics so it will be easier to get an array of list of

datetime...

Hope this helps
Jay

"Geoff Jones" <ge***@NODAMNSPAM.com> wrote in message
news:40*********************@news.dial.pipex.com.. .

That helps a lot. Thanks Jay

As you can gather, I'm very new to programming. Your help and others is invaluable during my steep learning curve.

One question that occurs to me now how to tell the ListArray what

values I need to store. I know for an array this can be done as:

Dim x() As Integer

However, and forgive me if this is wrong, I set up an array of an

ListArray

by

Dim y() As ListArray

but that doesn't say if it holds strings, doubles or integers etc.

Can you help?

Geoff

"Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in message news:uz**************@TK2MSFTNGP11.phx.gbl...
> Geoff,
> I would use an array of arrays or an array of ArrayLists.
>
> I would expect index 0 be from midnight to 1:00?
>
> Then you can simply use the hour of the Time (DateTime.Hour) as your
index,
> and use ArrayList.Add to add the time to that row...
>
> Hope this helps
> Jay
>

<<snip>>

[Geoff Jones]

Thanks Jay. It works a treat!

Geoff

"Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in message
news:ur**************@TK2MSFTNGP10.phx.gbl...

Geoff,
Doh!

I forgot to mention you need to initialize each element of your array as
ArrayList is a reference type.

For index As Integer = 0 to 10
x(index) = New ArrayList()
Next

Hope this helps
Jay

"Geoff Jones" <ge***@NODAMNSPAM.com> wrote in message
news:40*********************@news.dial.pipex.com.. .

Jay

One final question

I've tried the following just to test a few ideas:

Dim x(10) As ArrayList

x(0).Add(7)

Debug.WriteLine(CInt(x(0).Item(0))

thinking that this would print the integer 7.

However, I get an exception i.e. Object reference not set to an instance

of

an object

Hope you can help.

Geoff

"Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in message

news:u0**************@TK2MSFTNGP11.phx.gbl...

Geoff,
> but that doesn't say if it holds strings, doubles or integers etc.
ArrayList holds objects, when you take a value out you need to cast the value to the specific type you put in.

If you want strongly typed, either use pure arrays, either:

Dim y()() As DateTime ' Array of Arrays of DateTime

Dim x(,) As DateTime ' 2 dimensional

The "problem" with both of these is that both dimensions are "fixed",
System.Collections.ArrayList is dynamic, in that you can add elements to

it.

If you want a strongly typed "ArrayList" you can inherit from
System.Collections.CollectionBase and create a strongly typed list.

NOTE: VS.NET 2005 (.NET 2.0) (Whidbey) due out sometime next year,

will support Generics so it will be easier to get an array of list of

datetime...

Hope this helps
Jay

"Geoff Jones" <ge***@NODAMNSPAM.com> wrote in message
news:40*********************@news.dial.pipex.com.. .
> That helps a lot. Thanks Jay
>
> As you can gather, I'm very new to programming. Your help and others

is > invaluable during my steep learning curve.
>
> One question that occurs to me now how to tell the ListArray what

values

I

> need to store. I know for an array this can be done as:
>
> Dim x() As Integer
>
> However, and forgive me if this is wrong, I set up an array of an
ListArray
> by
>
> Dim y() As ListArray
>
> but that doesn't say if it holds strings, doubles or integers etc.
>
> Can you help?
>
> Geoff
>
> "Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in

message

> news:uz**************@TK2MSFTNGP11.phx.gbl...
> > Geoff,
> > I would use an array of arrays or an array of ArrayLists.
> >
> > I would expect index 0 be from midnight to 1:00?
> >
> > Then you can simply use the hour of the Time (DateTime.Hour) as your > index,
> > and use ArrayList.Add to add the time to that row...
> >
> > Hope this helps
> > Jay
> >
<<snip>>